READ Free Dumps For Oracle- 1z0-061
| Question ID 2313 | Which two statements are true regarding constraints? |
| Option A | A. A table can have only one primary key and one foreign key. |
| Option B | B. A table can have only one primary key but multiple foreign keys. |
| Option C | C. Only the primary key can be defined at the column and table levels. |
| Option D | D. The foreign key and parent table primary key must have the same name. |
| Option E | E. Both primary key and foreign key constraints can be defined at both column and table levels. |
| Correct Answer | B,E |
| Question ID 2314 | In which three situations does a transaction complete? |
| Option A | A. When a DELETE statement is executed |
| Option B | B. When a ROLLBACK command is executed |
| Option C | C. When a PL/SQL anonymous block is executed |
| Option D | D. When a data definition language (DDL) statement is executed |
| Option E | E. When a TRUNCATE statement is executed after the pending transaction |
| Correct Answer | B,D,E |