adplus-dvertising
81. It is required to have an access privilege for a database before selecting it with ‘USE’.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (a).True

82. The keyword used to create a database is __________
a. CREATE
b. SET
c. SETUP
d. LINK
Discuss
Answer: (a).CREATE

83. Which file is created by the server to store the database attributes?
a. db.otp
b. dp.zip
c. db.opt
d. db.cls
Discuss
Answer: (c).db.opt

84. What is the default storage engine?
a. EXAMPLE
b. ARCHIVE
c. MyISAM
d. NDB
Discuss
Answer: (c).MyISAM

85. The name of the format file for a table named my_tbl is __________
a. my_tbl.fmt
b. my_tbl.frm
c. my_tbl.fmr
d. my_tbl.ftm
Discuss
Answer: (b).my_tbl.frm

86. In the CREATE TABLE statement, the engine name specified is case insensitive.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (a).True

87. The server listens on a network port for TCP/IP connections unless started with the option ______________
a. –networking
b. –skip-networking
c. –skip-networks
d. –quit-networking
Discuss
Answer: (b).–skip-networking

88. Which option is used to specify to the server the IP number of the server host on which the server should listen?
a. –verbose
b. –bind-address
c. –startup
d. –shutdown
Discuss
Answer: (b).–bind-address

89. The option used to specify the socket file pathname is ______________
a. –socket
b. –pathtosocket
c. –path_socket
d. –socket_pathfile
Discuss
Answer: (a).–socket

90. MySQL supports shared-memory connections on Windows.
a. True
b. False
c. May be True or False
d. Can't say
Discuss
Answer: (a).True