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.
B.
It will drop all indexes on the DEPARTMENTS table.
C.
It will remove all views that are based on the DEPARTMENTS table.
D.
It will remove all synonyms for the DEPARTMENTS table.
E.
Neither can it be rolled back nor can the DEPARTMENTS table be recovered.
F.
It will delete all rows from the DEPARTMENTS table, but retain the empty table.
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)
A, B, E
https://docs.oracle.com/database/121/SQLRF/statements_9003.htm#SQLRF01806
upvoted 1 times
...
Log in to ExamTopics
Sign in:
Community vote distribution
A (35%)
C (25%)
B (20%)
Other
Most Voted
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Lee_jong_suk
Highly Voted 9 months, 4 weeks agopushpaksarode
Most Recent 3 days, 23 hours agoalelejaja
4 months, 1 week agoRik92
1 year, 3 months agoNelita
1 year, 4 months agokuff
1 year, 4 months agoOrxan_H
1 year, 5 months agoAc37
1 year, 6 months agojfc1
1 year, 6 months agoalic_alex
1 year, 7 months agosubtype11
1 year, 8 months agosubtype11
1 year, 8 months agoheoj10272
1 year, 11 months ago