Q. The name of the format file for a table named my_tbl is __________

View solution

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

View solution

Q. The server listens on a network port for TCP/IP connections unless started with the option ______________

View solution

Q. Which option is used to specify to the server the IP number of the server host on which the server should listen?

View solution

Q. The option used to specify the socket file pathname is ______________

View solution

Q. MySQL supports shared-memory connections on Windows.

View solution

Q. INFORMATION_SCHEMA is not based on the SQL standard.

View solution

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

View solution

Q. In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?

View solution

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

View solution

Q. What is the clause that filters JOIN results called?

View solution

Q. What are CROSS JOIN and JOIN are similar to?

View solution

Q. The grant table that stores users who can connect to the server and their global privileges are ______________

View solution

Q. The stored-routine privileges are contained in ______________

View solution

Q. The statement used to obtain access privileges to an account is ______________

View solution

Q. MySQL does not support the shared-memory connections on Windows.

View solution

Q. Usage of aggregates in WHERE clause is disallowed.

View solution

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

View solution

Q. The ALL subquery performs the operation _____________

View solution

Q. The keyword used with UNION that does not retain duplicate rows is _____________

View solution