Confidently Practice Online with Free 1Z0-149 Exam Cram

Practice your Oracle Database 19c: Program with PL/SQL certification test with free 1Z0-149 exam cram and take control of your certification preparation. At FreeExamCram, you can practice online for free using real 1Z0-149 exam dumps, verified questions, and expert-designed free online practice tests. Moreover our Oracle 1Z0-149 exam cram backed by our confidence-boosting refund guarantee.

Question 1

Which data dictionary view contains the list of procedures and functions defined within package specification that you can execute?

Options :

A : ALL_SOURCE

B : ALL_DEPENDENCIES

C : ALL_OBJECTS

D : ALL_PROCEDURES

E : ALL_PLSQL_OBJECT_SETTINGS

Answer: D

Question 2

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

Options :

A : AFTER LOGON

B : AFTER STARTUP

C : BEFORE SHUTDOWN

D : AFTER SERVERERROR

Answer: A,D

Question 3

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 4

What can the value of the INTO clause be while fetching data in an explicit cursor?

Options :

A : PL/SQL scalar variables only

B : PL/SQL variables or records

C : Collections or records only

D : Records only

Answer: B

Question 5

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