What does the TRUNCATE TABLE Statement do?

Home / Programming MCQs / MySQL MCQs / Question

Tina Singh • 10.68K Points
Tutor II

Q. What does the TRUNCATE TABLE Statement do?

(A) In the database management system, this SQL statement deletes the existing database, together with all the database tables and views.

(B) In this SQL statement, the data or records are inserted into an existing database table. One query statement can insert multiple records simultaneously using this statement.

(D) The data specified in this table or view is reported in this SQL statement.

Correct answer: Option(C)

MySQL Share

Explanation by: Tina Singh

By executing TRUNCATE TABLE SQL statement, all records in the SQL database will be deleted.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Related MCQs on MySQL

What does UTF stand for int utf8?

Select the correct statement

The line which is written at the top of the script to write a Perl script using CGI.pm is

The binary protocol is easy to use.

Which variable checks for availability of SSL support?

Syntax of the Structured Query Language is ____?

What do you mean by HOST in MYSQL?

The hub of a MySQL installation is

Which server mode value disables use of built in function names as identifiers?

Following the completion of a transaction, it must be executed to save all the operations performed in the transaction. Here we are talking about which command?

Q. What does the TRUNCATE TABLE Statement do?

Explanation by: Tina Singh

Discusssion

Related MCQs on MySQL

Learn All MySQL MCQs