41.
What are reasons to prefer using GRANT and REVOKE statements over editing the privilege
tables directly?
- A.Using GRANT and REVOKE allows the server to figure out the right tables and do all the appropriate work
- B.All grant tables in memory are immediately updated on GRANT and REVOKE
- C.Making changes directly to the grant tables, one must remember to execute flush privileges to make the changes take effect
- D.GRANT and REVOKE statements allow you to do more fine-grained tuning of user privileges than does editing the grant tables directly.
- Answer
- Report
Answer : [A, B, C]
42.
Which of the following statements are true of compressed tables?
- A.They can be uncompressed.
- B.They can not be uncompressed.
- C.They can be uncompressed but some data corruption may occur.
- Answer
- Report
Answer : [A]
43.
In regards to security, which of the following statements are true?
- A.Mysqld should not be run as root or administrator.
- B.Mysqld should be run as root or administrator.
- C.The user owning the server process should own all files and directories to which the server may write.
- D.The root oradmininistrator users should own all files related to the server process.
- Answer
- Report
Answer : [A, C]
44.
When working with replication, why might you want to stop the SQL thread on the slave while
keeping the I/O thread running?
- A.So that no changes are made while making backups.
- B.So that events for the slave do not get backlogged on the master.
- C.So that remaining events can be processed while not receiving new events from the master.
- Answer
- Report
Answer : [A, B]
45.
Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Code = 'CAN'
*************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country
type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: Which of
the following best describes the meaning of the value of the type column?
- A.The table has exactly one row.
- B.Several rows may be read from the table.
- C.Only one row of all its rowsneed to be read.
- Answer
- Report
Answer : [C]
|
|
||||||||||||||||||||||||||||
