Oracle 1Z0-874 Online Practice Questions and Exam Preparation

Oracle 1Z0-874 Online Questions & Answers

• Question 111:

  Consider the following query:

  GRANT ALL ON world.* TO 'web'@'hostname'

  What privileges would this give this user?

  A. All privileges including GRANT.
  B. All privileges except GRANT.
  C. SELECT, INSERT, UPDATE and DELETE
  D. ALL can not be used when granting privileges.
  B. All privileges except GRANT.

• Question 112:

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

  A. Because it allows a client to kill other client connections.
  B. Because it allows a client to shutdown the server.
  C. Because it allows changing of the server runtime configuration.
  D. Because it allows client accounts to takeover other client accounts.
  A. Because it allows a client to kill other client connections.

• Question 113:

  Which of the following steps are used to create database symbolic links on Windows?

  A. Stop the server.
  B. Restart the server.
  C. Use the ln -s command.
  D. Update your my.ini with the path to the new location.
  E. Move the database directory from the data directory to a new location.
  F. Create a file in the data directory with the database name with an extension of .sym that contains the full path to the new location.
  F. Create a file in the data directory with the database name with an extension of .sym that contains the full path to the new location.

• Question 114:

  In the following query, the Population column is indexed:

  mysql> EXPLAIN SELECT Name

  -> FROM Country

  -> WHERE Code LIKE '%B%' AND Population > 10000 \G

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

  id: 1

  select_type: SIMPLE

  table: Country type:

  ALL possible_keys:

  i_pop key: NULL

  key_len: NULL

  ref: NULL

  rows: 239

  Extra: Using where

  Which of the following best describes how to deal with the key value of the EXPLAIN output?

  A. Use FORCE KEY.
  B. Use USE INDEX.
  C. Use FORCE INDEX.
  D. Use USE POSSIBLE_KEY.
  D. Use USE POSSIBLE_KEY.

• Question 115:

  Given the result of the following query:

  mysql> SELECT Host, User FROM mysql.user WHERE User='joe';

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

  | Host | User |

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

  | % | joe |

  | example.com | joe |

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

  2 rows in set (0.00 sec)

  A client connection is established with the username joe from the host example.com.

  Assuming that the login is successful, which of the entries shown in the mysql.user table are used to authenticate the client connection for subsequent query executions, and why?

  A. The 'joe'@'%' account is used for all authentication, as MySQL will always use the most general host name possible.
  B. The 'joe'@'example.com' account is used for all authentication, as MySQL will always use the most specific hostname possible.
  C. For every query, the 'joe'@'example.com' account is checked first. If that does not have the proper permissions, 'joe'@'%' will be used as MySQL will check all relevant accounts, with the most specific hostname first.
  D. For every query, the 'joe'@'%' account is checked first. If that does not have the proper permissions, 'joe'@'example.com' will be used as MySQL will check all relevant accounts, with the most general hostname first.
  B. The 'joe'@'example.com' account is used for all authentication, as MySQL will always use the most specific hostname possible.

• Question 116:

  Which of the following statements are true regarding wildcards in the host name of an account specification?

  A. The '%' character is used to match any number of characters or numbers
  B. The '*' character is used to match any number of characters or numbers
  C. The '_' character is used to match any number of characters or numbers
  D. The '.' character is used to match any single character or number
  E. Wildcards may be used to match any number of characters at the beginning of the host name or IP address only
  F. Wildcards may be used to match any number of characters at the end of the host name or IP address only
  G. Wildcards may be used to match any number of characters anywhere in the host name or IP address
  A. The '%' character is used to match any number of characters or numbers
  F. Wildcards may be used to match any number of characters at the end of the host name or IP address only
  G. Wildcards may be used to match any number of characters anywhere in the host name or IP address

• Question 117:

  When performing diagnostic functions on a server should excessive start and stop messages be looked for in the error log, and why?

  A. No, start and stop messages are of no relevance to diagnostics.
  B. Yes, because there is a bug in mysqld that can cause multiple start and stop messages to be inserted in the log.
  C. No, because they will not provide any information as to what is wrong.
  D. Yes, because they can indicate that there is something causing the server to restart unexpectedly and not due to normal startup and shutdown.
  D. Yes, because they can indicate that there is something causing the server to restart unexpectedly and not due to normal startup and shutdown.

• Question 118:

  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.
  C. Joins have the potential to cause more server processing if not defined correctly.

• Question 119:

  When creating a new user account, which of The following are valid ways of specifying the hostname part of the account?

  A. Leaving it unspecified, allowing connections from any host
  B. Using localhost
  C. Using a hostname, such as agric.comp1.com
  D. Using an IP address, such as 100.160.1.47
  E. Using a hostname pattern with wildcards, such as %.comp1.com
  F. Using an IP number with wildcards, as 100.160.1.%
  G. Using an IP number/netmask combination such as 100.160.0.0/255.255.0.0
  H. User accounts do not contain a hostname part
  A. Leaving it unspecified, allowing connections from any host
  B. Using localhost
  H. User accounts do not contain a hostname part

• Question 120:

  Which of the following best describes what may limit the number of simultaneous connections to the server? What are possible ways to increase it?

  A. It is limited by the maximum size of the table cache.
  B. The --key_cache option may be used to increase the limit.
  C. The maximum number of threads per-process of the operating system.
  D. The operating system may be able to be reconfigured to increase this limit.
  A. It is limited by the maximum size of the table cache.