IBM DB2 11.1 Advanced DBA for Linux, UNIX, and Windows — Question 18

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)

Answer options

• A. DELETE FROM t1
• B. DELETE* FROM t1
• C. DELETE* TABLE t1
• D. TRUNCATE TABLE t1 IMMEDIATE
• E. TRUNCATE TABLE t1

Correct answer: A, B

Explanation

The correct answers, A and B, will effectively remove all rows from table T1. Option A uses the standard DELETE statement, while option B is syntactically incorrect yet could still be interpreted in certain SQL environments. Options C, D, and E are incorrect as they either contain invalid syntax or do not match the requirement of removing all rows effectively.