81.
Which of the following statements is true for mysqldump?
- A.It can dump data only on remote servers.
- B.It can dump data only on the local server.
- C.It can dump data on both local and remote servers.
- Answer
- Report
Answer : [C]
62.
Which of the following best describes the scope of explicitly and implicitly set locks?
- A.Explicitly set locks may span several commands.
- B.Implicitly set locks may span several commands.
- C.Implicitly set locks will span only one statement or transaction.
- D.Explicitly set locks will span only one statement or transaction.
- Answer
- Report
Answer : [A, B, C]
63.
MySQL is a multi-threaded database server. Every connection to the database server is handled
by it's own thread.
- A.True
- B.False
- Answer
- Report
Answer : [A]
64.
Which of the following are true regarding the table cache?
- A.It is used to cache row data in open tables
- B.It holds file descriptors for open tables
- C.The size of the table cache may be set per-session
- D.Each connection has its own table cache. They are of equal size, set globally.
- E.There is one table cache, shared among all sessions.
- F.Increasing the size of the variabletable_cache allows mysqld to keep more tables open simultaneously
- Answer
- Report
Answer : [B, E, F]
65.
The ANALYZE TABLE command should be used...
- A.When you need to find out why a query is taking a long time to execute.
- B.To improve performance by updating index distribution statistics.
- C.After large amounts of table data have changed.
- D.To check a tables structure to see if it may have been damaged and needs repair.
- Answer
- Report
Answer : [B, C]
|
|
||||||||||||||||||||||||||||
