You want to empty a large table of all its rows quickly while keeping the table structure for reuse, without row-by-row processing. Which command is designed for this?
Correct answer D. TRUNCATE TABLE t;
Subject / 929 questions
Page 33 of Programming multiple-choice questions with answers. Tap an option to check yourself.
Page 33 of 47
Correct answer D. TRUNCATE TABLE t;
Correct answer C. REVOKE SELECT ON Emp FROM ali;
Correct answer B. Grant SELECT on Emp to other users
Correct answer D. ROLLBACK
Correct answer A. WHERE filters individual rows before groups and aggregates exist
Correct answer C. '___k'
Correct answer A. FULL OUTER JOIN
Correct answer D. It refers to a column of the outer query, so it is evaluated for each outer row
Correct answer C. Only in the leaf nodes, which are linked together
Correct answer B. 0
Correct answer A. 4
Correct answer D. 3
Correct answer C. (HR, 1), (IT, 2), (Ops, 0)
Correct answer A. 1
Correct answer B. Bilal, Hina
Correct answer C. 2, 5
Correct answer C. 1
Correct answer A. 4000
Correct answer A. Bina, Ali
Correct answer B. 0