Practice 1Z0-149 Exam Online

Question 1

For which three SYSTEM EVENTS can triggers be created? (Choose three.)

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

Question 2

Consider a function totalEmp () which takes a number as an input parameter and returns the total number of employees who have a salary higher than that parameter.

Examine this PL/SQL package AS –

Which two definitions of totalEmp () result in an implicit conversion by Oracle Database on executing this PL/SQL block?

A :

B :

C :

D :

Answer: B,C

Question 3

Which of the following is true about PL/SQL index-by tables?

A : It is a set of key-value pairs.

B : Each key is unique and is used to locate the corresponding value.

C : The key can be either an integer or a string.

D : All of the above.

Answer: D

Question 4

Which PRAGMA statement may enable associated PL/SQL functions to run more efficiently when called from SQL?

A : PRAGMA SERIALLY_REUSABLE;

B : PRAGMA UDF;

C : PRAGMA INLINE (‘< function_name >’, ‘YES’);

D : PRAGMA AUTONOMOUS_TRANSACTION;

Answer: B

Question 5

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?

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

Name:	Oracle Database 19c: Program with PL/SQL
Exam Code:	1Z0-149
Certification:	OPN Certified Specialist
Vendor:	Oracle
Total Questions:	389
Last Updated:	Apr 25, 2024

Oracle 1Z0-149