Oracle
1Z0-071 · Question #104
You issue this command which succeeds: SQL> DROP TABLE products; Which three statements are true?
The correct answer is A. All existing views and synonyms that refer to the table are invalidated but retained. B. Any uncommitted transaction in the session is committed. C. Table data and the table structure are deleted. See the full explanation below for the reasoning.
Question
You issue this command which succeeds:
SQL> DROP TABLE products; Which three statements are true?
Options
- AAll existing views and synonyms that refer to the table are invalidated but retained.
- BAny uncommitted transaction in the session is committed.
- CTable data and the table structure are deleted.
- DAll the table's indexes if any exist, are invalidated but retained.
- ETable data is deleted but the table structure is retained.
How the community answered
(17 responses)- A76% (13)
- D6% (1)
- E18% (3)
Community Discussion
No community discussion yet for this question.