top button
Flag Notify
    Connect to us
      Facebook Login
      Site Registration Why to Join

Facebook Login
Site Registration

DROP TABLE CRICKET what does it mean?

0 votes
93 views

Evaluate DROP TABLE CRICKET .which one is true about this ?

a) all pending transactions are committed.
b) all views based on cricket table are deleted.
c) all data in the data table is deleted, but structure of the table is retained.
d) all synonyms based on the cricket table is deleted.

posted Jul 2, 2018 by anonymous

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

2 Answers

0 votes

b) all views based on cricket table are deleted.

When we execute the DROP TABLE CRICKET then all the contents of the table is deleted, all the dependency of the content is deleted (cascade effect) and table structure is deleted.

answer Jul 3, 2018 by Salil Agrawal
0 votes

Hello,
b) all view based on cricket table are deleted.

Table or Database deletion using DROP statement cannot be rolled back, so it must be used wisely.

answer Jul 18 by Siddhi Patel
Contact Us
+91 9880187415
sales@queryhome.net
support@queryhome.net
#280, 3rd floor, 5th Main
6th Sector, HSR Layout
Bangalore-560102
Karnataka INDIA.
QUERY HOME
...