1z1-149 by Oracle Valid Free Exam Practice Test

Question 1

Examine this DECLARE section:

Which two lines are valid? (Choose two.)

A. line 5 B. line 2 C. line 6 D. line 7 E. line 4 F. line 3

Correct Answer: A,B

Question 2

Examine this table definition in the SH schema.

A row with PDT_ID = 1 exists. Which two blocks of code will execute successfully by user SH and give the same output? (Choose two.)

A.

B.

C.

D.

Correct Answer: A,D

Question 3

Examine these statements which execute successfully:

Which anonymous block executes successfully?

A.

B.

C.

D.

Correct Answer: A

Question 4

Examine these facts:
Table EMP exists in schema USERA with columns SALARY and EMP_ID.
EMP_ID is the primary key with values ranging from 1 to 100.
USERA now executes these statements successfully:

USERA then grants execute privilege on procedure MYPROC to USERB.
USERB exists in the database identified by pdb1 but does not have select privilege on USERA.EMP.
USERB now executes these statements:
conn userB/userB@pdb1
execute userA.myproc;
Which is true?

A. It results in an error because Authid Definer is missing from MYPROC. B. It results in an error because Authid Current_User is missing from MYPROC. C. It results in an error because USERB doesn't have select privilege on USERA.EMP. D. It executes successfully.

Correct Answer: D

Question 5

Examine this row of data from the EMPLOYEES table:

Now, examine this block of code which executes successfully:

What is the value of v_commission?

A. 15000 B. 10000 C. 2500 D. 5000

Correct Answer: C

Question 6

Which three are true about PL/SQL subprograms? (Choose three.)

A. Host variables can be referenced inside any PL/SQL subprogram. B. A subprogram's session state is retained even if any of the session's instantiated subprograms are invalidated and revalidated. C. Subprograms are cached by default and shared among users, thereby reducing memory requirements. D. Results of a subprogram can be cached in the SGA such that sessions connected to the same instance can reuse these results when available. E. Users granted execute privilege on a procedure compiled with definer's rights require grants to access objects belonging to the definer that are referenced in the procedure. F. Reuse of parsed PL/SQL code from the shared SQL area reduces parsing overhead. G. A PL/SQL procedure can invoke an external code block written in a different programming language.

Correct Answer: C,F,G

Question 7

Which two are true about named notations in a PL/SQL subprogram? (Choose two.)

A. Any optional parameters can be omitted in the invocation call. B. The actual parameters must be specified in the same order as the formal parameters are declared. C. Only trailing optional parameters can be omitted in the invocation call. D. Specifying actual parameters in the wrong order results in the subprogram terminating with an exception. E. The subprogram invocations must be changed when the formal parameter list acquires new required parameters.

Correct Answer: A,B

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