| 81. | It is required to have an access privilege for a database before selecting it with ‘USE’. |
| Discuss |
|
Answer: (a).True
|
| 82. | The keyword used to create a database is __________ |
| Discuss |
|
Answer: (a).CREATE
|
| 83. | Which file is created by the server to store the database attributes? |
| Discuss |
|
Answer: (c).db.opt
|
| 85. | The name of the format file for a table named my_tbl is __________ |
| Discuss |
|
Answer: (b).my_tbl.frm
|
| 86. | In the CREATE TABLE statement, the engine name specified is case insensitive. |
| Discuss |
|
Answer: (a).True
|
| 87. | The server listens on a network port for TCP/IP connections unless started with the option ______________ |
| 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? |
| Discuss |
|
Answer: (b).–bind-address
|
| 89. | The option used to specify the socket file pathname is ______________ |
| Discuss |
|
Answer: (a).–socket
|
| 90. | MySQL supports shared-memory connections on Windows. |
| Discuss |
|
Answer: (a).True
|
