databases Online Quiz - 8
|Description: databases Online Quiz - 8|
|Number of Questions: 20|
|Created by: Aliensbrain Bot|
Which exception handler must appear LAST in the exception block?
An application developer needs to write a PL/SQL code, wherein salary raise to be processed for all the employees of grade "C2" and above. As per the Oracle recommended standards, Which PL/SQL objects should be part of his application code? Choose all that apply
As per the business requirement of a Shipping firm, Inventory Manager should be notified when the Inventory Count for a category "CONTAINER" in the INVENTORY table drops down below 100. However, the user transaction should NOT be aborted, in case the inventory count for a "CONTAINERS" category drops down below 100. The columns of the INVENTORY table, which stores the category name and count are CAT_NAME and TOTAL_COUNT respectively. Specify, which type of TRIGGER an application developer needs to write to address this issue?
What is true about exception propagation?
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
Stored Procedures and stored function are the same, except
What is meant by cascading in the context of the database triggers?
A stored procedure must have at least one argument
To answer this question, we need to understand what a stored procedure is and its characteristics.
A stored procedure is a set of SQL statements that are stored in the database and can be executed repeatedly. It is typically used to perform a specific task or a series of tasks.
A stored procedure can have zero or more arguments. Arguments are parameters that are passed to the stored procedure when it is called. These arguments can be used within the stored procedure to perform various operations.
Based on this understanding, we can determine that the statement "A stored procedure must have at least one argument" is incorrect.
Option A) True - This option is incorrect because a stored procedure can have zero or more arguments.
Option B) False - This option is correct because a stored procedure can have zero or more arguments.
The correct answer is B) False.
What is the default mode for arguments in stored procedure?
Primary difference between a stored procedure and stored function is that, function must return a value through an explicit return statement wherein stored procedure does NOT.
DDL statements are allowed in the database triggers
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?
RAISE_APPLICATION_ERROR procedure can be used ONLY in database triggers to handle user defined exceptions
A database TRIGGER is made up of ... Choose all that apply
A database TRIGGER in DISABLED state won't execute the TRIGGER ACTION
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?
Identify 3 parent partitioning schemes.
An application architect is considering to redesign ORDERS table of an ORDER ENTRY application using partitioning. He's NOT very sure about the usage of ORDERS table from end user perspective. However, he wants to distribute the data equally across all table partitions. Which partitioning scheme is his obvious choice?
Which of the following is not a string function?