Online Access Free Oracle.1Z0-144.v2022-11-03.q94 Practice Test (Page 10)

1Z0-144 Exam Question 41

Examine the following PL/SQL code:

Which statement is true about the fetch statements in the PL/SQL code?

A.Each fetch retrieves the first row and assigns values to the target variables.

B.Each fetch retrieves the next consecutive row and assigns values to the target variables.

C.Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.

D.They produce an error because you must close and reopen the cursor before each fetch -statement

1Z0-144 Exam Question 42

/temp/my_files is an existing folder in the server, facultylist.txt is an existing text file in this
folder
Examine the following commands that are executed by the DBA:
SQL>CREATE DIRECTION my_dir AS ' /temp/my_files':
SQL>GRANT READ ON DIRECTORY my_dir To pubiic:
View the Exhibit and examine the procedure created by user SCOTT to read the list of faculty names from the text file.

SCOTT executes the procedure as follows:
SQL>SET SERVEROUTPUT ON
SQL>EXEC read_file ('MY_DIR', FACULTYLIST.TXT')
What is the outcome?

A.It goes into an infinite loop.

B.It executes successfully and displays the list of faculty names followed by a "no data found" error message.

C.It does not execute and displays an error message because the end-of-file condition is not taken care of.

D.It executes successfully and displays only the list of faculty names.

1Z0-144 Exam Question 43

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What is the outcome when the code is executed?

A.Both blocks compile and execute successfully when called.

B.The CALC_SAL procedure gives an error on compilation because the amt variable should be declared in the RAISE_SALARY procedure.

C.The CALC_SAL procedure gives an error on compilation because the RAISE_SALARY procedure cannot call the stand-alone increase function.

D.Both blocks compile successfully but the CALC_SAL procedure gives an error on execution.

1Z0-144 Exam Question 44

Which two statements are true about the continue statement? (Choose two.)

A.The PL/SQL block execution terminates immediately.

B.The CONTINUE statement cannot appear outside a loop.

C.The loop completes immediately and control passes to the statement after end loop.

D.The statements after the continue statement in the iteration are executed before terminating the LOOP.

E.The current iteration of the loop completes immediately and control passes to the next iteration of the loop.

1Z0-144 Exam Question 45

Which two statements are true about the usage of the cursor for loops? (Choose two.)

A.The implicit open, fetch, exit, and close of the cursor happen.

B.The record type must be explicitly declared to control the loop.

C.The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.

D.The cursor needs to be closed after the iteration is complete.

Latest Upload: 166ACSM.020-222.v2025-09-11.q48; 156VMware.5V0-31.23.v2025-09-10.q73; 130Oracle.1z0-915-1.v2025-09-10.q24; 159Citrix.1Y0-231.v2025-09-10.q87; 134SAP.C-THR85-2505.v2025-09-09.q29; 165Adobe.AD0-E727.v2025-09-09.q76; 129Oracle.1Z0-1123-25.v2025-09-09.q20; 134SAP.C_SIGPM_2403.v2025-09-08.q20; 253EXIN.ITIL.v2025-09-08.q161; 169BCS.PC-BA-FBA-20.v2025-09-08.q45

1Z0-144 Exam Question 41

1Z0-144 Exam Question 42

1Z0-144 Exam Question 43

1Z0-144 Exam Question 44

1Z0-144 Exam Question 45

Download PDF File