Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 2

1.

In which ways can you set the query_cache_type option?

You can set it in the configuration file and restart the server. You can set it at runtime for the entire server with the following statement: SET GLOBALquery_cache_type=[0|1|2] You can set it at runtime for the current connection with the following statement: SET SESSIONquery_cache_type=[0|1|2]

2.

Which of the following would be considered a good candidate table for compression?

A table with data that needs only few updates in the future. A table with data that will not be updated in the future. A large table, such as those used for data warehousing. All MyISAM tables are good candidates for compression.

3.

Consider the following EXPLAIN of a simple Join: mysql> EXPLAIN SELECT CountryList.Name, CityList.Name, CityList.Population -> FROM CountryList JOIN CityList ON CountryList.Code = CityList.Country -> WHERE CityList.Population > 8000000\G ************************** 1. row *************************** id: 1 select_type: SIMPLE table: CountryList type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 239 Extra: ************************** 2. row *************************** id: 1 select_type: SIMPLE table: CityList type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using where How many rows need to be examined to perform the join?

239, the number of rows in the first table 4079, the number of rows in the second table 2159, the average of both numbers 4318, the sum of both numbers 974881, the product of both numbers

4.

What will be the results of the following query? mysql> SELECT * FROM CountryLanguage PROCEDURE ANALYSE(10, 256)

For each column of the CountryLanguage table, the minimum and maximum values will be listed. For each column of the CountryLanguage table, the average value or average length will belisted. For each column of the CountryLanguage table, a data type will be suggested that is justlarge enough to hold the data. For each column of the CountryLanguage table, the data type will be changed to one that isjust large enough to hold the data. It will result in an error.

5.

Why should one preferably group multiple statements for InnoDB tables within a transaction whenever it is possible?

It minimizes bandwidth usage. It helps keep log file sizes down. It minimizes the amount of flush operations needed. It helps reduce the chance of the transaction failing due to a bad query.

6.

Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it?

It is limited by the maximum size of the table cache. The --key_cache option may be used to increase the limit. The maximum number of threads per-process of the operating system. The operating system may be able to be reconfigured to increase this limit.

7.

Which key buffers are available for MyISAM tables?

A global key buffer that keeps index information for all MyISAM tables. An optional table-specific key buffer that can be assigned to single MyISAM tables. An optional column-specific key buffer that can be assigned to a single column of a MyISAMtable.

8.

Doing SELECT COUNT(*) queries in InnoDB is efficient...

Yes, because InnoDB stores a row count in the table. No, because InnoDB does not store a row count in the table. Yes, if the table has any indexes. No, because the table must be sorted.

9.

Which of the following best describes when it might be advantageous to split a dynamic-row table into dynamic-row and fixed-row tables?

When the table contains both fixed and variable length columns, but the majority of queries on it access the fixed length columns. When the table contains both fixed and variable length columns, but the majority of querieson it access the variable length columns. When the table contains both fixed and variable length columns, and the majority of queriesaccess both the variable and fixed length columns.

10.

Which of the following statements are true?

A MERGE table cannot be used with compressed tables. A MERGE table may span across compressed and uncompressed tables. A MERGE table can only be a collection of either compressed or uncompressed tables.

Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle-MySQL 5 Database Administrator Certified Professional Exam, Part II Set 2

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner