Home » SQL & PL/SQL » SQL & PL/SQL » DROP TABLE DEPT - dependencies (Oracle 10g)
DROP TABLE DEPT - dependencies [message #417833] Tue, 11 August 2009 12:46 Go to next message
k_sakthivel
Messages: 1
Registered: August 2009
Location: Hyderabad
Junior Member

Evaluate the SQL statement
DROP TABLE DEPT

Which four statements are true of the SQL statement?
A. You cannot roll back this statement.
B. All pending transactions are committed.
C. Al views based on the DEPT table are deleted.
D. All indexes based on the DEPT table are dropped.
E. All data in the table is deleted, and the table structure is also deleted.
F.All data in the table is deleted, but the structure of the table is retained.
G.All synonyms based on the DEPT table are deleted.

and give comments here..

[Updated on: Tue, 11 August 2009 12:48] by Moderator

Report message to a moderator

Re: DROP TABLE DEPT - dependencies [message #417834 is a reply to message #417833] Tue, 11 August 2009 12:50 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
What is your answer?
clue: DDL is an implicit commit.

By
Vamsi
Re: DROP TABLE DEPT - dependencies [message #417835 is a reply to message #417833] Tue, 11 August 2009 12:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
and give comments here..

Give YOUR anwers and comments.

By the way, this is NOT the place to put an advert for your blog (I remove it). This is viewed as SPAM.
Do it in Marketplace forum.
Read OraFAQ Forum Guide.

Regards
Michel

[Updated on: Tue, 11 August 2009 12:54]

Report message to a moderator

Re: DROP TABLE DEPT - dependencies [message #417949 is a reply to message #417833] Wed, 12 August 2009 04:37 Go to previous message
bishtoo
Messages: 20
Registered: August 2009
Junior Member
Drop is a DDL command so it cant be rolled back.
Data+Structure is removed.
All indexes/constraints will also be removed.
View will remain but will not be usable.(invalid)
Synonyms are independent of base objects so i think they will remain.

Hope this answers your queries.
Previous Topic: Locking complete table
Next Topic: Using source index in Merge Statement
Goto Forum:
  


Current Time: Thu Dec 08 20:27:37 CST 2016

Total time taken to generate the page: 0.24339 seconds