Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 31:

  The user 'joe' connecting from the host example.com has full access to all databases on the server:

  mysql> SHOW GRANTS FOR 'joe'@'example.com';

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

  | Grants for [email protected] |

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

  | GRANT ALL PRIVILEGES ON *.* TO 'joe'@'example.com' |

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

  1 row in set (0.00 sec)

  You need to restrict the user from accessing the mysql database. Will the following statement do this?

  REVOKE ALL PRIVILEGES ON mysql.* FROM 'joe'@'example.com'

  A. Yes
  B. No
  C. The answer cannot be determined from the information provided.
  B. No

• Question 32:

  Doing SELECT COUNT(*) queries in InnoDB is efficient...

  A. Yes, because InnoDB stores a row count in the table.
  B. No, because InnoDB does not store a row count in the table.
  C. Yes, if the table has any indexes.
  D. No, because the table must be sorted.
  B. No, because InnoDB does not store a row count in the table.

• Question 33:

  For which of the following objects can privileges be specified?

  A. Host
  B. Global
  C. Database
  D. Table
  E. Column
  F. Row
  C. Database

• Question 34:

  Which of the following optimizations could be made based on data collected in the slow query log?

  A. Tune server parameters.
  B. Change the storage engines in use.
  C. Make changes to the network infrastructure.
  D. Rewrite queries to perform more efficiently.
  E. Normalize data or add indexes to the tables that the queries use.
  C. Make changes to the network infrastructure.

• Question 35:

  Which factors can be considered in a stored routine to allow or disallow access or modification of data?

  A. The identity of the client user
  B. The current date and time
  C. The CPU load of the system
  D. The number of current connections
  B. The current date and time

• Question 36:

  Which of the following are requirements for running more than one MySQL server on the same machine?

  A. On Windows each server that runs as a service must have a different service name.
  B. Each server must have its own log files.
  C. Each server must share the same error log.
  D. Each server must run on a different disk.
  E. Each server must have its own network interfaces.
  F. There must be more than one processor on the machine.
  G. InnoDB tablespace files must be separate between servers.
  D. Each server must run on a different disk.

• Question 37:

  Which of the following best describes the relationship between MAX_ROWS, AVG_ROW_LENGTH and the max table size?

  A. MAX_ROWS * AVG_ROW_LENGTH tells MySQL how large you expect the table to grow to.
  B. MAX_ROWS + AVG_ROW_LENGTH tells MySQL to not let the table grow past that size.
  C. Specifying MAX_ROWS and AVG_ROW_LENGTH will prevent MySQL from growing the table beyond that limit.
  D. Specifying MAX_ROWS and AVG_ROW_LENGTH doesn't prevent MySQL from growing the table beyond that limit.
  D. Specifying MAX_ROWS and AVG_ROW_LENGTH doesn't prevent MySQL from growing the table beyond that limit.

• Question 38:

  Suppose the key column of an EXPLAIN output is NULL. What does this mean?

  A. There are no indexes available for use in the query.
  B. There are no indexes on the table you are querying.
  C. There are no indexes considered useful for processing that query.
  C. There are no indexes considered useful for processing that query.

• Question 39:

  Which of the following statements are true regarding the slow query log?

  A. The slow query log can be switched on with the log_slow_queries option.
  B. The slow query log is always enabled.
  C. The slow query log contains queries that don't utilize any index.
  D. To have the slow query log contain queries that don't utilize any index, the log-queries-not- using-indexes option needs to be set.
  E. The slow query log will contain queries that take more than 10 seconds.
  F. The slow query log will contain queries that take more seconds than configured in the long_query_time option.
  G. You can use the mysqldumpslow command line tool to summarize the content of the slow query log.
  H. You can use the SHOW SLOW QUERIES statement to display all entries in the slow queries log.
  A. The slow query log can be switched on with the log_slow_queries option.
  B. The slow query log is always enabled.
  F. The slow query log will contain queries that take more seconds than configured in the long_query_time option.
  H. You can use the SHOW SLOW QUERIES statement to display all entries in the slow queries log.

• Question 40:

  Which of the following describe the correct single-statement syntax for allowing the existing user 'kofi'@'%' to perform SELECT, INSERT, DELETE and UPDATE actions on all tables in the world database?

  A. GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%';
  B. GRANT SELECT INSERT DELETE UPDATE ON world.* TO 'kofi'@'%'
  C. GRANT world.* (SELECT, INSERT, DELETE, UPDATE) TO 'kofi'@'%'
  D. GRANT (SELECT, INSERT, DELETE, UPDATE) ON world.* TO 'kofi'@'%'/TT>
  E. Unless using ALL PRIVILEGES, it is not possible to assign more than one type of privilege at any one time.
  A. GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%';