Which of these must be performed to find or store a row in an indexed – McqOptions

MCQOPTIONS

1.	Which of these must be performed to find or store a row in an indexed table or cluster?
A.	One or more I/Os to find or store the key value in the index
B.	Another I/O to read or write the row in the table or cluster
C.	Both A & B
D.	None of the above
Answer» D. None of the above

Discussion

No Comment Found

Related MCQs

Which view describes all clusters in the database?
You are using flat files as the data source for one of your data warehousing applications. You plan to move the data from the flat file structures to an Oracle database to optimize the application performance. In your database you have clustered tables. While migrating the data, you want to have minimal impact on the database performance and optimize the data load operation. Which method would you use to load data into Oracle database?
Which command is used to drop HASH cluster?
What is the reason that SORT_AREA SIZE and HASH_AREA_SIZE parameters are ignored in some of the user sessions?
When creating a hash cluster, it is important to choose the cluster key correctly and set which of these parameters so that performance and space use are optimal?
In which of these situations hashing is not advantageous?
Which SYSTEM privilege must be used to create a cluster in another user's schema?
For maximum distribution of rows in a hash cluster, the database rounds the HASHKEYS value up to the nearest _________ .
You can create any cluster and associated cluster index in any tablespace that is _____ .
In a sorted hash cluster, the rows corresponding to each value of the hash function are sorted on a specified set of columns in which order and that can improve response time during subsequent operations on the clustered data?