Online 1Z0-149 Practice Test

Question 1

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 2

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

View the Exhibit to examine the PL/SQL code.

Identify the correct output for the code.

Options :

A : King 17-JUN-87 1500

B : King 17-JUN-87 24000

C : King current sysdate 1500

D : King current sysdate 24000

Answer: C

Question 5

Which statement is true about the DBMS_PARALLEL_EXECUTE package?

Options :

A : DBMS_PARALLEL_EXECUTE is a SYS-owned package and can be accessed only by a user with DBA privileges.

B : To execute chunks in parallel, users must have CREATE JOB system privilege

C : No specific system privileges are required to create or run parallel execution tasks

D : Only DBAs can create or run parallel execution tasks.

E : Users with CREATE TASK privilege can create or run parallel execution tasks.

Answer: B

EXPERTY DESIGNED 1Z0-149 PRACTICE TEST