Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 51:

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

  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
  C. Unauthorized users may alter the log contents.

• Question 53:

  Which of the following statements are true regarding the structure of grant tables in new distributions?

  A. They change with every upgrade.
  B. They are often changed.
  C. They remain the same for backwards compatibility.
  B. They are often changed.

• Question 54:

  In which ways can you set the query_cache_type option?

  A. You can set it in the configuration file and restart the server.
  B. You can set it at runtime for the entire server with the following statement: SET GLOBAL query_cache_type=[0|1|2]
  C. You can set it at runtime for the current connection with the following statement: SET SESSION query_cache_type=[0|1|2]
  A. You can set it in the configuration file and restart the server.

• Question 55:

  Consider the following:

  ALTER TABLE City ROW_FORMAT = FIXED

  What would be the effect of this statement?

  A. Nothing as this is not a valid statement.
  B. The table City is changed to a fixed row format.
  C. The columns in the table City are changed from VARCHAR to CHAR.
  B. The table City is changed to a fixed row format.

• Question 56:

  Is it possible to force the join order in a query, and if so how?

  A. No, it is not possible.
  B. Yes it is possible, use SELECT STRAIGHT_JOIN rather than just SELECT, the list the tables in the desired order.
  C. Yes it is possible use SELECT FORCE_JOIN rather than just SELECT, then list the tables in the desired order.
  D. Yes it is possible simply list the tables in the desired order in your SELECT.
  B. Yes it is possible, use SELECT STRAIGHT_JOIN rather than just SELECT, the list the tables in the desired order.

• Question 57:

  Which of the following best describe what could cause low utilization of query cache?

  A. The query cache size is too small.
  B. The CACHE_QUERY keyword is not being used.
  C. The Qcache_priority variable is set too small.
  D. The server might be trying to cache queries when it really isn't worth it.
  B. The CACHE_QUERY keyword is not being used.

• Question 58:

  Which key buffers are available for MyISAM tables?

  A. A global key buffer that keeps index information for all MyISAM tables.
  B. An optional table-specific key buffer that can be assigned to single MyISAM tables.
  C. An optional column-specific key buffer that can be assigned to a single column of a MyISAM table.
  A. A global key buffer that keeps index information for all MyISAM tables.

• Question 59:

  Which of the following best describes the purpose of the record buffer (as controlled through the read_buffer_size variable), and how it is set?

  A. The record buffer is set per connection.
  B. The record buffer is used for operations such as ORDER BY or GROUP BY.
  C. The record buffer is global and is only set by restarting the server.
  D. The record buffer is used to perform sequential table scans, reducing the number of reads from disk.
  C. The record buffer is global and is only set by restarting the server.

• Question 60:

  Which of the following should be done to enable secure logging of events which may be needed for recovery operations and to track down security incidents?

  A. Enable the binary log
  B. Enable the slow log
  C. Enable the general log
  D. Set the --encrypt-logs option
  E. Set permissions on log files so they are only readable by the user owning the mysql process
  D. Set the --encrypt-logs option