Register

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

• recategorized by
3,428 views
3 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

1 Answer

Best answer
3 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
Voting & Accepting an answer helps improve the community
Answer:
← Previous · Program1Next → · Space complexity
← Previous in category · UGC NET CSE | July 2...Next in category → · normalization
Position:
Show:

Related questions

4 4 votes
1 answers 1 answer
6.4k
6.4k views
go_editor asked Aug 14, 2016
6,350 views
UGC NET CSE | July 2016 | Part 2 | Question: 18
In a relational database model, NULL values canbe used for all but which one of the following?To allow duplicate tuples in the table by filling the primary key column(s) ...
4 4 votes
1 1 answer
3.2k
3.2k views
go_editor asked Aug 14, 2016
3,188 views
UGC NET CSE | July 2016 | Part 2 | Question: 16
In RDBMS, the constraint that no key attribute (column) may be NULL is referred to as:Referential integrityMulti-valued dependencyEntity integrityFunctional dependency
8 8 votes
3 answers 3 answers
8.9k
8.9k views
go_editor asked Aug 16, 2016
8,874 views
UGC NET CSE | July 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)}$ for this...
4 4 votes
2 2 answers
6.8k
6.8k views
go_editor asked Aug 14, 2016
6,791 views
UGC NET CSE | July 2016 | Part 2 | Question: 17
Which of the following statement(s) is/are FALSE in the context of Relational DBMS?Views in a database system are important because they with access control by aloowing u...