Question 1

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:

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?

Options :

A : Only HR

B : SCOTT and HR

C : Only SCOTT

D : SCOTT, HR, and SYS

Answer: A

Question 2

When modifying procedure code, the procedure must be re-executed to validate and store it in the database. True or False?

Options :

A : True

B : False

Answer: A

Question 3

If left out, which of the following would cause an infinite loop to occur in a simple loop?

Options :

A : LOOP

B : END LOOP

C : IF-THEN

D : EXIT

Answer: B

Question 4

What is the statement to remove a procedure from a database?

Options :

A : ALTER PROCEDURE

B : DROP PROCEDURE

C : DELETE PROCEDURE

D : TRUNCATE procedure.

Answer: B

Question 5

Which of the following is not true about the Constructors?

Options :

A : These are functions that return a new object as its value.

B : Every object has a system defined constructor method.

C : The name of the constructor is same as the object type.

D : None of the above.

Answer: D

Higher Test Marks with Free Online 1Z0-149 Exam Practice

Buying Options: