Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 71:

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

  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.
  B. Yes, because each slave is effectively a connected user.

• Question 73:

  When choosing hardware for your MySQL server, is memory important to MySQL and why?

  A. No, because MySQL makes use of virtual memory on disks.
  B. No, because MySQL makes more use of disks and processors than memory.
  C. Yes, because more memory allows for less swapping by the operating system.
  D. Yes, because more memory allows for larger buffers improving caching and reducing disk usage.
  D. Yes, because more memory allows for larger buffers improving caching and reducing disk usage.

• Question 74:

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

  A. When the table contains both fixed and variable length columns, but the majority of queries on it access the fixed length columns.
  B. When the table contains both fixed and variable length columns, but the majority of queries on it access the variable length columns.
  C. When the table contains both fixed and variable length columns, and the majority of queries access both the variable and fixed length columns.
  A. When the table contains both fixed and variable length columns, but the majority of queries on it access the fixed length columns.

• Question 75:

  Which of the following statements best describe the key buffer?

  A. It is a global buffer.
  B. It is set on a per-connection basis.
  C. It caches index blocks for MyISAM tables only.
  D. It caches index blocks for InnoDB tables only.
  E. It caches index blocks for all storage engine tables.
  D. It caches index blocks for InnoDB tables only.

• Question 76:

  What benefits do you get after compressing a MyISAM table?

  A. The files on disk consume less space.
  B. Retrieving rows usually becomes faster.
  C. The index information will be kept fully in memory, which results in faster performance when using WHERE clauses.
  D. Using COUNT(*) is faster since the number of rows is constant.
  D. Using COUNT(*) is faster since the number of rows is constant.

• Question 77:

  To prevent users from seeing the password used for FEDERATED tables, you should...

  A. not grant them privileges to execute SHOW CREATE TABLE for this table.
  B. not grant them privileges to execute SHOW CONNECTION for this table. C. not grant them privileges to execute SHOW TABLE STATUS for this table.
  C. not grant them privileges to execute SHOW CONNECTION STRING for this table.
  C. not grant them privileges to execute SHOW CONNECTION STRING for this table.

• Question 78:

  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?

  A. 239, the number of rows in the first table
  B. 4079, the number of rows in the second table
  C. 2159, the average of both numbers
  D. 4318, the sum of both numbers
  E. 974881, the product of both numbers
  E. 974881, the product of both numbers

• Question 79:

  Suppose you have a server whose log files, data directory, and temporary files are distributed on different disks. How would this affect overall performance, compared to a server where all components reside on a single disk?

  A. Performance would remain about the same, because the same amount of disk usage would be needed.
  B. You would expect a performance gain because the disk related activities would be split more evenly.
  C. Performance would drop because the server would have to do extra work to read information off of the different disks.
  B. You would expect a performance gain because the disk related activities would be split more evenly.

• Question 80:

  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.