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

Q. The comma operator can also be used to join tables.

View solution

Q. The left and right joins are also known as __________

View solution

Q. What is joining a table to itself called?

View solution

Q. In which join all the rows from the left table appear in the output irrespective of the content of the other table?

View solution

Q. The join in which all the rows from the right table appear in the output irrespective of the content of the other table is ___________

View solution

Q. The facility that allows nesting one select statement into another is called __________

View solution

Q. Which subquery returns a single value?

View solution

Q. Usage of aggregates in WHERE clause is allowed.

View solution

Q. Which operators are used when a subquery returns multiple rows to be evaluated in comparison to the outer query?

View solution

Q. The ALL subquery performs which operation?

View solution