 Related Questions Latest Answer : The database is actually a collection of objects, which are made up of tablespaces and each tablespace must have datafile associate with it. The tablespace cannot be created without datafile. The tablespaces are two kind physical and logical.The logical ... 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 : We can update the index by rebuilding it.Alter index indexname rebuilt ... Latest Answer : An index cluster uses an index to maintain data within the cluster. The structure of a cluster index is similar to a normal index. Although a normal index does not store NULL key values, and index cluster can store it. And, a cluster index ... Latest Answer : Oracle creates the index segment for an index or an index partition when you issue the CREATE INDEX statement. In this statement, you can specify storage parameters for the extents of the index segment and a tablespace in which to create the index segment. ... Latest Answer : SGA+Background Process = InstanceAs soon as user process starts and server process takes control from user process, instance created with help of background processes and most important background processes are dbwriter, logwriter, checkpoint, SMON, PMON ... 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 ... 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 ... A database instance (Server) is a set of memory structure and background processes that access a set of database files. The process can be shared by all users. The Latest Answer : Database instance(server) is the combination of memory structure and background process. It's a way to connect to the oracle database. ... 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
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
