READ Free Dumps For Oracle- 1z1-051
Question ID 4765 | You issue the following command to drop the PRODUCTS table: |
Option A | A. All data in the table are deleted but the table structure will remain |
Option B | B. All data along with the table structure is deleted |
Option C | C. All view and synonyms will remain but they are invalidated |
Option D | D. The pending transaction in the session is committed |
Option E | E. All indexes on the table will remain but they are invalidated |
Correct Answer | B,C,D |
Question ID 4766 | Exhibit contains the structure of PRODUCTS table: |
Option A | A. It produces an error |
Option B | B. It shown the names of products whose list price is the second highest in the table |
Option C | C. It shown the names of all products whose list price is less than the maximum list price |
Option D | D. It shows the names of all products in the table |
Correct Answer | B |