1z0-144: Oracle Database 11g Program with PLSQL Examine Practice Questions

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

• AA. Each fetch retrieves the first row and assigns values to the target variables.
• BB. Each fetch retrieves the next consecutive row and assigns values to the target variables.
• CC. They produce an error because you must close and reopen the cursor before each fetch statement.
• DD. Only the first fetch retrieves the first row and assigns values to the target variables; the second produces an error.

View the Exhibit and examine the code. Why does the code give an error on execution?

• AA. because the WORD_LIST variable is not visible in procedure wording
• BB. because the lexicon variable is not visible in procedure ADD_ENTRY
• CC. because the lexicon variable is not initialized in procedure wording
• DD. because the WORD_LIST parameter in out mode cannot be of a record data type

View the Exhibit to examine the PL/SQL code. The record for the employee with employee_id 100 in the employees table is as follows: Identify the correct output for the code.

• AA. King 17-JUN-87 1500
• BB. King 17-JUN-87 24000
• CC. King current sysdate 1500
• DD. King current sysdate 24000

/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 DIRECTORY my_dir AS ‘/temp/my_files’; SQL>GRANT READ ON DIRECTORY my_dir TO public; 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?

• AA. It goes into an infinite loop.
• BB. It executes successfully and displays only the list of faculty names.
• CC. It does not execute and displays an error message because the end-of-file condition is not taken care of.
• DD. It executes successfully and displays the list of faculty names followed by a "no data found" error message.

View the exhibit to examine the PL/SQL code. Which statement is true about the exception handlers in the PL/SQL code?

• AA. All the exceptions in the code are trapped by the exception handler.
• BB. All the "no data found" errors in the code are trapped by the exception handler.
• CC. The PL/SQL program does not execute because an exception is not declared in the declare section.
• DD. An exception handler in the code traps the "no data found" error after executing the handler code and the program flow returns to the next line of code.

Examine the following PL/SQL code: The server output is on for the session. Which statement is true about the execution of the code?

• AA. The code executes successfully and gives the desired output.
• BB. The code generates an error because the EMP_RECORD variable is not declared.
• CC. The code generates an error because the cursor is not opened before the FOR loop.
• DD. The code generates an error because the loop does not have the exit when clause.

Examine the following PL/SQL code; The execution of the code produces errors. Identify the error in the code.

• AA. The open cursor is missing
• BB. The fetch clause is missing
• CC. The exit when condition is missing
• DD. The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement