A DBA wants to delete all records from PILOT table. Which of the following statements can do that?
A. DELETE * FROM pilot WHERE pilot_name = all;
B. TRUNCATE TABLE pilot;
C. DELETE ALL FROM pilot;
D. DELETE FROM pilot ALL TUPLES;
Answer:B
A DBA wants to delete all records from PILOT table. Which of the following statements can do that?
A. DELETE * FROM pilot WHERE pilot_name = all; B. TRUNCATE TABLE pilot; C. DELETE ALL FROM pilot; D. DELETE FROM pilot ALL TUPLES;