Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 41:

  Which of the following best describes the effect that the per-process limit of open file descriptors in an operating system has on MySQL, and what can be done to increase it?

  A. The --open-files-limit option can be used to increase it.
  B. It limits the amount of operations MySQL can perform at one time.
  C. It limits the maximum size of the table cache that holds file descriptors.
  D. The operating system may be able to be reconfigured to increase this limit.
  D. The operating system may be able to be reconfigured to increase this limit.

• Question 42:

  Which of the following statements about the slow query log is true?

  A. The slow query log will always contain just slow queries.
  B. The slow query log may not always contain just slow queries.
  C. The slow query log always logs more than just slow queries.
  B. The slow query log may not always contain just slow queries.

• Question 43:

  Does the ordering of tables shown in an EXPLAIN output have any significance? Why?

  A. Yes, it determines the table from which data will read first.
  B. No, it sorts them alphabetically.
  C. Yes, it sorts by the most optimized to the least optimized.
  D. No, the order is determined by the order in which tables are specified in the statement being EXPLAINed.
  A. Yes, it determines the table from which data will read first.

• Question 44:

  Is the following statement true or false? The username you use to connect to MySQL must be the same as the login used to access the operating system.

  A. true
  B. false
  B. false

• Question 45:

  In replication the master server logs updates to this/these databases by default:

  A. No database.
  B. The default database
  C. The mysql database
  D. All databases
  E. All databases but mysql
  D. All databases

• Question 46:

  Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE Name = 'Jacksonville' AND CountryCode = 'USA'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ref possible_keys: name_country_index key: name_country_index key_len: 13 ref: const,const rows: 1 Extra: Using where Which of the following best describes the meaning of the value for the key_len column?

  A. It shows how big the indexes are.
  B. It shows how many columns are examined.
  C. It shows how many results will be returned.
  D. It shows how many bytes will be used from index rows.
  D. It shows how many bytes will be used from index rows.

• Question 47:

  Consider the following GRANT statement:

  GRANT USAGE ON *.* TO 'kofi'@'localhost' IDENTIFIED BY 'password'

  What is the implications of executing that statement?

  A. Kofi can access all database objects.
  B. Kofi can access all his tables.
  C. Kofi can display server system and status variables.
  D. Kofi can grant privileges to others.
  E. Kofi can access all database objects belonging to localhost.
  C. Kofi can display server system and status variables.

• Question 48:

  You have been granted SELECT, INSERT and DELETE privileges on the table city in the world database. You log in, and exercise all your privileges without any problems.

  While you are still connected and doing work, the administrator removes your DELETE privileges and informs you by mail that you can no longer delete from table city.

  Being skeptical, you decided to test your privileges and realize that you still have them all. What is are the most likely causes of this?

  A. The administrator forgot to revoke your UPDATE privilege
  B. The administrator forgot to revoke your SELECT privilege
  C. The administrator removed the DELETE privilege by performing an UPDATE directly on the mysql.table_priv table
  D. The administrator did not execute FLUSH PRIVILEGES
  D. The administrator did not execute FLUSH PRIVILEGES

• Question 49:

  Consider the following:

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

  | id | PartName | Location |

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

  | 1 | 40GB Hard Drive | Jacksonville |

  | 2 | 1GB DDR | Atlanta |

  | 3 | Keyboard | San Jose |

  | 4 | Monitor | Harrisburg |

  | 5 | USB Drive | Miami |

  | 6 | DVD/R | Jacksonville |

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

  Which of the following best describes why this table should be split into a part and location table?

  A. Because it has redundant location values.
  B. Because it has multiple repeating groups in each row.
  C. This table should not be split as it is already in third normal form.
  A. Because it has redundant location values.

• Question 50:

  Consider the following:

  mysql> EXPLAIN SELECT Name FROM City WHERE CountryCode = (SELECT Code FROM Country

  WHERE Name = 'United States')\G

  *************************** 1. row ***************************

  id: 1

  select_type: PRIMARY

  table: City type: ALL

  possible_keys: NULL

  key: NULL

  key_len: NULL

  ref: NULL

  rows: 4079

  Extra: Using where

  Which of the following best describes the meaning of the value of the select_type column?

  A. The query has a subquery.
  B. It is the first SELECT in a subquery.
  C. The outer select is the SELECT referred to in the output row.
  D. The inner select is the SELECT referred to in the output row.
  C. The outer select is the SELECT referred to in the output row.