Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 1:

  Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system.

  A. true
  B. false
  B. false

• Question 2:

  Which of the following best describes what MASTER_LOG_FILE and MASTER_LOG_POS provides?

  A. The path of the log file.
  B. The file to log replication actions to.
  C. The masters binary log name used for replication.
  D. The position in the masters binary log in which to start replication.
  A. The path of the log file.

• Question 3:

  Which of the following is/are required on the master server for replication to work?

  A. Issue the START MASTER command.
  B. Binary logging must be turned on.
  C. Tell the master which slaves to connect to.
  D. Make a backup of all databases to be replicated.
  B. Binary logging must be turned on.

• Question 4:

  Can you have several MySQL servers running on the same computer, using the same InnoDB tablespace files?

  A. No
  B. Yes, always
  C. Yes, provided their permissions are set to read-only
  A. No

• Question 5:

  What kind of replication is supported by the MySQL server?

  A. Multiple-master replication
  B. Master to slave replication
  C. Single file based clustering
  D. MySQL doesn't support replication
  B. Master to slave replication

• Question 6:

  Which of the following are general features of replication?

  A. Can be used to distribute the load caused by servicing many clients.
  B. Provides complete redundancy and high availability at all times.
  C. Multiple copies are available in case a server crashes or goes offline.
  D. Allows the databases on one server to be made available on another server.
  D. Allows the databases on one server to be made available on another server.

• Question 7:

  Which of the following are requirements for running more than one MySQL server on the same machine?

  A. On Windows each server that runs as a service must have a different service name.
  B. Each server must have its own log files.
  C. Each server must share the same error log.
  D. Each server must run on a different disk.
  E. Each server must have its own network interfaces.
  F. There must be more than one processor on the machine.
  G. InnoDB tablespace files must be separate between servers.
  D. Each server must run on a different disk.

• Question 8:

  Which of the following best describes what the connection backlog is and why it may need to be increased?

  A. It may need to be increased on a server with a high rate of transactions.
  B. The backlog is the queue of processes waiting to be processed on a server.
  C. The backlog is the queue of network connections of clients waiting to connect.
  D. It may need to be increased on a server with a high rate of client connections.
  C. The backlog is the queue of network connections of clients waiting to connect.

• Question 9:

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

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

• Question 10:

  Which of the following best describes the effect that the per-process limit of open file descriptors in an operating system has on MySQL, and what can be done to increase it?

  A. The --open-files-limit option can be used to increase it.
  B. It limits the amount of operations MySQL can perform at one time.
  C. It limits the maximum size of the table cache that holds file descriptors.
  D. The operating system may be able to be reconfigured to increase this limit.
  D. The operating system may be able to be reconfigured to increase this limit.