MySQL Database Multiple choice Questions and Answers-MySQL Administration

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