You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true? (Choose three.)
You own table DEPARTMENTS, referenced by views, indexes, and synonyms.
Examine this command which executes successfully:
DROP TABLE departments PURGE;
Which three statements are true? (Choose three.)
The DROP TABLE departments PURGE command removes the DEPARTMENTS table from the database, along with all indexes on it. Additionally, it ensures that the table cannot be recovered and the action cannot be rolled back. Although views and synonyms referencing the table become invalid, they are not removed by this command.
ABE. Note: Synoyms and views will get invalid, Indexes will be dropped along with the table and data will be purged and free space will be regained, dropped table can not be recovered even if you use flashback table command
In ORACLE SQL, you own table DEPARTMENTS, referenced by views, indexes, and synonyms. Examine this command which executes successfully: DROP TABLE departments PURGE; Which three statements are true? (Choose three.) A. It will remove the DEPARTMENTS table from the database. (True) B. It will drop all indexes on the DEPARTMENTS table. (True) C. It will remove all views that are based on the DEPARTMENTS table. (False, it will not remove the views that are based on the DEPARTMENTS table) D. It will remove all synonyms for the DEPARTMENTS table. (False, it will not remove the synonyms for the DEPARTMENTS table) E. Neither can it be rolled back nor can the DEPARTMENTS table be recovered. (True) F. It will delete all rows from the DEPARTMENTS table, but retain the empty table. (False, it will delete all rows and the table itself)
ABE are correct. Views and synonyms are not dropped with the table
A, B, E https://docs.oracle.com/database/121/SQLRF/statements_9003.htm#SQLRF01806
https://docs.oracle.com/cd/E18283_01/server.112/e17120/tables010.htm
A,D,E - correct answer
https://docs.oracle.com/database/121/SQLRF/statements_9003.htm#SQLRF01806
ABE is correct
ABE is correct answers
ABE is the answer
ABE IS CORRECT.
ABE correct answers