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