Question

How can the values in the relation teaches be deleted?

(a) Drop table teaches;

(b) Delete from teaches;

(c) Purge table teaches;

(d) Delete from teaches where Id =’Null’;

This question was posed to me during a job interview.

Question is from Reduction to Relational Schemas topic in division Database Systems Design and Implementation of Database Management

Answer 1

The correct choice is (b) Delete from teaches;

The explanation is: Delete table cleans the entry from the table.