Free Oracle 1Z0-144 Exam Dumps Questions & Answers

Which two statements are true about database triggers? (Choose two.)

• A.Both data manipulation language (DML) and data definition language (DDL) statements can cascade up to 32 triggers
• B.Both DML and DDL statements can cascade any number of triggers,
• C.Each trigger can be of any size.
• D.Each trigger can be of a maximum size of 32 K
• E.A trigger can contain a maximum of 32 lines of code.
• F.Triggers fired by DML statements cannot cascade simultaneously.

Examine the following PL/SQL code:

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

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

View the Exhibit and examine the package code created by SCOTT. The execute privilege on this package is granted to green.

Examine the following sequence of commands issued by SCOTT:

What is the outcome?

• A.SCOTT'S session displays 5, and then 5 again, green's session displays 0.
• B.SCOTT'S session displays 5, and then 5 again; green's session displays 5.
• C.SCOTT'S session displays 5, and then 0; green's session displays 5.
• D.SCOTT'S session displays 5, and then 0, greets session displays 0.

View the Exhibit and examine the code:

Which statement is true about the COMPILE_CODE procedure?

• A.It gives an error in line 6.
• B.It executes successfully, but displays a warning about the unreachable code when used for the PROC1 procedure.
• C.It gives an error in line 5.
• D.It executes successfully, but a warning about the unreachable code is not displayed when used for the PROC1 procedure.
• E.It gives an error in line 8.

View the exhibit and examine the structure of the EMPLOYEES table

The salary of EMPLOYEE_ID 195 is 2800. You execute the following code

What is the outcome?

• A.It executes successfully and displays the resultant values in the following sequence1000, 2800 50000, 2800.
• B.It executes successfully and displays the resultant values in the following sequence: 1000, 2800, 50000, 1000.
• C.It gives an error because the same variable name cannot be used across all the nested blocks.
• D.It gives an error because only the innermost block is labeled.