Register

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

• recategorized by
2,851 views
3 votes
3 votes

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
    1. I only
    2. I and II only
    3. II and III only
    4. I, II and III only
• recategorized by
User Avatar

1 Answer

Best answer
3 votes
3 votes
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 .
• selected by
User Avatar
Voting & Accepting an answer helps improve the community
Answer:
← PreviousNext →
← Previous in categoryNext in category →

Related questions

4 votes
4 votes
1 answer
2
go_editor asked Aug 14, 2016
2,591 views
UGC NET CSE | June 2016 | Part 2 | Question: 16
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as: Referential integrity Multi-valued dependency Entity integrity Functional dependency
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:Referential integrityMulti-valued dependencyEntity integrityFunctional dependency
User Avatar
7 votes
7 votes
2 answers
3
go_editor asked Aug 16, 2016
6,591 views
UGC NET CSE | June 2016 | Part 2 | Question: 20
Consider the following database table having $\text{A, B, C}$ and $\text{D}$ as its four attributes and four possible candidate keys $\text{(I, II, III and IV)}$ ... ? $\text{I}$ and $\text{III}$ only $\text{III}$ and $\text{IV}$ only $\text{II}$ only $\text{I}$ only
Consider the following database table having $\text{A, B, C}$ and $\text{D}$ as its four attributes and four possible candidate keys $\text{(I, II, III and IV)}$ for this...
User Avatar
Link Copied!