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

View the exhibit and examine the structure of the products table.

Examine the following code

Which statement is true when the procedure DELETE_DETAILS is invoked?

• A.It gives an error because PRAGMA AUTONOMOUS_TRANSACTION can be used only in packaged procedures.
• B.It executes successfully and any error messages get recorded in the DEBUG_OUTPUT table.
• C.It gives an error because procedures containing PRAGMA AUTONOMOUS_TRANSACTION cannot be called from the exception section.
• D.It executes successfully but no error messages get recorded in the DEBUG_OUTPUT table

Which two statements are true about the usage of the cursor for loops? (Choose two.)

• A.The cursor needs to be closed after the iteration is complete.
• B.The record type must be explicitly declared to control the loop.
• C.The PL/SQL creates a record variable with the fields corresponding to the columns of the cursor result set.
• D.The implicit open, fetch, exit, and close of the cursor happen.

Examine the following PL/SQL code:

Which statement is true about the execution of the PL/SQL code?

• A.It does not execute because of syntax error
• B.It executes successfully and generates a warning.
• C.It generates a run-time exception.
• D.It executes successfully.

Examine the following PL/SQL code:

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

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

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

You create the following trigger to ensure that customers belonging to category "A" or "B" in the customer table can have a credit limit of more than 8000.

What is the outcome?

• A.The trigger is fired, a message is displayed, and the update is successful
• B.The trigger is fired and a message is displayed, but the update is rolled back.
• C.The trigger is not fired because the when clause should be used to specify the condition, however, the update is successful.
• D.The trigger is not fired because column names must be specified with the update event to identify which columns must be changed to cause the trigger to fire, however, the update is successful.