Free Oracle 1Z1-144 Exam Dumps Questions & Answers

Examine the following PL/SQL code:

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

• A.  Only the first fetch retrieves the first row and assigns values to the target variables- the second produces an error.
• B.  Each fetch retrieves the first row and assigns values to the target variables.
• C.  They produce an error because you must close and reopen the cursor before each fetch -statement.
• D.  Each fetch retrieves the next consecutive row and assigns values to the target variables.

Which two statements are true about anonymous blocks and named subprograms?
(Choose two)

• A.  Subprograms are by default executed with definer's rights.
• B.  The declare section is mandatory for anonymous blocks and optional for subprograms.
• C.  Both anonymous blocks and subprograms execute by default with invoker's rights.
• D.  The declare section is optional for both anonymous blocks and subprograms.

Examine the following PL/SQL code;

The execution of the code produces errors. Identify the error in the code.

• A.  The fetch clause is missing
• B.  The EMP_NAME and EMP_JOB variables cannot be used in the for clause of the cursor FOR statement.
• C.  The open cursor is missing
• D.  The exit when condition is missing

Examine the following block of code:

Which two statements are correct about the code above? (Choose two.)

• A.  The function goes through only the parse and executes phases.
• B.  Only the EXECUTE IMMEDIATE statement inside the function is parsed at run time.
• C.  The function goes through the parse, bind, execute, and fetch phases.
• D.  All the processing phases for the function are performed only at run time.
• E.  The function goes through the parse, bind, and execute phases.

View the Exhibit and examine the structure of the EMP table.

Which stages are performed when the above block is executed? (Choose all that apply)

• A.  Fetch
• B.  Execute
• C.  Bind
• D.  Parse