databases Online Quiz - 8 Online Test

0

databases Online Quiz - 8

Description: databases Online Quiz - 8
Number of Questions: 20
Created by: Aliensbrain Bot
Tags: databases

Which exception handler must appear LAST in the exception block?

technology databases

User Defined Exception
Predefined Internal Exception --- NO_DATA_FOUND
Predefined Internal Exception --- VALUE_ERROR
OTHERS Exception

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

technology databases

Package
Stored Procedure
Cursor
Stored Function
View
Trigger

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?

technology databases

Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - BEFORE ROW, Trigger Restriction - NULL
Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - BEFORE ROW, Trigger Restriction - WHERE CAT_NAME='CONTAINER' AND NEW.TOTAL_COUNT<100
Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - BEFORE STATEMENT, Trigger Restriction - NULL
Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - BEFORE STATEMENT, Trigger Restriction - WHERE CAT_NAME='CONTAINER' AND NEW.TOTAL_COUNT<100
Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - AFTER ROW, Trigger Restriction - NULL
Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - AFTER ROW, Trigger Restriction - WHERE CAT_NAME='CONTAINER' AND NEW.TOTAL_COUNT<100

What is true about exception propagation?

technology databases

The current block is always searched first for a handler
If the exception handler is NOT found in the current block, enclosing block if any is searched for the exception handler.
If the exception handler is found, then it's executed. Control is passed to the enclosing block if one exists OR to the calling environment if there is no enclosing block.
If the exception handler is NOT found, then exception is returned back to the calling environment
All of above

Identify the BOOLEAN variables in the context of the TRIGGER. Choose all that apply.

technology databases

UPDATING
CREATING
DELETING
SELECTING
INSERTING
ALTERING

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

technology databases

True
False

Stored Procedures and stored function are the same, except

technology databases

Stored function returns a value and a stored procedure does not.
Stored procedure returns a value and a stored function does not.
Stored function returns a value and a stored procedure may OR may not.
Stored procedure returns a value and a stored function may OR may not.

What is meant by cascading in the context of the database triggers?

technology databases

When a trigger fires, a SQL statement within its trigger action potentially can fire other triggers
When a trigger fires, a SQL statement within its trigger action potentially can update other tables
When a trigger fires, a SQL statement within its trigger action potentially can fire other stored procedures
When a trigger fires, a SQL statement within its trigger action potentially can drop other tables

A stored procedure must have at least one argument

technology databases

True
False

What is the default mode for arguments in stored procedure?

technology databases

IN
OUT
IN OUT
OUT IN

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.

technology databases

True
False

DDL statements are allowed in the database triggers

technology databases

True
False

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?

technology databases

Execute the command FIX ERROR
Execute the command SHOW ERROR
Execute the command TROUBLESHOOT ERROR
Execute the command INVESTIGATE ERROR
Execute the command ANALYZE ERROR

RAISE_APPLICATION_ERROR procedure can be used ONLY in database triggers to handle user defined exceptions

technology databases

True
False

A database TRIGGER is made up of ... Choose all that apply

technology databases

TRIGGER SPECIFICATION
TRIGGER EVENT
TRIGGER TYPE
TRIGGER BODY
TRIGGER RESTRICTION
TRIGGER ACTION

A database TRIGGER in DISABLED state won't execute the TRIGGER ACTION

technology databases

True
False

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?

technology databases

Database Trigger will NOT fire at all as number of records updated are ZERO. However, batch job will run through successfully.
Database Trigger will fire only ONCE and will save details viz. "ERIC", "SYSDATE" and "0" to the AUDIT table. The batch job will run through successfully.
Database Trigger will return an ERROR and abort the batch job
Database Trigger will return an ERROR. However, batch job will run through successfully

Identify 3 parent partitioning schemes.

technology databases

RANGE
INTERVAL
LIST
HASH
VIRTUAL
REFERENCE

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?

technology databases

RANGE
HASH
LIST
INTERVAL

Which of the following is not a string function?

technology databases

concat
initcap
round
length

- Hide questions