Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 91:

  Which of the following best describes the purpose of the InnoDB buffer pool?

  A. It caches data and index information for InnoDB tables.
  B. It is the amount of buffers available during a transaction.
  C. It holds changes made during a transaction before they are written to the log.
  A. It caches data and index information for InnoDB tables.

• Question 92:

  Granting access to the mysql database...

  A. Should never be done for any users.
  B. Should always be done for all users.
  C. Should only be done on administrator accounts.
  D. Should be done for anyone needing to create views
  C. Should only be done on administrator accounts.

• Question 93:

  The type of file system you chose may affect MySQL use and/or performance with regard to...

  A. Table opening time.
  B. Size limits of files.
  C. Time to recover from a crash.
  D. The number of users MySQL can handle.
  E. The type of storage engines that can be used.
  B. Size limits of files.

• Question 94:

  Which of the following best describes what you might expect after disabling InnoDB at run time?

  A. It will disable InnoDBs associated memory buffers and data structures, however it will not save any memory.
  B. It will still enable InnoDBs associated memory buffers and data structures, however it will save memory.
  C. It will disable InnoDBs associated memory buffers and data structures, which will save memory.
  C. It will disable InnoDBs associated memory buffers and data structures, which will save memory.

• Question 95:

  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.
  A. The server_id is not unique.

• Question 96:

  Why is --bind-address an important security option?

  A. On a server with multiple network interfaces, you can have mysqld accept connections only on the given interface.
  B. mysqld will only accept connections from the given address.
  C. mysqld will turn off networking and will only accept local connections
  D. mysqld won't accept any connections at all.
  A. On a server with multiple network interfaces, you can have mysqld accept connections only on the given interface.

• Question 97:

  Which of the following statements are true?

  A. A MERGE table cannot be used with compressed tables.
  B. A MERGE table may span across compressed and uncompressed tables.
  C. A MERGE table can only be a collection of either compressed or uncompressed tables.
  B. A MERGE table may span across compressed and uncompressed tables.

• Question 98:

  Consider the following:

  mysql> SHOW STATUS LIKE 'Qcache%';

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

  | Variable_name | Value |

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

  | Qcache_free_blocks | 87 |

  | Qcache_free_memory | 318442 |

  | Qcache_hits | 11224 |

  | Qcache_inserts | 19215 |

  | Qcache_lowmem_prunes | 437 |

  | Qcache_not_cached | 9155 |

  | Qcache_queries_in_cache | 240 |

  | Qcache_total_blocks | 924 |

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

  What can be derived from this output?

  A. There is a low utilization of the query cache.
  B. There is a normal utilization of the query cache.
  C. There is a high utilization of the query cache.
  A. There is a low utilization of the query cache.

• Question 99:

  Which of the following are reasons to be selective when granting the FILE privilege to accounts?

  A. It could be used to execute scripts on the server host.
  B. It could be used to read files on the filesystem of the server host.
  C. It could be used to write files to the filesystem of the server host.
  B. It could be used to read files on the filesystem of the server host.

• Question 100:

  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