Oracle Database 19c: Program with PL/SQL (1z1-149) Free Practice Test

Question 1

Which two are true about packages? (Choose two.)

A. A package definition must have a specification and body.

B. Variables and cursors defined in a package specification are visible to all subprograms in the same schema that has the package.

C. Package specifications can be compiled without their bodies.

D. Standalone subprograms that reference a package can be compiled only after both the package specification and body are compiled.

E. Modifications to a packaged procedure's body automatically cause recompilation of subprograms that invoke the procedure.

Correct Answer: B,C

Question 2

Which is true about EXIT and CONTINUE statements?

A. They have the same effect on the execution of a loop.

B. They must have a WHEN condition.

C. They must use labels.

D. They can be used in any type of loop.

Correct Answer: D

Question 3

Which two PL/SQL elements can be deprecated using the DEPRECATE pragma? (Choose two.)

A. TRIGGER BODY

B. VARIABLES

C. DATABASE LINKS

D. ANONYMOUS BLOCK

E. PACKAGES

Correct Answer: C,E

Question 4

Examine the EMPLOYEES table structure:

Now, examine this code:

Which statement is true about the result of executing this block?

A. It will return an error at line 8.

B. It will execute successfully by rounding up the salary of EMP_ID 200 to the appropriate value.

C. It will return an error at line 3.

D. It will return an error at line 2.

E. It will execute successfully provided the salary of EMP_ID 200 does not exceed the value 99999.

Correct Answer: E

Question 5

Which is the correct method to implement a local subprogram in an anonymous block?

A.

B.

C.

D.

Correct Answer: A

Question 6

Examine this table in the SH schema:

Now, examine this code:

Which two changes are required to ensure that PDT_REPORT executes successfully? (Choose two.)

A. In line 1, add the default parameter DEFAULT 2000.

B. In line 6, replace P_PDT_PRICE parameter name with CUR_PRICE.

C. In line 3, replace CUR_PRICE with P_PDT_PRICE in the query condition.

D. In line 2, add the default parameter DEFAULT 2000.

E. In line 2, change IN OUT mode to IN mode.

F. In line 1, change IN OUT mode to IN mode.

Correct Answer: A,E

Question 7

Which three are true regarding code based access control (CBAC)? (Choose three.)

A. You can use CBAC to attach database roles to a PL/SQL function, procedure, or package.

B. CBAC roles can be granted to a program unit only if they are directly granted to its owner.

C. In CBAC, the ADMIN and DELEGATE options cannot both be granted to the same user.

D. In a multitenant environment, the DELEGATE option of CBAC cannot be used.

E. You can use CBAC to attach database roles to a PL/SQL function or procedure only.

F. CBAC roles can be granted to a program unit only if they are the predefined roles automatically defined by the standard scripts as part of database creation.

G. CBAC cannot be used to secure definer's rights.

Correct Answer: A,B,C

Welcome to TestSimulate

Oracle Database 19c: Program with PL/SQL (1z1-149) Free Practice Test