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?

Question

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?

Accepted Answer

D. The command fails owing to permissions error.

Answer

A. The command succeeds and o rows are affected.

Answer

B. The command succeeds and five rows are affected.

Answer

C. The command fails owing to syntax error.

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…

Question

Options

How the community answered

Community Discussion