READ Free Dumps For Oracle- 1z0-001
| Question ID 1481 | Which statement is true when a DROP TABLE command is executed on a table? |
| Option A | A. Any pending transactions on the table are rolled back. |
| Option B | B. The table structure and its deleted data cannot be rolled back and restored once the DROP TABLE command is executed. |
| Option C | C. The DROP TABLE command can be executed on a table on which there are pending transactions. |
| Option D | D. The structure of the table remains in the database, and the data and indexes are deleted. |
| Option E | E. Only a DBA can execute the DROP TABLE command. |
| Correct Answer | B |
| Question ID 1482 | Which statement about implicit cursors is true? |
| Option A | A. Programmers need to close all the implicit cursors before the end of the PL/SQL program. |
| Option B | B. Programmers can declare implicit cursors by using the CURSOR type in the declaration section. |
| Option C | C. Implicit cursors are declared implicitly only for DML statements. |
| Option D | D. Implicit cursors are declared implicitly for all the DML and SELECT statements. |
| Correct Answer | B |