Oracle Certification Exam Question:
Download Questions PDF

Explain Which statements are correct regarding indexes? (Choose all that apply.)
A. When a table is dropped, the corresponding indexes are automatically dropped
B. A FOREIGN KEY constraint on a column in a table automatically creates a nonunique key
C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a
unique index
D. For each data manipulation language operation performed, the corresponding indexes are
automatically updated

Answer:

A. When a table is dropped, the corresponding indexes are automatically dropped
C. A nondeferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a
unique index
D. For each data manipulation language operation performed, the corresponding indexes are
automatically updated

Download Oracle Certification Interview Questions And Answers PDF

Previous QuestionNext Question
Explain Which three statements/commands would cause a transaction to end? (Choose three.)
A. COMMIT
B. SELECT
C. CREATE
D. ROLLBACK
E. SAVEPOINT		Explain Which two statements are true regarding constraints? (Choose two.)
A. A foreign key cannot contain NULL values
B. A columns with the UNIQUE constraint can contain NULL values
C. A constraint is enforced only for the INSERT operation on a table
D. A constraint can be disabled even if the constraint column contains data
E. All constraints can be defined at the column level as well as the table level