Oracle Oracle Certifications 1Z0-874 Questions & Answers

• Question 101:

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

  A. The max_allowed_packet parameter is set per-connection.

  B. The max_allowed_packet parameter is global and is only set by shutting down the server.

  C. The max_allowed_packet parameter is used to control the buffer that is used for communication between the server and the client.

  D. The max_allowed_packet parameter is used to control the size of the dataset that is sent to the client.

  Correct Answer: A

• Question 102:

  Which of the following are important network factors for remote MySQL clients?

  A. Latency.

  B. Firewalls.

  C. Throughput speed.

  D. The type of routers used.

  Correct Answer: D

• Question 103:

  When working with replication, why might you want to stop the SQL thread on the slave while keeping the I/O thread running?

  A. So that no changes are made while making backups.

  B. So that events for the slave do not get backlogged on the master.

  C. So that remaining events can be processed while not receiving new events from the master.

  Correct Answer: C

• Question 104:

  When working with replication, why might you want to stop the I/O thread on the slave while keeping the SQL thread running?

  A. So that no changes are made while making backups.

  B. So that events for the slave do not get backlogged on the master.

  C. So that remaining events can be processed while not receiving new events from the master.

  Correct Answer: C

• Question 105:

  Does max_connections have an affect on the number of slaves that may connect to a master?

  A. No, because slaves are not really clients.

  B. Yes, because each slave is effectively a connected user.

  C. No, because slaves do not use the same type of connection as a regular client.

  D. Yes, because if the server has too many connections, it may slow the slaves down.

  Correct Answer: B

• Question 106:

  Consider the following two partial outputs of the SHOW VARIABLES command on a master and slave

  server:

  Master:

  +--------------------------+---------------------------+

  | Variable_name | Value |

  +--------------------------+---------------------------+

  | connect_timeout | 5 |

  | log_bin | ON |

  | max_connections | 100 |

  | shared_memory_base_name | MYSQL |

  | server_id | 2 |

  | tmp_table_size | 5242880 |

  | version | 5.0.13-rc-nt |

  Slave:

  +--------------------------+---------------------------+

  | Variable_name | Value |

  ---------------------------+---------------------------+

  | connect_timeout | 5 |

  | log_bin | ON |

  | max_connections | 10 | | shared_memory_base_name | MYSQL | | server_id | 2 |

  | tmp_table_size | 4266336 |

  | version | 5.0.16-rc-nt |

  There is apparently a problem with the slave replicating from the master. Which of the following best

  describes the most likely problem?

  A. The server_id is not unique.

  B. The version of the slave is newer than the version of the master.

  C. The connect_timeout variable needs to be increased.

  D. The max_connections variable needs to be increased.

  Correct Answer: A

• Question 107:

  When creating a new user account, which of The following are valid ways of specifying the hostname part of the account?

  A. Leaving it unspecified, allowing connections from any host

  B. Using localhost

  C. Using a hostname, such as agric.comp1.com

  D. Using an IP address, such as 100.160.1.47

  E. Using a hostname pattern with wildcards, such as %.comp1.com

  F. Using an IP number with wildcards, as 100.160.1.%

  G. Using an IP number/netmask combination such as 100.160.0.0/255.255.0.0

  H. User accounts do not contain a hostname part

  Correct Answer: ABH

• Question 108:

  Why should log files be secured against reading by non-authorized users?

  A. Data values may be read

  B. Usernames and passwords could be revealed.

  C. Unauthorized users may alter the log contents.

  D. The server may be prevented from writing to the log file

  Correct Answer: C

• Question 109:

  The user 'joe' connecting from the host example.com has full access to all databases on the server:

  mysql> SHOW GRANTS FOR 'joe'@'example.com';

  +----------------------------------------------------+

  | Grants for [email protected] |

  +----------------------------------------------------+

  | GRANT ALL PRIVILEGES ON *.* TO 'joe'@'example.com' |

  +----------------------------------------------------+

  1 row in set (0.00 sec)

  You need to restrict the user from accessing the mysql database. Will the following statement do this?

  REVOKE ALL PRIVILEGES ON mysql.* FROM 'joe'@'example.com'

  A. Yes

  B. No

  C. The answer cannot be determined from the information provided.

  Correct Answer: B

• Question 110:

  What will be the effect of executing the following statement? REVOKE ALL PRIVILEGES FROM 'web'@'localhost'

  A. The account 'web'@'localhost' will have all privileges removed, and the account deleted from the server.

  B. The account 'web'@'localhost' will no longer be usable for login, but since there is no ON clause, privileges are retained for re-enabling the account at a later time.

  C. The account 'web'@'localhost' will lose all privileges except for USAGE

  D. Nothing. A REVOKE statment without an ON clause is invalid

  Correct Answer: C