Microsoft Technology Associate Mta · Free Practice Question Medium
Question 4
This question requires that you evaluate the styled text to determine if it is correct:
ALTER TABLE removes all rows from a table without logging the individual row deletions.
Instructions: Review the styled text. If it makes the statement correct, select "No change is needed." If the statement is incorrect, select the answer choice that makes the statement correct.
-
A
No change is needed
-
B
TRUNCATE TABLE -
C
CREATE TABLE -
D
DROP TABLE
Reveal correct answer
Correct answer: B
Explanation
In SQL, the TRUNCATE TABLE statement is a Data Definition Language (DDL) operation that marks the extents of a table for deallocation (empty for reuse). The result of this operation quickly removes all data from a table, without logging the individual row deletions, typically bypassing several integrity-enforcing mechanisms.
Discussion
Think the marked answer is wrong, or have a better explanation? Share it below — comments appear after review.
