Online Access Free 1Z1-144 Practice Test

Consider the following scenario:
Local procedure a calls remote procedure B
Procedure A was compiled at 8 AM.
Procedure A was modified and recompiled at 9 AM.
Remote procedure B was later modified and recompiled at 11 AM.
The dependency mode is set to timestamp.
Which statement correctly describes what happens when procedure A is invoked at 1 PM?

• A.There is no effect on procedure A and it runs successfully.
• B.Procedure A is invalidated and recompiles when invoked the next time.
• C.Procedure B is invalidated and recompiled again when invoked.
• D.Procedure A is invalidated and recompiled immediately.

View the Exhibit and examine the structure of the SALGRADE table. Examine the following code:


What is the outcome?

• A.It is created successfully.
• B.It gives an error because the return clause condition is invalid.
• C.It gives an error because the usage of the host variables is invalid.
• D.It gives an error because the data type of the return clause is invalid.

Examine the following PL/SQL code:

The server output is on for the session. Which statement is true about the execution of the code?

• A.The code generates an error because the cursor is not opened before the FOR loop.
• B.The code generates an error because the loop does not have the exit when clause.
• C.The code generates an error because the EMP_RECORD variable is not declared.
• D.The code executes successfully and gives the desired output.

Examine the following block of code:

Which line in the above code would result in errors upon execution?

• A.line 7
• B.line 2
• C.line 8
• D.line 5

Which statements correctly describe the features of functions and procedures? (Choose all that apply.)

• A.A procedure can contain a return statement without a value.
• B.A function can contain zero or more parameters that are transferred from the calling environment.
• C.A function can return multiple values using a single return clause,
• D.A procedure can be executed as part of a SQL expression or as a PL/SQL statement,