Which one of the following deletes all the entries but keeps the structure of the relation.

Question

TuteeHUB · Accepted Answer

Delete from instructor where salary between 13000 and 15000;

TuteeHUB · Answer

Delete from r where P;

TuteeHUB · Answer

Delete from instructor where dept name= ‚Äö√Ñ√∂‚àö√ë‚àö¬•Finance‚Äö√Ñ√∂‚àö√ë‚àö¬•;

TuteeHUB · Answer

Delete from instructor;

1.	Which one of the following deletes all the entries but keeps the structure of the relation.
A.	Delete from r where P;
B.	Delete from instructor where dept name= ‚Äö√Ñ√∂‚àö√ë‚àö¬•Finance‚Äö√Ñ√∂‚àö√ë‚àö¬•;
C.	Delete from instructor where salary between 13000 and 15000;
D.	Delete from instructor;
Answer» C. Delete from instructor where salary between 13000 and 15000;

Discussion