P

Pooja • 4.41K Points
Extraordinary 

Q. The file created by the server to store the database attributes is . . . . . . . .

  • (A) db.otp
  • (B) dp.zip
  • (C) db.opt
  • (D) db.cls
  • Correct Answer - Option(C)
  • Views: 12
  • Filed under category MySQL
Explanation by: Pooja 
This question is asking about a special file that MySQL uses to store information about your database. Think of it like a list of important details about the database.

You must be Logged in to update hint/solution

Discusssion

Login to discuss.

Be the first to start discuss.

Related MCQs on MySQL

Q. A FULLTEXT index cannot be created for multiple columns.

Q. It is possible to drop multiple tables in the same statement.

Q. Which of the following statements does not modify the table?

Q. Which statement is used to select a database?

Q. Consider a database name "db_name" whose attributes are intern_id (primary key), subject. Intern_id = {1, 2, 3, 4, 5, 6} Subject = {sql, oop, sql, oop, c, c++} If these are one to one relation then what will be the output of the following MySQL statement? SELECT intern_id FROM db_name WHERE subject NOT IN (c, c++, oop);

Q. What is the join where all possible row combinations are produced?

Q. If an integer column is used for the values in range 1 to 99999, the best suitable datatype is . . . . . . . .

Q. MySQL does not automatically convert a date or time value to a number if the value is used in a numeric context.

Q. Which statement issues a lock on tables?

Q. MySQL Enterprise Backup records details of each backup in . . . . . . . .

Learn All MySQL MCQs

Question analytics