N

Nitin Gupta • 1.72K Points
Master 

Q. The disk data that the FILES table in INFORMATION_SCHEMA stores is ____________.

  • (A) NBD
  • (B) NCD
  • (C) NBK
  • (D) NDB
  • Correct Answer - Option(D)
  • Views: 135
  • Filed under category MySQL
Explanation by: Nitin Gupta 
The ‘INFORMATION_SCHEMA’ is a method to access information about the databases and its objects known as metadata. It has various tables that can be viewed with ‘SHOW’ statement.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. Find the error in the following SQL statement? CREATE TABLE person ( person_id SMALLINT, name VARCHAR, LAST VARCHAR, Bith_date DATE CONSTRAINTS pk_person PRIMARY KEY (person_id)); INSERT INTO person VALUES( person_id, name, LAST, Birth_date) (1,’s’,’p’, 24-1991-01);

Q. mysql_init() returns a _____________.

Q. '2341' is a . . . . . . . .

Q. Which operator is used to return value from JSON columns after evaluating the path and unquoting the result?

Q. What will be the output of the following MySQL command? SELECT * FROM employee WHERE (title=’HEAD TELLER’) OR (start_date>2013-01-24);

Q. Commands passed to the MySQL daemon are written in

Q. Which of the following keywords cannot be used to modify an existing table?

Q. Are “Datetime” and “Timestamp” the same data type?

Q. Which of the following columns is not returned by 'OPTIMIZE TABLE'?

Q. What represents a ‘tuple’ in a relational database?

Learn All MySQL MCQs

Question analytics