READ Free Dumps For Oracle- 1z0-007
Question ID 1696 | You need to create a view EMP_VU. The view should allow the users to manipulate the records of only the employees that are working for departments 10 or 20. Which SQL statement would you use to create the view EMP VU? |
Option A | A. CREATE VIEW emp_vu AS SELECT * |
Option B | B. CREATE VIEW emp_vu AS SELECT * |
Option C | C. CREATE VIEW emp_vu AS SELECT * |
Option D | D. CREATE FORCE VIEW emp_vu AS SELECT * |
Correct Answer | C |
Question ID 1697 | Which two statements complete a transaction? (Choose two.) |
Option A | A. ROLLBACK TO SAVEPOINT C; |
Option B | B. SELECT MAX(sal) |
Option C | C. GRANT SELECT ON employees TO SCOTT; |
Option D | D. DESCRIBE employees; |
Option E | E. ALTER TABLE employees SET UNUSED COLUMN sal; |
Correct Answer | C,E |