Answers

Question and Answer:

  Home  Oracle Certification

⟩ 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

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

 235 views

More Questions for you: