 Related Questions Latest Answer : Components of Physical database are:-1. Datafile - One or more2. Redo log file - Two or more3. Control File - Two or more ... Latest Answer : Oracle logical structure follows the order likeTablespaceSegments
ExtentsDatablocksOracle database consists of tablesapces (one or more tablespace forms database)
Segments is the area in which on oracle object sores in a tablespace.One Oracle object ... 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 : A sequence is a database object created by a user that can be used to generate unique integers. A typical usage of sequences is to generate primary key values which are unique for each row. It is generated and incremented (or decremented) by an ... Latest Answer : An Index is based on tree structre that allow direct access to a row in a table, oracle uses different type of index 1) B-Tree Index2) Bitmap Index ... Latest Answer : Index is an object in the oracle database used to speed up the performance of the queries ie. it improves the access speed and response of query will be good when the query makes use of Index.ThanksHarsha ... Latest Answer : It consists of - one or more data files - one or more control files - two or more redo log files The database contains - Multiple users/schema's - one or more rollback segments - one ... A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in Latest Answer : Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them by rolling back ... 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 ...
Sponsored Links
| |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
