51.
Consider the following EXPLAIN output. mysql> EXPLAIN SELECT Name FROM City WHERE
Population > 8000000 *************************** 1. row *************************** id: 1
select_type:
SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using where Which of the following statements are true?
SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using where Which of the following statements are true?
- A.The query cannot be optimized any better.
- B.No index could be used to perform the query.
- C.All 4079 rows of the table need toexamined.
- D.The Name column should be indexed.
- E.The Population column should be indexed.
- Answer
- Report
Answer : [B, C, E]
52.
Is it possible to tell the MySQL server to throw an error on division-by-zero rather than converting it
to NULL and a warning?
- A.No, it has to be done programmatically.
- B.Yes, by updating a system variable.
- C.Yes, there is a SQL mode that exists for that.
- D.No, division-by-zero is always converted regardless of any setting.
- Answer
- Report
Answer : [C]
53.
Assuming that the user account 'joe'@'example.com' exists, executing DROP USER
'joe'@'example.com' has the following consequences:
- A.The user account will immediately be removed from the server, if no object-level privileges are in effect for that account
- B.The account will be removed from the server the next time FLUSH PRIVILEGES is executed, if no object-level privileges are in effect for that account
- C.The account and all associated privileges will immediately be removed from the server
- D.The user account and all associated privileges will be removed from the server the next time FLUSH PRIVILEGES is executed.
- Answer
- Report
Answer : [C]
54.
For which of the following objects can privileges be specified?
- A.Host
- B.Global
- C.Database
- D.Table
- E.Column
- F.Row
- Answer
- Report
Answer : [B, C D E]
55.
The type of file system you chose may affect MySQL use and/or performance with regard to...
- A.Table opening time.
- B.Size limits of files.
- C.Time to recover from a crash.
- D.The number of usersMySQL can handle.
- E.The type of storage engines that can be used.
- Answer
- Report
Answer : [A, B, C]
|
|
||||||||||||||||||||||||||||
