Free Oracle 1Z0-149 Exam Questions

Become Oracle Certified with updated 1Z0-149 exam questions and correct answers

Page: 1 / 78

Total 389 Questions | Updated On: Mar 28, 2021

Add To Cart

Question 1

Which is true about counter variables in a FOR loop?

A : must explicitly be declared.

B : can be modified in the body of the loop.

C : cannot be NULL.

D : is accessible outside the body of the loop.

Answer: C

Question 2

Which three SQL statements, embedded in PL/SQL, typically benefit from using variables declared with

%ROWTYPE? (Choose three.)

A : EATE

B : OP

C : DATE

D : LECT

E : LETE

F : TER

G : ERT

Answer: A,C,D

Question 3

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

A : TER LOGON

B : TER STARTUP

C : FORE SHUTDOWN

D : TER SERVERERROR

Answer: A,D

Question 4

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 : trigger is fired, a message is displayed, and the update is successful

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

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

D : 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 5

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

Page: 1 / 78

Total 389 Questions | Updated On: Mar 28, 2021

Add To Cart