Databases | Practice Questions | Aliensbrain

Multiple choice technology databases

What is the default mode for arguments in stored procedure?

IN
OUT
IN OUT
OUT IN

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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.

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

DDL statements are allowed in the database triggers

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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

True
False

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

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

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

Identify 3 parent partitioning schemes.

RANGE
INTERVAL
LIST
HASH
VIRTUAL
REFERENCE

Reveal answer Fill a bubble to check yourself

Multiple choice technology databases

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?

RANGE
HASH
LIST
INTERVAL

Reveal answer Fill a bubble to check yourself

Tag: databases

Questions Related to databases