Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 121:

  Which of the following is true of the table cache if you mainly run simple queries on many tables?

  A. The table cache should be decreased.
  B. The table cache should be increased.
  C. The table cache should not be changed.
  B. The table cache should be increased.

• Question 122:

  Which of the following best describes what the master.info file contains and how it is used?

  A. It contains the values from the CHANGE MASTER statement.
  B. When the slave restarts it looks for which master to use from this file.
  C. It contains information about the master server, its slaves and its configuration.
  D. It is used by an administrator to determine what slaves connect to the master, and other information about the master server.
  D. It is used by an administrator to determine what slaves connect to the master, and other information about the master server.

• Question 123:

  How can stored routines be used to check for constraints or legality of incoming data?

  A. They can make use of the VALIDATE DEFINER setting.
  B. They can not be used to check for constraints or legality of data.
  C. They can check and only perform an action if the incoming values match a specified value.
  C. They can check and only perform an action if the incoming values match a specified value.

• Question 124:

  Is it possible to tell the MySQL server to throw an error on illegal dates rather than converting it to zero-date or legal dates?

  A. Yes, by updating a system variable.
  B. No, it has to be done programmatically.
  C. Yes, there is a SQL mode that exists for that.
  D. No, all illegal date are converted regardless of any setting.
  C. Yes, there is a SQL mode that exists for that.

• Question 125:

  Is it possible to tell the MySQL server to throw an error on division-by-zero rather than converting it to NULL and a warning?

  A. No, it has to be done programmatically.
  B. Yes, by updating a system variable.
  C. Yes, there is a SQL mode that exists for that.
  D. No, division-by-zero is always converted regardless of any setting.
  C. Yes, there is a SQL mode that exists for that.

• Question 126:

  Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Code = 'CAN'\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: const possible_keys: PRIMARY key: PRIMARY key_len: 3 ref: const rows: 1 Extra: Which of the following best describes the meaning of the value of the type column?

  A. The table has exactly one row.
  B. Several rows may be read from the table.
  C. Only one row of all its rows need to be read.
  C. Only one row of all its rows need to be read.

• Question 127:

  Consider the following: mysql> EXPLAIN SELECT Name FROM Country WHERE Population BETWEEN 1 AND 10000\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: Country type: range possible_keys: i_pop key: i_pop key_len: 4 ref: NULL rows: 10 Extra: Using where What is the meaning of the range value of the type column?

  A. There is a range of indexes that can be used.
  B. The type of index uses the range algorithm.
  C. The index is used to select rows that fall between a range of index values.
  D. The optimizer has determined that only data from the very beginning or the very end of the table is needed
  C. The index is used to select rows that fall between a range of index values.

• Question 128:

  Which of the following are reasons you would want to normalize your data?

  A. It removes redundant data.
  B. It is the only way to make your data internationalized.
  C. It makes data access more flexible.
  D. It helps eliminate possible data inconsistencies.
  E. It makes backups more efficient.
  B. It is the only way to make your data internationalized.

• Question 129:

  Which of the following statements are true of how access control is based?

  A. It is based off of an access control table in the mysql database.
  B. It is based off of grant tables in the mysql database.
  C. It is based off of an access control list stored in the data directory.
  D. It is based off of an access control list stored inside the .frm files of each table.
  B. It is based off of grant tables in the mysql database.

• Question 130:

  Given the following MyISAM table structure:

  mysql> desc city;

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

  | Field | Type | Null | Key | Default | Extra |

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

  | ID | int(11) | | PRI | NULL | auto_increment |

  | Name | char(35) | | | | |

  | CountryCode | char(3) | | | | |

  | District | char(20) | | | | |

  | Population | int(11) | | MUL | 0 | |

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

  and the following SQL statement:

  SELECT Population

  FROM city

  WHERE Population = 10000

  ORDER BY Population

  LIMIT 5;

  Which of the following statements best describes how MySQL optimizer executes the query?

  A. The optimizer uses the primary key column ID to read the index values, then uses the index on Population to filter the results. The optimizer will always choose to use a unique index first, then use a secondary index if available.
  B. The optimizer uses the index on the Population column to search and filter the WHERE clause. A temporary table is used to perform a filesort on the results, and then only 5 records are returned to the client.
  C. The optimizer uses the index on the Population column to search, filter and sort the Population column, then returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only, because the index contains just integer values that form a leftmost prefix for the key.
  D. The optimizer uses the index on the Population column to search, filter and sort the Population column, and returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only because only those columns where specified in the SELECT statement.
  E. The optimizer will never read data from disk, since MySQL caches both data and index in the key buffer.
  D. The optimizer uses the index on the Population column to search, filter and sort the Population column, and returns 5 records to the client. The optimizer does not need to read the data rows, and can return values from the index only because only those columns where specified in the SELECT statement.