Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 61:

  When should you enable the Query Cache?

  A. A lot of repeating and identical SELECT queries are received by the server.
  B. The underlying tables don't change very often.
  C. The server machine has more than one CPU.
  D. The server machine has more than one network interface.
  B. The underlying tables don't change very often.

• Question 62:

  What type of resource limitations may be placed on a user account with the GRANT statement?

  A. The number of times per hour that an account is allowed to connect to the server
  B. The number of queries per hour an account is allowed to issue
  C. The number of updates per hour an account is allowed to issue
  D. The maximum number of simultaneous connections an account can have
  E. Resource limits can only be specified globally, not per-account
  F. MySQL does not have provisions for limiting resource usage
  F. MySQL does not have provisions for limiting resource usage

• Question 63:

  Consider a stored procedure or function that is going to be executed. Which of the following statements are true?

  A. First, the database level privileges are checked, then the global privileges, then the stored routine level privileges.
  B. First, the global privileges are checked, then the stored routine level privileges, then the database level privileges.
  C. First, the global privileges are checked, then the database level privileges, then the stored routine level privileges.
  D. If the stored routine contains commands that access other databases and tables, access control for these objects will also be processed.
  B. First, the global privileges are checked, then the stored routine level privileges, then the database level privileges.

• Question 64:

  Which of the following statements about MEMORY tables are true?

  A. Creating many MEMORY tables should be avoided.
  B. It is OK to store large amounts of data in MEMORY tables.
  C. MEMORY tables should not be used to store large amounts of data.
  D. The number of MEMORY tables on a server will not cause any performance problems.
  D. The number of MEMORY tables on a server will not cause any performance problems.

• Question 65:

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

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

• Question 66:

  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.
  D. The type of routers used.

• Question 67:

  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 68:

  Which of the following best describe some possible benefits of using RAID?

  A. Better user-level security.
  B. Data redundancy.
  C. Read performance gains.
  D. Write performance gains.
  E. Hot-swappable disk drives.
  F. Better memory and processor utilization.
  E. Hot-swappable disk drives.

• Question 69:

  Which of the following are methods to improve performance?

  A. Spreading single tables to different disks pointed to by a symbolic link.
  B. Spreading whole databases to different disks pointed to by a symbolic link.
  C. Moving the MySQL utilities such as mysqladmin to different disks pointed to by a symbolic link.
  D. Moving less needed parts of the MySQL install such as the documentation or the test files to different disks pointed to by a symbolic link.
  C. Moving the MySQL utilities such as mysqladmin to different disks pointed to by a symbolic link.

• Question 70:

  How can the SHOW PROCESSLIST command be helpful when optimizing queries?

  A. It shows if a query is using an index or not.
  B. It shows how the server processes a query.
  C. If checked periodically, it can reveal queries that cause other queries to hang.
  D. It shows the percentage of processing power that each query is using on a server.
  C. If checked periodically, it can reveal queries that cause other queries to hang.