READ Free Dumps For Oracle- 1z0-007
Question ID 1712 | Which two statements are true about constraints? (Choose two.) |
Option A | A. A UNIQUE index gets created for columns with PRIMARY KEY and UNIQUE constraints. |
Option B | B. The NOT NULL constraint ensures that null values are not permitted for the column. |
Option C | C. The UNIQUE constraint does not permit a null value for the column. |
Option D | D. The PRIMARY KEY and FOREIGN KEY constraints create a UNIQUE index. |
Correct Answer | A,B |
Question ID 1713 | Examine the description of the EMPLOYEES table: |
Option A | A. SELECT COUNT(dept_id) FROM employees |
Option B | B. SELECT COUNT(*) FROM employees |
Option C | C. SELECT UNIQUE(dept_id) FROM employees |
Option D | D. SELECT DISTINCT(COUNT(dept_id)) FROM employees |
Correct Answer | C |