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

Q. Which table in INFORMATION_SCHEMA stores information about storage engines and server plugins?

View solution

Q. INFORMATION_SCHEMA is more portable than SHOW statements.

View solution

Q. Which table stores information about the threads executing within the server?

View solution

Q. The command which lists databases managed by the server is _____________

View solution

Q. The option in mysqlshow to show information about indexes in a table is _________

View solution

Q. SELECT select_list FROM table_list WHERE row_constraint GROUP BY grouping_columns; Which of these is not optional?

View solution

Q. In inner join, result is produced by matching rows in one table with rows in another table.

View solution

Q. The join where all possible row combinations are produced is called _________

View solution

Q. The clause that filters JOIN results is called _________

View solution

Q. CROSS JOIN and JOIN are similar to __________

View solution