READ Free Dumps For Oracle- 1z1-051
Question ID 4777 | Which statements are correct regarding indexes? (Choose all that apply.) |
Option A | A. For each data manipulation language operation performed, the corresponding indexes are automatically updated |
Option B | B. A no deferrable PRIMARY KEY or UNIQUE KEY constraint in a table automatically creates a unique index |
Option C | C. A FOREIGN KEY constraint on a column in a table automatically creates a non unique key |
Option D | D. When a table is dropped, the corresponding indexes are automatically dropped |
Correct Answer | A,B,D |
Question ID 4778 | You work as a database administrator at ABC.com. You study the exhibit carefully. |
Option A | A. UPDATE promotions |
Option B | B. SELECT promo_begin_date FROM promotions |
Option C | C. UPDATE promotions |
Option D | D. SELECT TO_CHAR(promo_begin_date,'dd/month') |
Correct Answer | A,B |