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

Posted by: Pdfprep Category: C2090-616 Tags: , ,

Which of the following SQL statements will remove all rows from the table T1? (Choose two.)
A . DELETE FROM t1
B . DELETE* FROM t1
C . DELETE* TABLE t1
D . TRUNCATE TABLE t1 IMMEDIATE
E . TRUNCATE TABLE t1

Answer: AD

Leave a Reply

Your email address will not be published.