Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 1:

  Should all queries in the slow query log be optimized?

  A. Yes.
  B. Yes, unless they depend on tables in the mysql database
  C. No; A query may have been entered into the slow query log because other, slow queries, prevented it from executing quickly
  D. No; Queries that are run rarely are probably not worth the effort of optimization
  E. No; Only the very slowest queries should be optimized
  A. Yes.
  C. No; A query may have been entered into the slow query log because other, slow queries, prevented it from executing quickly
  E. No; Only the very slowest queries should be optimized

• Question 2:

  Which of the following best describe how access control occurs in MySQL?

  A. On login, the username, hostname and password are checked to allow access. On every query execution, the username, hostname and current object access permissions are checked.
  B. On login, the username, hostname and password are checked to allow access. On every query execution, username, hostname, password and current object access permissions are checked.
  C. On login, the username, hostname and password are checked to allow access and the object access permissions at login time are used for all subsequent operations for the lifetime of the connection.
  A. On login, the username, hostname and password are checked to allow access. On every query execution, the username, hostname and current object access permissions are checked.

• Question 3:

  The password for the existing user 'kofi'@'agric.comp1.com' must be changed to "Sakila". Which of the following will do that?

  A. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = 'Sakila'
  B. SET PASSWORD 'Sakila' FOR 'kofi'@'agric.comp1.com'
  C. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = PASSWORD('Sakila')
  D. SET PASSWORD('Sakila') FOR 'kofi'@'agric.comp1.com'
  C. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = PASSWORD('Sakila')

• Question 4:

  When working with replication, why might you want to stop the SQL thread on the slave while keeping the I/O thread running?

  A. So that no changes are made while making backups.
  B. So that events for the slave do not get backlogged on the master.
  C. So that remaining events can be processed while not receiving new events from the master.
  C. So that remaining events can be processed while not receiving new events from the master.

• Question 5:

  The account 'ulf'@'localhost' has previously been created with the statement GRANT ALL PRIVILEGES ON *.* TO 'ulf'@'localhost' IDENTIFIED BY 'w01f'

  This account should no longer be used, so you issue the following command:

  REVOKE ALL PRIVILEGES ON *.* FROM 'ulf'@'localhost'

  After executing this statement, you inspect the server and find that no clients are connected using that account. However, the next day you notice that the account 'ulf'@'localhost' is indeed connected to the server.

  Why is it still possible for the account 'ulf'@'localhost' to connect to the server?

  A. Specifying GRANT ALL PRIVILEGES ON *.* effectively created an administrator account, which cannot be disabled through the REVOKE statement
  B. The REVOKE statement used does not remove the USAGE privilege from the account, allowing new connections with that account.
  C. The REVOKE command was not followed by a FLUSH PRIVILEGES command, so the account was never actually disabled
  D. The ON *.* clause should not be specified when disabling an account
  B. The REVOKE statement used does not remove the USAGE privilege from the account, allowing new connections with that account.

• Question 6:

  Which of the following best describes why InnoDB tables should always have primary keys and why they should be short?

  A. Because InnoDB uses primary keys to locate tables, and shorter keys make quicker lookups.
  B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.
  C. Because InnoDB stores pointers in a log to all the primary keys and shorter keys make this log smaller.
  B. Because InnoDB uses primary keys to locate table rows, and shorter keys make quicker lookups.

• Question 7:

  Which of the following best describes the purpose of the max_allowed_packet parmeter, and when it is set?

  A. The max_allowed_packet parameter is set per-connection.
  B. The max_allowed_packet parameter is global and is only set by shutting down the server.
  C. The max_allowed_packet parameter is used to control the buffer that is used for communication between the server and the client.
  D. The max_allowed_packet parameter is used to control the size of the dataset that is sent to the client.
  A. The max_allowed_packet parameter is set per-connection.

• Question 8:

  Assuming that the user account 'joe'@'example.com' exists, executing DROP USER 'joe'@'example.com' has the following consequences:

  A. The user account will immediately be removed from the server, if no object-level privileges are in effect for that account
  B. The account will be removed from the server the next time FLUSH PRIVILEGES is executed, if no object-level privileges are in effect for that account
  C. The account and all associated privileges will immediately be removed from the server
  D. The user account and all associated privileges will be removed from the server the next time FLUSH PRIVILEGES is executed.
  C. The account and all associated privileges will immediately be removed from the server

• Question 9:

  Which of the following correctly describe the purpose of the sort buffer, and when it is set?

  A. The size of the sort buffer is set per-connection.
  B. The sort buffer is global and the size can only be set by restarting the server.
  C. The sort buffer is used to control the maximum number of sorts the server can perform simultaneously.
  D. The sort buffer is used for operations such as ORDER BY or GROUP BY which can speed up sorting operations.
  D. The sort buffer is used for operations such as ORDER BY or GROUP BY which can speed up sorting operations.

• Question 10:

  Why should one preferably group multiple statements for InnoDB tables within a transaction whenever it is possible?

  A. It minimizes bandwidth usage.
  B. It helps keep log file sizes down.
  C. It minimizes the amount of flush operations needed.
  D. It helps reduce the chance of the transaction failing due to a bad query.
  C. It minimizes the amount of flush operations needed.