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

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

Options :

A : DDL

B : AFTER AUDIT

C : BEFORE ANALYZE

D : SHUTDOWN

E : SERVERERROR

F : STARTUP

G : BEFORE GRANT

Answer: A,D

Question 2

In which of the following scenarios would you recommend using associative arrays?

Options :

A : When you want to retrieve an entire row from a table and perform calculations

B : When you know the number of elements in advance and the elements are usually accessed sequentially

C : When you want to create a separate lookup table with multiple entries for each row of the main table, and access it through join queries

D : When you want to create a relatively small lookup table, where the collection can be constructed on memory each time a subprogram is invoked

Answer: D

Question 3

Which two are valid MODIFIER values for the PLSQL_WARNINGS parameter? (Choose two.)

Options :

A : DISABLE

B : ENABLE

C : ERROR

D : ALL

E : SEVERE

Answer: A,D

Question 4

View the Exhibit to examine the PLSQL block.

Which statement is true about the output of the PL/SQL block?

Options :

A : It executes and the Output is emprec.deptname: .

B : It executes and the Output is emprec.deptname: Sales.

C : It produces an error because NULL is assigned to the emprec.empid field in the record

D : It produces an error because the CHECK constraint is violated while assigning a value to the emprec.deptid field in the record.

Answer: A

Question 5

Which is true about counter variables in a FOR loop?

Options :

A : It must explicitly be declared.

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

C : It cannot be NULL.

D : It is accessible outside the body of the loop.

Answer: C