Question

Pariniti wants to remove all the records from table Customer' with fields(Cust_ID, C_name, Amount, Dues, Address) whose dues status is 'Clear'. Select the query that will solve the purpose:

(a) Delete * Customer where dues=Clear';

(b) Remove * from Customer where dues='Clear'

(c) Drop Customer where dues='Clear';

(d) Delete from Custorner where dues='Clear';

Answer 1

Correct option is (d) Delete from Custorner where dues='Clear';