56.
Which of the following correctly defines dirty reads, non-repeatable readsand phantom row?
- A.A dirty read is a read by one transaction of uncommitted changes made by another transaction.
- B.A dirty read is a read by one transaction of its uncommitted changes.
- C.A non-repeatable read occurs when a transaction performs the sameretreival twice but gets a different result each time.
- D.A non-repeatable read is a row that appears where it was not visible before.
- E.A phantom is a row that appears where it was not visible before.
- F.A phantom is a read by one transaction of uncommitted changes made by another transaction.
- Answer
- Report
Answer : [A, C, E]
57.
Which of the following statements are true regarding table locks?
- A.They can only be released by the client holding them.
- B.They can be released by other connections than the client holding them.
- C.They are implicitly released when the connection is closed.
- D.They are not released when the connection is closed
- Answer
- Report
Answer : [A, C]
58.
Which of the following best describes why table locking is often not desirable compared to page or
row locking?
- A.Table locks can have deadlocks.
- B.Table locks create concurrency issues.
- C.Table locks prevent other clients from making any changes to the table until released.
- D.Table locks can cause data corruption issues if more than one client tries to make changes while locked.
- Answer
- Report
Answer : [B, C]
59.
Which of the following steps should be taken to restore an InnoDB table to a consistent state
without having to shutdown the server?
- A.Run the REPAIR TABLE command.
- B.Dump the table withmysqldump, drop the table then re-create from the dump file.
- C.Run the CHECK TABLE command.
- D.Dump the table withmysqlhotcopy, drop the table then re-create with the backup file.
- Answer
- Report
Answer : [B]
60.
Which of the following actions are performed during an RPM installation of the MySQL server
package?
- A.Setup amysql user
- B.Setup amysql group
- C.Initialize the data directory
- D.Setup passwords for all default accounts.
- Answer
- Report
Answer : [A, B, C]
|
|
||||||||||||||||||||||||||||
