61.
The CHECK TABLE command should be used...
- A.To make sure a table has no structural problems.
- B.To find out why a query takes a long time to execute on a given table.
- C.To make sure that no table data are corrupted.
- D.To improve performance by updating index distribution statistics onInnoDB tables.
- E.To repair table structure problems.
- Answer
- Report
Answer : [A, C]
62.
Which of the following storage engines cannot be disabled?
- A.InnoDB
- B.MyISAM
- C.FEDERATED
- D.MEMORY
- E.MERGE
- Answer
- Report
Answer : [B, D, E]
63.
Which of the following correctly describes the differences between explicitly and implicitly set
locks?
- A.Implicitly set locks are locks set and released on behalf of the client, by the server.
- B.Explicitly set locks are locks set and released on behalf of the client, by the server.
- C.Implicitly set locks are locks acquired and released by the client.
- D.Explicitly set locks are locks acquired and released by the client.
- Answer
- Report
Answer : [A, D]
64.
Which of the following is true for the command-line programs mysqlcheck and myisamchk?
- A.Mysqlcheck must run on the server to perform checks and repairs and myisamchk can perform checks and repairs on a remote server.
- B.Mysqlcheck can perform checks and repairs on a remote server, and myisamchk must run on the server.
- C.Bothmysqlcheck and myisamchk can perform checks and repairs on a remote server.
- D.Neithermysqlcheck or myisamchk can perform checks and repairs on a remote server.
- Answer
- Report
Answer : [B]
65.
Which of the following best describes how MySQL utilizes the grant table buffers?
- A.The grant table buffer loads grant table information into memory for fast access.
- B.The grant table buffer loads what users are currently logged in and performing queries.
- C.The grant table buffer holds requests waiting to check the grant table to perform access control
- Answer
- Report
Answer : [A]
|
|
||||||||||||||||||||||||||||
