Oracle Oracle Certifications 1Z0-874 Questions & Answers

• Question 91:

  Consider a stored procedure or function that is going to be executed. Which of the following statements are true?

  A. First, the database level privileges are checked, then the global privileges, then the stored routine level privileges.

  B. First, the global privileges are checked, then the stored routine level privileges, then the database level privileges.

  C. First, the global privileges are checked, then the database level privileges, then the stored routine level privileges.

  D. If the stored routine contains commands that access other databases and tables, access control for these objects will also be processed.

  Correct Answer: B

• Question 92:

  In regards to security, which of the following statements are true?

  A. mysqld should not be run as root or administrator.

  B. mysqld should be run as root or administrator.

  C. The user owning the server process should own all files and directories to which the server may write.

  D. The root or admininistrator users should own all files related to the server process

  Correct Answer: A

• Question 93:

  Is it ever safe to start the MySQL server as root?

  A. No it is never safe to start it as root.

  B. Yes it is always safe to start it as root.

  C. Yes provided you make it switch the effective user to mysql.

  D. No because you can not make it switch the effective user if started as root.

  Correct Answer: C

• Question 94:

  Which of the following should be done to enable secure logging of events which may be needed for recovery operations and to track down security incidents?

  A. Enable the binary log

  B. Enable the slow log

  C. Enable the general log

  D. Set the --encrypt-logs option

  E. Set permissions on log files so they are only readable by the user owning the mysql process

  Correct Answer: D

• Question 95:

  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.

  Correct Answer: A

• Question 96:

  You need to allow the user 'joe'@'example.com' the privilege to create and alter stored routines in the world database, but you do not want that user to be able to change any table definitions. The user already has the required permissions to access table data in the database.

  Which of the following will achieve that?

  A. mysql> GRANT ALL ROUTINE PRIVILEGES ON world.* TO 'joe'@'example.com';

  B. mysql> GRANT ALL PRIVILEGES ON world.* TO 'joe'@'example.com';

  C. mysql> GRANT ALL PRIVILEGES ON PROCEDURE world.* TO 'joe'@'example.com';mysql> GRANT ALL PRIVILEGES ON FUNCTION world.* TO 'joe'@'example.com';

  D. mysql> GRANT CREATE ROUTINE ON world.* TO 'joe'@'example.com';mysql> GRANT ALTER ROUTINE ON world.* TO 'joe'@'example.com';

  E. You must use GRANT ALL PRIVILEGES ON world.routine1_name, world.routine2_name ... TO 'joe'@'example.com', replacing routine1_name etc. with the names of each of the stored routines the user may want to create or alter

  F. This cannot be done; permissions on tables and stored routines are always shared.

  Correct Answer: D

• Question 97:

  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

  Correct Answer: BD

• Question 98:

  As an administrator, you attempt to create the account 'joe'@'example.com' with the following statement:

  GRANT SELECT, UPDATE, DELETE ON world.* TO 'joe'@'example.com'

  Which of the following best describe the effects of issuing this statement?

  A. The account is not created, as you must always specify a password for new users

  B. Depending on active SQL modes, you may be prevented from creating the account because no password is specified. Otherwise, an account with no password is created.

  C. An account with no password is created, regardless of SQL modes. The password will not need to be set at a later time.

  D. Since no password is specified, the account is created with an empty password that must be changed by the user on first login

  E. There is not enough information provided to determine the outcome of executing that statement.

  Correct Answer: A

• Question 99:

  What is the effect of using WITH GRANT OPTION when executing the following statement?

  GRANT SELECT, UPDATE, DELETE ON world.*

  TO 'joe'@'example.com'

  IDENTIFIED BY 'Sakila'

  WITH GRANT OPTION

  A. Nothing; WITH GRANT OPTION is not a valid clause in GRANT commands.

  B. The account 'joe'@'example.com' may grant SELECT, UPDATE and DELETE privileges on tables in the world database to other users

  C. The account 'joe'@'example.com' may grant any type of privilege on tables in the world database to other users

  D. The account 'joe'@'example.com' becomes an administrator account

  Correct Answer: B

• Question 100:

  In replication the master server logs updates to this/these databases by default: A. No database.

  B. The default database

  C. The mysql database

  D. All databases

  E. All databases but mysql

  Correct Answer: D