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 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 3

View the Exhibit and examine the structure of the customer table.

2021-06-04-19-34-43-bbbe9e3ac276119b5b1b2648c6325d40

You create the following trigger to ensure that customers belonging to category "A" or "B"
in the customer table can have a credit limit of more than 8000.

What is the outcome?

Options :

A : The trigger is fired, a message is displayed, and the update is successful

B : The trigger is fired and a message is displayed, but the update is rolled back.

C : The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.

D : The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.

Answer: A

Question 4

The collection method COUNT

Options :

A : Returns the last (largest) index numbers in a collection that uses integer subscripts.

B : Returns the number of elements that a collection currently contains.

C : Checks the Maximum Size of a Collection

D : None of the above.

Answer: B

Question 5

PL/SQL is a completely portable, ??? transaction processing language.

Options :

A : Low-performance

B : High-performance

C : Both 1 & 2

D : None of the above

Answer: B