READ Free Dumps For Oracle- 1z1-051
| Question ID 4978 |
|
| Option A | A. It produces an error because all columns used in the NATURAL join should have a qualifier |
| Option B | B. It produces an error because a column used in the NATURAL join cannot have a qualifier |
| Option C | C. It produces an error because the NATURAL join can be used only with two tables |
| Option D | D. It executes successfully |
| Correct Answer | B |
| Question ID 4979 | Evaluate the following SQL statements: |
| Option A | A. The BETWEEN clause cannot be used for the CHECK constraint |
| Option B | B. SYSDATE cannot be used with the CHECK constraint |
| Option C | C. ORD_NO and ITEM_NO cannot be used as a composite primary key because ORD_NO is also the FOREIGN KEY |
| Option D | D. The CHECK constraint cannot be placed on columns having the DATE data type |
| Correct Answer | B |
