Online Access Free 1Z0-144 Practice Test

Which statements are true about database triggers? (Choose all that apply.)

• A.They can include SQL and PL/SQL or calls to Java procedures.
• B.They can invoke only PL/SQL procedures
• C.They are implicitly fired by an event that must occur within an application
• D.They are implicitly fired when a triggering event occurs, depending on which user is connected

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.

You create the following table and execute the following code:

Which statement is true about the outcome of the above code?

• A.It gives an error but saves the inserted rows; however, no rows are updated.
• B.It gives an error and all the data manipulation language (DML) statements are rolled back
• C.It gives an error but saves the inserted rows and the update to the first row.
• D.It executes successfully and all the rows are updated.

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.The PL/SQL wrapper detects and reports only syntax errors.
• E.To change a wrapped object, the original source code needs to be modified and then wrapped again
• F.The PL/SQL wrapper detects and reports both syntax and semantic errors.

Which two tasks should be created as functions instead of as procedures? (Choose two.)

• A.Reference host or bind variables in a PL7SQL block of code
• B.Tasks that compute a value that must be returned to the calling environment
• C.Tasks that compute and return multiple values to the calling environment
• D.Tasks performed in SQL that increase data independence by processing complex data analysis within the Oracle server, rather than by retrieving the data into an application