Oracle Oracle Certifications 1Z0-874 Questions & Answers

• Question 81:

  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

  Correct Answer: B

• Question 82:

  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.

  Correct Answer: B

• Question 83:

  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.

  Correct Answer: A

• Question 84:

  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.

  Correct Answer: C

• Question 85:

  It is important to analyze queries that involve joins with EXPLAIN because...

  A. Joins are more prone to mistakes.

  B. Using EXPLAIN before executing the query helps the server prepare the statements used.

  C. Joins have the potential to cause more server processing if not defined correctly.

  Correct Answer: C

• Question 86:

  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

  Correct Answer: B

• Question 87:

  Granting access to the mysql database...

  A. Should never be done for any users.

  B. Should always be done for all users.

  C. Should only be done on administrator accounts.

  D. Should be done for anyone needing to create views

  Correct Answer: C

• Question 88:

  Which of the following are reasons to be selective when granting the FILE privilege to accounts?

  A. It could be used to execute scripts on the server host.

  B. It could be used to read files on the filesystem of the server host.

  C. It could be used to write files to the filesystem of the server host.

  Correct Answer: B

• Question 89:

  Why should you be selective when granting the PROCESS privilege to an account?

  A. Because it allows the client to control running processes on the server.

  B. Because it allows the client to process scripts.

  C. Because it allows for the use of the SHOW PROCESSLIST command, which can expose data.

  D. Because it allows for the use of stored routines.

  Correct Answer: C

• Question 90:

  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.

  Correct Answer: A