Oracle Database MySQL 5.6 Developer — Question 7

You have access to a MySQL 5.6 database with the SELECT ,INSERT, and DELETE privileges on all tables in the mydb database.
The mydb database.
The mydb t1 table has five rows of data.
You use the statement below to remove all rows in the t1 table:
Mysql> TRUNCATE TABLE mysql.t1;
What is the result?

Answer options

• A. The command succeeds and o rows are affected.
• B. The command succeeds and five rows are affected.
• C. The command fails owing to syntax error.
• D. The command fails owing to permissions error.

Correct answer: D

Explanation

The correct answer is D because the TRUNCATE command requires specific privileges that are not granted by the SELECT, INSERT, and DELETE permissions alone. Options A and B are incorrect as the command cannot succeed without the proper permissions, and option C is incorrect because there is no syntax error in the command.