adplus-dvertising
91. INFORMATION_SCHEMA is not based on the SQL standard.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (b).False

92. The disk data that the FILES table in INFORMATION_SCHEMA stores is ____________
a. NDB
b. NBD
c. NBK
d. NCD
Discuss
Answer: (a).NDB

93. In which table of INFORMATION_SCHEMA is the information about table index characteristics stored?
a. FILES
b. STATISTICS
c. SCHEMATA
d. VIEWS
Discuss
Answer: (b).STATISTICS

94. What is the join where all possible row combinations are produced?
a. INNER JOIN
b. OUTER
c. NATURAL
d. CARTESIAN
Discuss
Answer: (d).CARTESIAN

95. What is the clause that filters JOIN results called?
a. WHERE
b. SORT
c. GROUP
d. GROUP BY
Discuss
Answer: (a).WHERE

96. What are CROSS JOIN and JOIN are similar to?
a. INNER JOIN
b. NATURAL JOIN
c. OUTER JOIN
d. CARTESIAN JOIN
Discuss
Answer: (a).INNER JOIN

97. The grant table that stores users who can connect to the server and their global privileges are ______________
a. user
b. db
c. tables_priv
d. procs_priv
Discuss
Answer: (a).user

98. The stored-routine privileges are contained in ______________
a. user
b. db
c. tables_priv
d. procs_priv
Discuss
Answer: (d).procs_priv

99. The statement used to obtain access privileges to an account is ______________
a. OBTAIN
b. GET
c. GRANT
d. NEED
Discuss
Answer: (c).GRANT

100. MySQL does not support the shared-memory connections on Windows.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (b).False