46.
Which of the following are important network factors for remote MySQL clients?
- A.Latency.
- B.Firewalls.
- C.Throughput speed.
- D.The type of routers used.
- Answer
- Report
Answer : [A, C]
47.
What type of resource limitations may be placed on a user account with the GRANT statement?
- A.The number of times per hour that an account is allowed to connect to the server
- B.The number of queries per hour an account is allowed to issue
- C.The number of updates per hour an account is allowed to issue
- D.The maximum number of simultaneous connectionsan account can have
- E.Resource limits can only be specified globally, not per-account
- F.MySQL does not have provisions for limiting resource usage
- Answer
- Report
Answer : [A, B, C, D]
48.
The user 'joe' connecting from the host example.com has full access to all databases on the
server:
mysql> SHOW GRANTS FOR 'joe'@'example.com'; +---------------------------------------------- - ----+ | Grants for joe@example.com | +----------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'joe'@'example.com' |+----------------------------------------------------+ 1 row in set (0.00 sec) You need to restrict the user from accessing the mysql database. Will the following statement do this? REVOKE ALL PRIVILEGES ON mysql.* FROM 'joe'@'example.com'
mysql> SHOW GRANTS FOR 'joe'@'example.com'; +---------------------------------------------- - ----+ | Grants for joe@example.com | +----------------------------------------------------+ | GRANT ALL PRIVILEGES ON *.* TO 'joe'@'example.com' |+----------------------------------------------------+ 1 row in set (0.00 sec) You need to restrict the user from accessing the mysql database. Will the following statement do this? REVOKE ALL PRIVILEGES ON mysql.* FROM 'joe'@'example.com'
- A.Yes
- B.No
- C.The answer cannot be determined from the information provided.
- Answer
- Report
Answer : [B]
49.
In the following query, the Population column is indexed: mysql> EXPLAIN SELECT Name ->
FROM Country -> WHERE Code LIKE '%B%' AND Population > 10000 ***************************
1. row *************************** id: 1 select_type: SIMPLE table: Country type: ALL possible_keys:
i_pop key: NULL key_len: NULL ref: NULL rows: 239 Extra: Using where Which of the following best describes how to deal with the key value of the EXPLAIN output?
i_pop key: NULL key_len: NULL ref: NULL rows: 239 Extra: Using where Which of the following best describes how to deal with the key value of the EXPLAIN output?
- A.Use FORCE KEY
- B.UseUSE INDEX.
- C.Use FORCE INDEX.
- D.UseUSE POSSIBLE_KEY
- Answer
- Report
Answer : [B, C]
50.
Which of the following statements best describe the key buffer?
- A.It is a global buffer.
- B.It is set on a per-connection basis.
- C.It caches index blocks forMyISAM tables only.
- D.It caches index blocks forInnoDB tables only.
- E.It caches index blocks for all storage engine tables.
- Answer
- Report
Answer : [A, C]
|
|
||||||||||||||||||||||||||||
