> > Oracle MCQs > Managing Indexes MCQs

Managing Indexes MCQ

An index can be created ____.

implicitly

Explicitly

Only at instance startup

both a and b

Answer

Correct Answer: implicitly

Note: This Question is unanswered, help us to find answer for this one

To use a function-based index?

None

The query must be guaranteed need NULL values from the indexed expression, since NULL values are not stored in indexes

The table must be analyzed after the index is created

Answer

Correct Answer: The table must be analyzed after the index is created

Note: This Question is unanswered, help us to find answer for this one

If you require more explicit control over the indexes associated with UNIQUE and PRIMARY KEY constraints, the database lets you?

Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint

Specify a new index that the database is to use to enforce the constraint

None

Answer

Correct Answer: Specify a CREATE INDEX statement that the database is to use to create the index and enforce the constraint

Note: This Question is unanswered, help us to find answer for this one

Creating an index with NOLOGGING has which of these benefits?

Space is saved in the redo log files

Performance improves for parallel creation of large indexes

All

The time it takes to create the index is decreased

Answer

Correct Answer: All

Note: This Question is unanswered, help us to find answer for this one

Which key automatically have indexes, but you might want to create an index on a foreign key?

Primary

None

Primary And Unique

UNIQUE

Answer

Correct Answer: Primary And Unique

Note: This Question is unanswered, help us to find answer for this one

CREATE INDEX does not stores the timestamp of the most recent function used in the function-based index?

False

True

Answer

Correct Answer: False

Note: This Question is unanswered, help us to find answer for this one

Creating an index using key compression enables you to eliminate repeated occurrences of key column prefix values?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

Because indexes created using NOLOGGING are not archived, perform a backup after you create the index?

False

True

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

To create an index in your own schema, give the following conditions which is true?

The table or cluster to be indexed is in another schema

None

You don’t have INDEX privilege on the table to be indexed

You have CREATE ANY INDEX system privilege

Answer

Correct Answer: You have CREATE ANY INDEX system privilege

Note: This Question is unanswered, help us to find answer for this one

If a table is dropped, all associated indexes are dropped automatically?

True

False

Answer

Correct Answer: True

Note: This Question is unanswered, help us to find answer for this one

While Consider Costs and Benefits of Coalescing or Rebuilding Indexes which has lower costs and does not require more disk space?

Coalesce Index

Rebuild Index

Rebuild Index And Coalesce Index

None

Answer

Correct Answer: Coalesce Index

Note: This Question is unanswered, help us to find answer for this one