adplus-dvertising
71. For REVOKE statements, the server automatically rereads the grant tables.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (a).True

72. What does the default case sensitivity of database and table names depend on?
a. SQL server
b. Server SQL mode
c. Operating system of machine
d. Does not depend on anything
Discuss
Answer: (c).Operating system of machine

73. The case sensitive among these is ______________
a. Stored function name
b. Stored procedure name
c. Trigger name
d. Event name
Discuss
Answer: (c).Trigger name

74. The variable used to set table alias names as non case sensitive is ______________
a. lower_case_table_names
b. lower_case_all
c. lower_case_alias
d. lower_case_aliases
Discuss
Answer: (a).lower_case_table_names

75. The clause that can be used to sort string values according to a specific collation is ______________
a. SORT
b. GROUP
c. FILTER
d. COLLATE
Discuss
Answer: (d).COLLATE

76. The statement used to find out which character sets are available is ______________
a. SHOW CHARACTER SET
b. SHOW COLLATION
c. SHOW CHARACTER SETS
d. SHOW COLLATIONS
Discuss
Answer: (a).SHOW CHARACTER SET

77. The collations this statement lists are ______________
SHOW COLLATION LIKE 'utf8%'
a. names beginning with utf8
b. names ending with utf8
c. names containing utf8% anywhere
d. names ending in utf8%
Discuss
Answer: (a).names beginning with utf8

78. The error log file has a suffix ______________
a. .err
b. .er
c. .error
d. .log
Discuss
Answer: (a)..err

79. The option which finds the startup options supported by the server through mysqld is ______________
a. –verbose
b. –vertex
c. –startup
d. –shutdown
Discuss
Answer: (a).–verbose

80. Server startup can also be done by the ______________
a. option file
b. log file
c. error file
d. system file
Discuss
Answer: (a).option file