Question 1

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

Options :

A : DISABLE

B : ENABLE

C : ERROR

D : ALL

E : SEVERE

Answer: A,D

Question 2

Which system events can be used to create triggers that fire both at database and schemalevels? (Choose all that apply)

Options :

A : AFTER LOGON

B : AFTER STARTUP

C : BEFORE SHUTDOWN

D : AFTER SERVERERROR

Answer: A,D

Question 3

Examine this PL/SQL function:What happens when the function is created with PLSQL_WARNINGS set to ENABLE: ALL?

Options :

A : There are no compilation warnings or errors.

B : It fails compilation.

C : An information compilation warning is generated.

D : A performance compilation warning is generated.

E : A severe compilation warning is generated.

Answer: C

Question 4

Which is true about EXIT and CONTINUE statements?

Options :

A : They can be used in any type of loop.

B : They must have a WHEN condition.

C : They have the same effect on the execution of a loop.

D : They must use labels.

Answer: A

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

Smartly Prepare Exam with Free Online 1Z0-149 Practice Test