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

1.

Assuming that the account 'joe'@'%' does not already exist on the server, executing the statement mysql> CREATE USER 'joe'@'%' IDENTIFIED BY 'sakila' will have the following consequences:

The account 'joe'@'%' is created on the server. However, clients cannot connect using this account until further privileges have been assigned to the account. The account 'joe'@'%' is created on the server. Clients may connect to the server using thisaccount, but will not be able to access any databases, tables or stored routines The account 'joe'@'%' is created on the server. Clients may connect to the server using thisaccount and execute stored routines, but will not be able to access any databases or tables Nothing; there is no such command as CREATE USER

2.

Which of the following best describes what the master.info file contains and how it is used?

It contains the values from the CHANGE MASTER statement. When the slave restarts it looks for which master to use from this file. It contains information about the master server, its slaves and its configuration. It is used by an administrator to determine what slaves connect to the master, and otherinformation about the master server.

3.

Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Code = 'CAN'\G ************************** 1. Row*************************** id: 1 select_type: SIMPLE table: Country type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: Which of the following best describes the meaning of the value of the type column?

The table has exactly one row. Several rows may be read from the table. Only one row of all its rows need to be read.

4.

Which of the following best describes the purpose of the max_allowed_packet parmeter, and when it is set?

The max_allowed_packet parameter is set per-connection. The max_allowed_packet parameter is global and is only set by shutting down the server. The max_allowed_packet parameter is used to control the buffer that is used forcommunication between the server and the client. The max_allowed_packet parameter is used to control the size of the dataset that is sent tothe client.

5.

Which of the following best describes how the binary log might be helpful in query optimization?

By checking which queries it logs as slow. By checking the processor load it records when a query is executed. By identifying the WHERE clauses in queries for which indexes might be useful.

6.

Suppose the key column of an EXPLAIN output is NULL. What does this mean?

There are no indexes available for use in the query. There are no indexes on the table you are querying. There are no indexes considered useful for processing that query.

7.

What is the effect of using WITH GRANT OPTION when executing the following statement? GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com' IDENTIFIED BY 'Sakila' WITH GRANT OPTION

Nothing; WITH GRANT OPTION is not a valid clause in GRANT commands. The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges ontables in the world database to other users The account 'joe'@'example.com' may grant any type of privilege on tables in the worlddatabase to other users The account 'joe'@'example.com' becomes an administrator account

8.

Which of the following is/are valid reasons to consider using --skip-networking?

Your server is not networked to other servers. You do not have a need for remote clients to connect. You have a need for remote clients to connect. You are not going to use replication or clustering.

9.

Why should you be selective when granting the PROCESS privilege to an account?

Because it allows the client to control running processes on the server. Because it allows the client to process scripts. Because it allows for the use of the SHOW PROCESSLIST command, which can expose data. Because it allows for the use of stored routines.

10.

Connection strings in FEDERATED tables are stored...

In variables. Within the table definition. In a .fed file corresponding to the table. They are not stored, but must be re-specified at server restart.

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

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

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