Q. To create a database only if it doesn’t already exist, which clause is used?

View solution

Q. If COLLATE is given without CHARACTER SET, the first part of the collation name gives the character set.

View solution

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

View solution

Q. Which statement is used to see the definition for an existing database?

View solution

Q. Which statement makes changes to the database’s global attributes?

View solution

Q. Which statement is used to remove indexes on tables?

View solution

Q. Which storage engine is not available in MySQL 5.0?

View solution

Q. The default storage engine used is ____________

View solution

Q. What is the name of the format file for a table named my_tbl?

View solution

Q. In the CREATE TABLE statement, the engine name specified is case sensitive.

View solution

Q. Which keyword is used to create a table as a temporary copy of itself?

View solution

Q. Which storage engine enables to access tables from a MySQL server managed by another server?

View solution

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

View solution

Q. The default index type for MEMORY tables is __________

View solution

Q. The statement to change the table name is __________

View solution

Q. The general term for information about databases and the objects in MySQL is _________

View solution

Q. Which statement is used to determine the storage engine for individual tables?

View solution

Q. INFORMATION_SCHEMA is based on the SQL standard.

View solution

Q. Which disk data does FILES table in INFORMATION_SCHEMA store?

View solution

Q. The information about table index characteristics is stored in which table of INFORMATION_SCHEMA?

View solution