READ Free Dumps For Oracle- 1z0-007
Question ID 1732 | A SELECT statement can be used to perform these three functions: |
Option A | A. intersection, projection, join |
Option B | B. selection, projection, join |
Option C | C. difference, projection, product |
Option D | D. selection, intersection, join |
Option E | E. difference, projection, join |
Correct Answer | B |
Question ID 1733 | Evaluate the SQL statement |
Option A | A. All synonyms based on the DEPT table are deleted. |
Option B | B. All indexes based on the DEPT table are dropped. |
Option C | C. All views based on the DEPT table are deleted. |
Option D | D. All pending transactions are committed. |
Option E | E. You cannot roll back this statement. |
Option F | F. All data in the table is deleted, and the table structure is also deleted. |
Correct Answer | B,D,E,F |