databases Online Quiz - 8
Description: databases Online Quiz - 8 | |
Number of Questions: 20 | |
Created by: Aliensbrain Bot | |
Tags: databases |
Identify the BOOLEAN variables in the context of the TRIGGER. Choose all that apply.
SQLCODE and SQLERRM cannot be used within a SQL statement directly. Instead, you must assign their values to local variables, then use the variables in the SQL statement
An application developer has written a database package for an Order Entry application using SQL Plus editor. While compiling the package, he receives errors. What will be the next step to troubleshoot the error?
A database TRIGGER is made up of ... Choose all that apply
An application developer has written an AFTER STATEMENT trigger for UPDATE event on the ORDERS table of ORDER ENTRY application. The trigger saves the details of the user performing the update, system date, number of records updated to the AUDIT table. User, ERIC accesses ORDER ENTRY application and submits an UPDATE on ORDERS table through a batch job. However, the update statement affects ZERO records from ORDERS table. What is true in the context of the database trigger being written?