Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 131:

  What will be the effect of executing the following statement? REVOKE ALL PRIVILEGES FROM 'web'@'localhost'

  A. The account 'web'@'localhost' will have all privileges removed, and the account deleted from the server.
  B. The account 'web'@'localhost' will no longer be usable for login, but since there is no ON clause, privileges are retained for re-enabling the account at a later time.
  C. The account 'web'@'localhost' will lose all privileges except for USAGE
  D. Nothing. A REVOKE statment without an ON clause is invalid
  C. The account 'web'@'localhost' will lose all privileges except for USAGE

• Question 132:

  You need to allow the user 'joe'@'example.com' the privilege to create and alter stored routines in the world database, but you do not want that user to be able to change any table definitions. The user already has the required permissions to access table data in the database.

  Which of the following will achieve that?

  A. mysql> GRANT ALL ROUTINE PRIVILEGES ON world.* TO 'joe'@'example.com';
  B. mysql> GRANT ALL PRIVILEGES ON world.* TO 'joe'@'example.com';
  C. mysql> GRANT ALL PRIVILEGES ON PROCEDURE world.* TO 'joe'@'example.com';mysql> GRANT ALL PRIVILEGES ON FUNCTION world.* TO 'joe'@'example.com';
  D. mysql> GRANT CREATE ROUTINE ON world.* TO 'joe'@'example.com';mysql> GRANT ALTER ROUTINE ON world.* TO 'joe'@'example.com';
  E. You must use GRANT ALL PRIVILEGES ON world.routine1_name, world.routine2_name ... TO 'joe'@'example.com', replacing routine1_name etc. with the names of each of the stored routines the user may want to create or alter
  F. This cannot be done; permissions on tables and stored routines are always shared.
  D. mysql> GRANT CREATE ROUTINE ON world.* TO 'joe'@'example.com';mysql> GRANT ALTER ROUTINE ON world.* TO 'joe'@'example.com';

• Question 133:

  When working with replication, why might you want to stop the I/O thread on the slave while keeping the SQL 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 134:

  Consider the following: mysql> EXPLAIN SELECT DISTINCT City.id,City.name -> FROM City,Country -> WHERE Country.Name IN ('United States','Canada','Mexico') -> AND City.CountryCode=Country.Code -> ORDER BY name\G *************************** 1. row *************************** id: 1 select_type: SIMPLE table: City type: ALL possible_keys: NULL key: NULL key_len: NULL ref: NULL rows: 4079 Extra: Using temporary; Using filesort *************************** 2. row *************************** id: 1 select_type: SIMPLE table: Country type: eq_ref possible_keys: PRIMARY key: PRIMARY

  key_len: 3 ref: world.City.CountryCode rows: 1 Extra: Using where; Distinct Which of the following best describes the meaning of the values in the ref columns?

  A. City.CountryCode is used to sort what rows are returned from the City table.
  B. No indexed columns are used to choose rows from City and the City.CountryCode column is used to reference rows in the Country table.
  C. No index columns are used to choose rows from Country and the City.CountryCode column is used to reference rows in the City table.
  B. No indexed columns are used to choose rows from City and the City.CountryCode column is used to reference rows in the Country table.

• Question 135:

  With replication, what on the master is used to send commands to the slave?

  A. The relay log.
  B. The binary log.
  C. The SQL Thread.
  B. The binary log.

• Question 136:

  Consider the following:

  mysql> DESC customers;

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

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

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

  | id | int(11) unsigned | NO | PRI | NULL | auto_increment |

  | name_1 | char(20) | YES | MUL | NULL | |

  | name_2 | varchar(20) | YES | | NULL | |

  | name_3 | varchar(20) | YES | | NULL | |

  | email | varchar(50) | YES | | NULL | |

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

  mysql> EXPLAIN SELECT * FROM customers WHERE name_1 = 'Johnny'\G

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

  id: 1

  select_type: SIMPLE

  table: customers type:

  ref

  possible_keys: i_name_1_01,i_name_1_02

  key: i_name_1_01

  key_len: 21

  ref: const

  rows: 1

  Extra: Using where

  What can be assumed by looking at the key_len column?

  A. No indexes are being used.
  B. The full index is being used.
  C. The partial index is being used.
  D. The longest index is 21 characters long.
  B. The full index is being used.

• Question 137:

  Which of the following best describes the table cache in MySQL and some of its properties?

  A. The table cache is a global cache for all open tables.
  B. Separate table caches are created for data in each open table.
  C. It is used to cache frequently used table indexes.
  D. It is used to cache the status of individual tables.
  A. The table cache is a global cache for all open tables.

• Question 138:

  Which of the following best describes why one should use VARCHAR rather than CHAR in InnoDB?

  A. The average amount of space used will be less.
  B. Generally, there will be less disk I/O during processing.
  C. VARCHAR columns provide better transaction support.
  D. The optimizer always performs better with VARCHAR columns over CHAR columns.
  B. Generally, there will be less disk I/O during processing.