21.
Assume you compile MySQL from source and invoke configure with the following options. --withcharset=latin1 --with-extra-charsets=utf8,ucs2 Compared to a standard binary installation that
contains many more character sets, which of the following statements is/are true?
- A.The compiled version will use less disk space, because only a few character sets will be installed on disk.
- B.The compiled version will use less memory, because only a few character sets will be loaded by the server.
- C.The compiled version will use less file handles, because only a few files need to be opened when the server is started.
- Answer
- Report
Answer : [A,B]
22.
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.Many are built using commercial compilers that produce a better quality build than with freely available compilers.
- D.They will work with tools such as MySQL Administrator and MySQL Query Browser.
- E.They may include libraries not available in the standard operating system library.
- Answer
- Report
Answer : [A,C,E]
23.
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]
24.
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]
25.
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]
|
|
||||||||||||||||||||||||||||
