Home / Programming MCQs / MySQL MCQs / Question

J

Jatin Dubey • 3.78K Points
Extraordinary 

Q. What is the function of DESCRIBE statement?

(A) This statement helps us to get the details of the entire row.
(B) This statement helps us to get the definition of a particular table at a time.
(C) This statement helps us to get the definition of all the tables.
(D) ----

Correct answer: Option(B)

MySQL Share
WhatsApp Facebook Telegram

Share in MCQ Buddy Groups

Share
Explanation by: Jatin Dubey 
DESCRIBE statement helps us to get the definition of a particular table at a time, it tells us about all the constraints which are applied to columns.

You must be Logged in to update hint/solution

Previous MCQ Next MCQ

Discusssion

Login to discuss.

Related MCQs on MySQL

What does the TRUNCATE TABLE Statement do?

What will be the output of the following query:Select round(59999.99,-2);

Increasing the value of which system variable enables mysqld to keep more tables open simultaneously?

Which clause in the SQL standard controls how NULL values in a composite foreign key are handled when comparing to a primary key.

The mode used to turn on strict mode and all of the additional restrictions is

What is a tuple in a relational database?

Which parameter acts like a constant inside the subprogram?

REPAIR TABLE does not work for

What is x’ffff’ in decimal?

Is a semicolon necessary after every query?

Learn All MySQL MCQs