T

Tina Singh • 10.85K Points
Tutor II 

Q. What does the DESCRIBE Statement do?

  • (A) 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.
  • (B) By executing this SQL statement, all records in the SQL database will be deleted.
  • (C) Specify the columns of the table in this SQL statement to return distinct values.
  • (D) The data specified in this table or view is reported in this SQL statement.

Correct answer: Option(D)

MySQL Share
Explanation by: Tina Singh 
The data specified in this table or view is reported in DESCRIBE SQL statement.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Related MCQs on MySQL

Q. What is the full form of SQL?

Q. MySQL provides a date type that has an optional time part.

Q. MySQL Access security is controlled through

Q. Usage of aggregates in WHERE clause is disallowed.

Q. Arrays can have associative indices in PHP.

Q. The variable that checks for availability of SSL support is . . . . . . . .

Q. Which is the join in which all the rows from the right table appear in the output irrespective of the content of the other table?

Q. What can be used to check for views that have been invalidated by DROP or ALTER operations?

Q. Which mode is used to turn on strict mode and all of the additional restrictions?

Q. What allows nesting one select statement into another?

Learn All MySQL MCQs