Oracle Database 11g: Program with PL/SQL: 1Z0-144

User SCOTT has been granted CREATE ANY TRIGGER and ALTER ANY TABLE by the DBA. HR is an

existing schema in the database.

SCOTT creates the following trigger:

CREATE OR REPLACE TRIGGER drop_trigger

BEFORE DROP ON hr.SCHEMA

BEGIN

RAISE_APPLICATION_ERROR (-20000, `Cannot drop object');

END;

SCOTT does not grant the EXECUTE privilege on this trigger to any other users.

For which user(s) would this trigger fire by default when they drop an object in the HR schema?

A. Only HR

B. SCOTT and HR

C. Only SCOTT

D. SCOTT, HR, and SYS

Which tasks must be performed during the installation of the UTL_MAIL package? (Choose two.)

A. setting the UTL_FILE_DIR initialization parameter

B. running the utlmail.sql and prvtmail.plb scripts

C. setting the SMTP_OUT_SERVER initialization parameter

D. using the CREATE DIRECTORY statement to associate an alias with an operating system directory

E. granting read and WRITE privileges to control the type of access to files in the operating system

View the exhibit and examine the structure of the EMPLOYEES table.

EMPLOYEES_SEQ is an existing sequence. Examine the following block of code: Which statement is true about the above block of code?

A. It gives an error on execution because sequences cannot be used in anonymous blocks.

B. It consists of a single transaction.

C. It consists of two transactions.

D. The data is automatically committed after the block execution ends.