76.
Which of the following statements are true regarding the InnoDB storage engine?
- A.It usesmultiversioning to isolate transactions.
- B.It is not possible for deadlocks to occur.
- C.It does not isolate transactions.
- D.It is possible for deadlocks to occur.
- Answer
- Report
Answer : [A, D]
77.
What are some properties of using LOCK TABLE?
- A.Less work is required by the server to acquire and release locks.
- B.It can only be used with theMyISAM storage engine.
- C.Using LOCK TABLE sometimes decreases the amount disk reads and writes needed for a group of statements.
- D.All tables must be locked in a single statement.
- E.It creates more disk activity.
- Answer
- Report
Answer : [A, C, D]
78.
mysqldump can be instructed to include commands to drop and recreate tables before trying to
create or load data.
- A.True
- B.False
- Answer
- Report
Answer : [A]
79.
Which of the following are requirements for MyISAM binary portability?
- A.Both machines must use the same operating system.
- B.Database and table names must use lowercase format.
- C.Both machines must use IEEE floating-point format or contain no floating-point columns.
- D.Both machines must usetwo's-complement integer arithmetic.
- Answer
- Report
Answer : [C, D]
80.
Another user has issued the statement LOCK TABLE pets FOR WRITE You can...
- A.Update table pets
- B.SELECT from table pets
- C.Update and SELECT from table pets
- D.None of the above
- Answer
- Report
Answer : [D]
|
|
||||||||||||||||||||||||||||
