READ Free Dumps For Oracle- 1z1-051
| Question ID 4743 | Which two statements are true regarding constraints? (Choose two.) |
| Option A | A. A constraint can be disabled even if the constraint column contains data |
| Option B | B. A constraint is enforced only for the INSERT operation on a table |
| Option C | C. A foreign key cannot contain NULL values |
| Option D | D. All constraints can be defined at the column level as well as the table level |
| Option E | E. A columns with the UNIQUE constraint can contain NULL values |
| Correct Answer | A,E |
| Question ID 4744 | Which two statements are true about sequences created in a single instance database? (Choose two.) |
| Option A | A. CURRVAL is used to refer to the last sequence number that has been generated |
| Option B | B. DELETE <sequencename> would remove a sequence from the database |
| Option C | C. The numbers generated by a sequence can be used only for one table |
| Option D | D. When the MAXVALUE limit for a sequence for reached, you can increase the MAXVALUE limit by using the ALTER SEQUENCE statement |
| Option E | E. When a database instance shuts down abnormally, the sequence numbers that have been cached but not used would be available once again when the database instance is restarted |
| Correct Answer | A,D |