READ Free Dumps For Oracle- 1z0-007
| Question ID 7971 | Which four are valid Oracle constraint types? (Choose four.)
|
| Option A | CASCADE
|
| Option B | UNIQUE
|
| Option C | NONUNIQUE
|
| Option D | CHECK
|
| Option E | PRIMARY KEY
|
| Option F | G. NOT NULL
|
| Correct Answer | BDEG |
Explanation Explanation/Reference: Explanation : Oracle constraint type is Not Null, Check, Primary Key, Foreign Key and Unique Incorrect answer: A Is not Oracle constraint C Is not Oracle constraint F Is not Oracle constraint Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 10-3
| Question ID 7972 | Which SQL statement would you use to remove a view called EMP_DEPT_VU from your schema?
|
| Option A | DROP emp_dept_uv;
|
| Option B | DELETE emp_dept_uv;
|
| Option C | REMOVE emp_dept_uv;
|
| Option D | DROP VIEW emp_dept_uv;
|
| Option E | DELETE VIEW emp_dept_uv;
|
| Option F | REMOVE VIEW emp_dept_uv;
|
| Correct Answer | D |
Explanation Explanation/Reference: Explanation : DROP VIEW viewname; Incorrect answer: A Not a valid drop view statement B Not a valid drop view statement C Not a valid drop view statement E Not a valid drop view statement F Not a valid drop view statement Refer : Introduction to Oracle9i : SQL, Oracle University Study Guide, 11-20