86.
What are some advantages of using the SHOW command rather than using the
INFORMATION_SCHEMA?
- A.It is available for releases older thanMySQL 5.0.
- B.It returns results quicker than using the INFORMATION_SCHEMA.
- C.Using SHOW can provide more concise information.
- D.SHOW is a feature of standard SQL, and INFORMATION_SCHEMA is aMySQL specific command.
- Answer
- Report
Answer : [A, C]
87.
Index analysis and optimization using ANALYZE and OPTIMIZE statements should...
- A.Generally never be run manually
- B.Be run once the table reaches 100,000 rows or above
- C.Be run when more than 5% of the rows are changed by a single statement.
- D.Be run when EXPLAIN SELECT shows that an inordinate amount of rows is expected to be read during query execution
- E.Be run when you suspect that a table is heavily fragmented
- Answer
- Report
Answer : [D, E]
88.
Suppose you have a column in which most records are going to be between 30 and 32 characters.
Which of the following column types would be most efficient?
- A.VARCHAR
- B.CHAR
- C.TEXT
- D.Either VARCHAR or CHAR
- Answer
- Report
Answer : [B]
89.
Which of the following APIs/connectors are included in a MySQL distribution?
- A.Connector/J
- B.Connector/ODBC
- C.C API
- D.Connector/NET
- E.Connector/MJX
- Answer
- Report
Answer : [C]
90.
Which of the following are some benefits of using MySQL built binaries over binaries built by
yourself?
- A.They are highly optimized.
- B.They are cross-platform.
- C.They will work with tools such asMySQL Administrator and MySQL Query Browser.
- D.They may include libraries not available in the standard operating system library.
- Answer
- Report
Answer : [A, C, E]
|
|
||||||||||||||||||||||||||||
