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)

MySQL Share
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. Usage of aggregates in WHERE clause is disallowed.

Q. What is the meaning of the "WHERE" clause in Mysql?

Q. INT3 maps to MySQL type . . . . . . . .

Q. Which is the default order of sort in ORDER BY clause?

Q. Regardless of whether a database or table name is case sensitive on the system, it must be referred to using the same lettercase throughout a given query.

Q. An uncorrelated subquery does not contain any reference to the values from the outer query.

Q. What is the meaning of "REFERENCES" in table definition?

Q. STRICT_ALL_TABLES turns on stricter checking of data values.

Q. What is the significance of the statement "GROUP BY d.name" in the following MySQL statement? SELECT d.name, COUNT (emp_id) emp_no FROM department d INNER JOIN Employee e ON d.dept_id=e.emp_id GROUP BY d.name

Q. Which clause is used to "Filters out unwanted data"?

Learn All MySQL MCQs