Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 21:

  Which of the following would be considered a good candidate table for compression?

  A. A table with data that needs only few updates in the future.
  B. A table with data that will not be updated in the future.
  C. A large table, such as those used for data warehousing.
  D. All MyISAM tables are good candidates for compression.
  B. A table with data that will not be updated in the future.

• Question 22:

  You have two databases, db1 and db2 and you have a table test in both of the databases. Your current default database is db1.

  Which of the following tables will be affected by the following command?

  mysql> GRANT SELECT, INSERT, UPDATE, DELETE ON test TO 'joe'@'%' IDENTIFIED BY 'sakila'

  A. db1.test
  B. db2.test
  C. Both db1.test and db2.test
  D. The statement will return an error, because no database was specified.
  A. db1.test

• Question 23:

  mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\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 where What does it mean that the possible_keys column value is NULL?

  A. No index is considered available for this query.
  B. No index exists for the table you are querying.
  C. You are not making use of any available indexes in your query.
  A. No index is considered available for this query.

• Question 24:

  Which of the following best describe the purpose of the long_query_time variable?

  A. It is used to tell the server when to log a query as slow.
  B. It is used to see the time it took the last longest query to run.
  C. It is used to tell the server after how many seconds to abort a query.
  D. It is used to tell the server the total CPU seconds that are allotted to a client connection before it shut down.
  A. It is used to tell the server when to log a query as slow.

• Question 25:

  Consider the following: mysql> EXPLAIN SELECT * FROM City WHERE CountryCode = 'USA'\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 where What does the possible_keys column in this output denote?

  A. Whether there are any indexes on the table(s) you are querying.
  B. If there are any indexes you may be able to use.
  C. Whether you are using any indexes in your query.
  D. If it is possible for you to include any indexes in your query.
  B. If there are any indexes you may be able to use.

• Question 26:

  What should you do in order to enhance the security of a standard MySQL installation on Unix- type operating systems?

  A. Disable the mysql_access program
  B. Run the mysql_secure_installation script
  C. Nothing; by default the security level of a MySQL installation is very high
  B. Run the mysql_secure_installation script

• Question 27:

  Which of the following are true regarding the usage of the IDENTIFIED BY clause in the GRANT statement used to create a new user account?

  A. There is no IDENTIFIED BY clause for the GRANT statement
  B. The IDENTIFIED BY clause is always optional
  C. The IDENTIFIED BY clause is always mandatory
  D. The IDENTIFIED BY clause may be mandatory depending on the current SQL mode
  E. The IDENTIFIED BY clause specifies the password to be used with the account
  F. The IDENTIFIED BY clause specifies an alternate user name for the account
  B. The IDENTIFIED BY clause is always optional
  D. The IDENTIFIED BY clause may be mandatory depending on the current SQL mode

• Question 28:

  Consider the following EXPLAIN output. mysql> EXPLAIN SELECT Name FROM City WHERE Population > 8000000\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 where Which of the following statements are true?

  A. The query cannot be optimized any better.
  B. No index could be used to perform the query.
  C. All 4079 rows of the table need to examined.
  D. The Name column should be indexed.
  E. The Population column should be indexed.
  B. No index could be used to perform the query.

• Question 29:

  How can the strict SQL mode provide added security?

  A. By restricting out of range values.
  B. By restricting incorrect data types.
  C. By limiting the operations that the server can perform.
  D. By rejecting actions that do not have values for columns without a default.
  D. By rejecting actions that do not have values for columns without a default.

• Question 30:

  Which of the following best describes the order in which MySQL considers host names and user names when a client attempts connection?

  A. Hostnames then usernames
  B. Usernames then hostnames
  C. Both hostnames and usernames are checked concurrently.
  A. Hostnames then usernames