Oracle Oracle Certifications 1Z0-874 Questions & Answers

• Question 121:

  Which of the following describe the correct single-statement syntax for allowing the existing user 'kofi'@'%' to perform SELECT, INSERT, DELETE and UPDATE actions on all tables in the world database?

  A. GRANT SELECT, INSERT, DELETE, UPDATE ON world.* TO 'kofi'@'%';

  B. GRANT SELECT INSERT DELETE UPDATE ON world.* TO 'kofi'@'%'

  C. GRANT world.* (SELECT, INSERT, DELETE, UPDATE) TO 'kofi'@'%'

  D. GRANT (SELECT, INSERT, DELETE, UPDATE) ON world.* TO 'kofi'@'%'/TT>

  E. Unless using ALL PRIVILEGES, it is not possible to assign more than one type of privilege at any one time.

  Correct Answer: A

• Question 122:

  Consider the following GRANT statement:

  GRANT USAGE ON *.* TO 'kofi'@'localhost' IDENTIFIED BY 'password'

  What is the implications of executing that statement?

  A. Kofi can access all database objects.

  B. Kofi can access all his tables.

  C. Kofi can display server system and status variables.

  D. Kofi can grant privileges to others.

  E. Kofi can access all database objects belonging to localhost.

  Correct Answer: C

• Question 123:

  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.

  Correct Answer: B

• Question 124:

  For which of the following objects can privileges be specified?

  A. Host

  B. Global

  C. Database

  D. Table

  E. Column

  F. Row

  Correct Answer: C

• Question 125:

  Privileges for using stored routines can be specified at the following levels:

  A. Server-wide

  B. Per database

  C. Per routine

  D. The ability to use stored procedures is not governed by the privilege system.

  Correct Answer: ABC

• Question 126:

  How can stored routines be used to check for constraints or legality of incoming data?

  A. They can make use of the VALIDATE DEFINER setting.

  B. They can not be used to check for constraints or legality of data.

  C. They can check and only perform an action if the incoming values match a specified value.

  Correct Answer: C

• Question 127:

  Which of the following statements about the slow query log is true?

  A. The slow query log will always contain just slow queries.

  B. The slow query log may not always contain just slow queries.

  C. The slow query log always logs more than just slow queries.

  Correct Answer: B

• Question 128:

  When working with stored routines, which of the following are true in regards to the effect on the amount of data exchanged between client and server?

  A. They may increase the amount of data exchanged.

  B. They can help reduce the amount of data exchanged.

  C. They have no effect on the amount of data exchanged.

  Correct Answer: B

• Question 129:

  Which of the following statements are true of how access control is based?

  A. It is based off of an access control table in the mysql database.

  B. It is based off of grant tables in the mysql database.

  C. It is based off of an access control list stored in the data directory.

  D. It is based off of an access control list stored inside the .frm files of each table.

  Correct Answer: B

• Question 130:

  The stored function year_to_date is created by the 'root'@'localhost' account as follows:

  CREATE FUNCTION year_to_date ()

  RETURNS DECIMAL(10,2)

  SQL SECURITY DEFINER

  BEGIN

  ...

  END;

  Within the routine body, a number of calculations are made on data in the financials table and the

  calculated value is returned. The only account which can access the financials table is 'root'@'localhost'. If a client connects with the account 'joe'@'localhost' and calls the year_to_date function, what will happen?

  A. The function will always execute as if it was 'root'@'localhost' that invoked it since SQL SECURITY DEFINER has been specified.

  B. The function will not execute, as 'joe'@'localhost' does not have access to the financials table

  C. The function will not execute as SQL SECURITY DEFINER has been specified. It would execute if instead SQL SECURITY INVOKER had been specified

  D. If the account 'joe'@'localhost' has the EXECUTE privilege on year_to_date, the function will complete

  successfully

  Correct Answer: D