Managing Indexes MCQs
Managing Indexes MCQs
The following Managing Indexes MCQs have been compiled by our experts through research, in order to test your knowledge of the subject of Managing Indexes. We encourage you to answer these multiple-choice questions to assess your proficiency.
Please continue by scrolling down.
1: While Consider Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space?
A. Coalesce Index
B. Rebuild Index
C. Rebuild Index And Coalesce Index
D. None
2: If a table is dropped, all associated indexes are dropped automatically?
A. True
B. False
3: To create an index in your own schema, give the following conditions which is true?
A. The table or cluster to be indexed is in another schema
B. None
C. You don’t have INDEX privilege on the table to be indexed
D. You have CREATE ANY INDEX system privilege
4: Because indexes created using NOLOGGING are not archived, perform a backup after you create the index?
A. False
B. True
5: Creating an index using key compression enables you to eliminate repeated occurrences of key column prefix values?
A. False
B. True
6: CREATE INDEX does not stores the timestamp of the most recent function used in the function-based index?
A. False
B. True
7: Which key automatically have indexes, but you might want to create an index on a foreign key?
A. Primary
B. None
C. Primary And Unique
D. UNIQUE
8: Creating an index with NOLOGGING has which of these benefits?
A. Space is saved in the redo log files
B. Performance improves for parallel creation of large indexes
C. All
D. The time it takes to create the index is decreased
9: If you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints, the database lets you?
A. Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint
B. Specify a new index that the database is to use to enforce the constraint
C. None
10: To use a function-based index?
A. None
B. The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes
C. The table must be analyzed after the index is created
11: An index can be created ____.
A. implicitly
B. Explicitly
C. Only at instance startup
D. both a and b
List of Managing Indexes MCQs ...
Available in:
Managing Indexes MCQs
