READ Free Dumps For Oracle- 1z1-051
Question ID 4948 | Which two statements are true about constraints? (Choose two.) |
Option A | A. The UNIQUE constraint does not permit a null value for the column. |
Option B | B. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. |
Option C | C. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. |
Option D | D. The NOT NULL constraint ensures that null values are not permitted for the column. |
Correct Answer | B,D |
Question ID 4949 | Which three are true? (Choose three.) |
Option A | A. A MERGE statement is used to merge the data of one table with data from another. |
Option B | B. A MERGE statement replaces the data of one table with that of another. |
Option C | C. A MERGE statement can be used to insert new rows into a table. |
Option D | D. A MERGE statement can be used to update existing rows in a table. |
Correct Answer | A,C,D |