N

Nitin Gupta • 1.72K Points
Master 

Q. INFORMATION_SCHEMA is not based on the SQL standard.

  • (A) False
  • (B) True
  • (C) ---
  • (D) ---
  • Correct Answer - Option(A)
  • Views: 204
  • Filed under category MySQL
Explanation by: Nitin Gupta 
‘INFORMATION_SCHEMA’ is another way to access information about the databases and its objects (metadata). It is based on the ‘SQL standard’, although some content is MySQL-specific.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. The place where the server stores its databases and status files are the data directory.

Q. In the following statement, what do you mean by the 'student'?

Q. MySQL stores the database character set and collation attributes in the file . . . . . . . .

Q. Which option is used in mysqldump to make all tables in the destination databases to use a different storage engine?

Q. Which clause is used to rename the existing table?

Q. REPAIR TABLE works with how many of the following? MyISAM, ARCHIVE, CSV

Q. What will be the output of the following MySQL statement? SELECT emp_id, fname, lname FROM employee WHERE LEFT (lname, 1) =’F’;

Q. CGI.pm does not support an object oriented style of use.

Q. The datatype best suited to store currency values is . . . . . . . .

Q. The binary protocol is more difficult to use.

Learn All MySQL MCQs

Question analytics