UGC NET CSE | June 2016 | Part 2 | Question: 19

Question

Consider the following two comments C1 and C2 on the relation R from an SQL database: 

C1 : drop table R;

C2 : delete from R

1. Both C1 and C2 delete the schema R
2. C2 retains relation  R, but delets all tuples in R
3. C1 deletes not only all tuples, but also the schema for R
   • A. I only
   • B. I and II only
   • C. II and III only
   • D. I, II and III only

Answer 1

Option c answer

Drop command remove all tuples of the relation as well as schema also

 Delete command in sql removes tuples from the relation  but retain the schema of table in database .