Latest Answer : an oracle object contains information in rows and columns ...
Latest Answer : A view is a named query. It is “a tailored presentation of the data contained in one or more tables (or other views).” For SQL, view = a named or derived virtual table • For users, view = a table (which in fact does not exist!) • ...
Latest Answer : No, it does not contain own data ...
Latest Answer : Yes, a view can be based on another view. ...
An index is a database structure used by the server to have direct access of a row in a table. An index is automatically created when a unique of primary key constraint clause
Latest Answer : Indexes are used both to improve performence and to ensure uniquness of a column. Oracle automatically creates an index when a UNIQUE or PRIMARY key constarints clause is specified in a create table command.We can manually create our own indexes via the ...
It consists ofone or more data files.one or more control files.two or more redo log files.The Database containsmultiple users/schemasone or more rollback segmentsone or more tablespacesData dictionary
Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen
Latest Answer : Oracle automatically detect deadlock , but not occar ...
select segment_name,sum(bytes) from dba_segmentswhere segment_name='TABLE_NAME' AND OWNER='OWNER of the table'group by segment_name
Latest Answer : and adding to the previous...view are not physical entities like tables which occupy space in the database..they are logical and whenever you select, the query underlying the view gets fired and results are returned. Hence, you cannot get the space information ...
Enqueues are another type of locking mechanism used in Oracle. An enqueue is a more sophisticated mechanism which permits several concurrent processes to have varying degree of sharing of "known"
Latest Answer : An enqueue is a sophisticated locking mechanism that permits several concurrent processes to share known resources to varying degrees. Any object that can be used concurrently can be protected with enqueues. For example, Oracle allows varying levels of ...
This is extract from Oracle10g Advanced Replication Book. How Materialized Views Work with Object Types and CollectionsOracle object types are user-defined datatypes that make it possible to model complex
