T

Tina Singh • 10.85K Points
Tutor II 

Q. What does the DELETE Statement do?

  • (A) A new table in SQL is created using this SQL statement.
  • (B) By deleting the stored data, this SQL statement deletes the database.
  • (C) Columns in the SQL database can be created, deleted, or modified with this SQL statement.
  • (D) By executing this SQL statement, you remove the table and all the information that it contains, including the structure, views, permissions, and triggers.
  • Correct Answer - Option(B)
  • Views: 223
  • Filed under category MySQL
Explanation by: Tina Singh 
By deleting the stored data, DELETE SQL statement deletes the database.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. The generic handle whose meaning depends on context is . . . . . . . .

Q. Functions are called and pointers to structures are used while using DBI API.

Q. The server uses a Unix domain socket file for connections by clients to localhost.

Q. Multiple MySQL servers cannot be run on the same machine.

Q. Which "text type" has the maximum number of bytes?

Q. A BIT value in a result set is displayed as a binary string.

Q. What is the command to see the warning messages?

Q. If emp_id contain the following set {-1, -2, 2, 3, -3, 1}, what will be the output on execution of the following MySQL statement? SELECT emp_id FROM person ORDER BY emp_id;

Q. What does mysql_real_connect() return if it fails?

Q. The maximum size in bytes of a row in MySQL is . . . . . . . .

Learn All MySQL MCQs

Question analytics