1Z1-144 무료 덤프문제 온라인 액세스

Examine the following PL/SQL code:

Which statement is true about the execution of the code if the query in the PL/SQL block returns no rows?

• A.The program executes successfully and the output is No ROWS_FOUND.
• B.The program executes successfully and the query fetches a null value in the V_LNAME variable.
• C.The program abruptly terminates and an exception is raised.
• D.Program executes successfully, fetches a NULL value in the V_LNAME variable and an
  exception is raised.

View Exhibit1 and examine the structure of the employees table.

View Exhibit2 and examine the code.

What would be the outcome when the code is executed?

• A.It gives an error because the SAL variable is not visible in the increase function.
• B.It gives an error because the increase function cannot be called from the RAISE_SALARY procedure.
• C.It executes successfully.
• D.It gives an error because the increase function and the RAISE_SALARY procedure should be declared at the beginning of the declare section before all the other declarations.

View Exhibit 1 and examine the structure of the EMP and dept tables.

View Exhibit2 and examine the trigger code that is defined on the dept table to enforce the update and delete restrict referential actions on the primary key of the dept table.

What is the outcome on compilation?

• A.It gives an error on compilation because it is not a row-level trigger.
• B.It compiles and executes successfully.
• C.It gives an error on compilation because the exception section Is used in the trigger.
• D.It compiles successfully but gives an error on execution because it is not a row-level trigger.

Which three statements are true about wrapping? (Choose three.)

• A.When wrapping a package or object type, both the body and specification should be wrapped.
• B.When wrapping a package or object type, only the body should be wrapped, not the specification.
• C.To change a wrapped object, the wrapped code can be unwrapped, modified In a text file, and then wrapped again.
• D.To change a wrapped object, the original source code needs to be modified and then wrapped again
• E.The PL/SQL wrapper detects and reports only syntax errors.
• F.The PL/SQL wrapper detects and reports both syntax and semantic errors.

Which system events can be used to create triggers that fire both at database and schema levels? (Choose all that apply)

• A.AFTER STARTUP
• B.AFTER SERVERERROR
• C.AFTER LOGON
• D.BEFORE SHUTDOWN