Oracle Oracle Certifications 1Z0-874 Questions & Answers

• Question 111:

  The password for the existing user 'kofi'@'agric.comp1.com' must be changed to "Sakila". Which of the following will do that?

  A. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = 'Sakila'

  B. SET PASSWORD 'Sakila' FOR 'kofi'@'agric.comp1.com'

  C. SET PASSWORD FOR 'kofi'@'agric.comp1.com' = PASSWORD('Sakila')

  D. SET PASSWORD('Sakila') FOR 'kofi'@'agric.comp1.com'

  Correct Answer: C

• Question 112:

  What type of resource limitations may be placed on a user account with the GRANT statement?

  A. The number of times per hour that an account is allowed to connect to the server

  B. The number of queries per hour an account is allowed to issue

  C. The number of updates per hour an account is allowed to issue

  D. The maximum number of simultaneous connections an account can have

  E. Resource limits can only be specified globally, not per-account

  F. MySQL does not have provisions for limiting resource usage

  Correct Answer: F

• Question 113:

  Which of the following best describe how access control occurs in MySQL?

  A. On login, the username, hostname and password are checked to allow access. On every query execution, the username, hostname and current object access permissions are checked.

  B. On login, the username, hostname and password are checked to allow access. On every query execution, username, hostname, password and current object access permissions are checked.

  C. On login, the username, hostname and password are checked to allow access and the object access permissions at login time are used for all subsequent operations for the lifetime of the connection.

  Correct Answer: A

• Question 114:

  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.

  Correct Answer: B

• Question 115:

  You have been granted SELECT, INSERT and DELETE privileges on the table city in the world database. You log in, and exercise all your privileges without any problems.

  While you are still connected and doing work, the administrator removes your DELETE privileges and informs you by mail that you can no longer delete from table city.

  Being skeptical, you decided to test your privileges and realize that you still have them all. What is are the most likely causes of this?

  A. The administrator forgot to revoke your UPDATE privilege

  B. The administrator forgot to revoke your SELECT privilege

  C. The administrator removed the DELETE privilege by performing an UPDATE directly on the mysql.table_priv table

  D. The administrator did not execute FLUSH PRIVILEGES

  Correct Answer: D

• Question 116:

  What are reasons to prefer using GRANT and REVOKE statements over editing the privilege tables directly?

  A. Using GRANT and REVOKE allows the server to figure out the right tables and do all the appropriate work

  B. All grant tables in memory are immediately updated on GRANT and REVOKE

  C. Making changes directly to the grant tables, one must remember to execute flush privileges to make the changes take effect

  D. GRANT and REVOKE statements allow you to do more fine-grained tuning of user privileges than does editing the grant tables directly.

  E. None of the above

  Correct Answer: B

• Question 117:

  Assuming that the account 'joe'@'%' does not already exist on the server, executing the statement mysql> CREATE USER 'joe'@'%' IDENTIFIED BY 'sakila'

  will have the following consequences:

  A. The account 'joe'@'%' is created on the server. However, clients cannot connect using this account until further privileges have been assigned to the account.

  B. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account, but will not be able to access any databases, tables or stored routines

  C. The account 'joe'@'%' is created on the server. Clients may connect to the server using this account and execute stored routines, but will not be able to access any databases or tables

  D. Nothing; there is no such command as CREATE USER

  Correct Answer: B

• Question 118:

  Assuming that the user account 'joe'@'example.com' exists, executing DROP USER

  'joe'@'example.com' has the following consequences:

  A. The user account will immediately be removed from the server, if no object-level privileges are in effect for that account

  B. The account will be removed from the server the next time FLUSH PRIVILEGES is executed, if no object-level privileges are in effect for that account

  C. The account and all associated privileges will immediately be removed from the server

  D. The user account and all associated privileges will be removed from the server the next time FLUSH PRIVILEGES is executed.

  Correct Answer: C

• Question 119:

  The account 'ulf'@'localhost' has previously been created with the statement GRANT ALL PRIVILEGES ON *.* TO 'ulf'@'localhost' IDENTIFIED BY 'w01f'

  This account should no longer be used, so you issue the following command:

  REVOKE ALL PRIVILEGES ON *.* FROM 'ulf'@'localhost'

  After executing this statement, you inspect the server and find that no clients are connected using that account. However, the next day you notice that the account 'ulf'@'localhost' is indeed connected to the server.

  Why is it still possible for the account 'ulf'@'localhost' to connect to the server?

  A. Specifying GRANT ALL PRIVILEGES ON *.* effectively created an administrator account, which cannot be disabled through the REVOKE statement

  B. The REVOKE statement used does not remove the USAGE privilege from the account, allowing new connections with that account.

  C. The REVOKE command was not followed by a FLUSH PRIVILEGES command, so the account was never actually disabled

  D. The ON *.* clause should not be specified when disabling an account

  Correct Answer: B

• Question 120:

  In order to create an account where no username is needed for login, ...

  A. the account should be created with a username consisting of the empty string

  B. the account should be created with the username "anon"

  C. the account should be created with the username "%"

  D. Accounts cannot be specified in a way such that no username is required

  E. None of the above

  Correct Answer: A