Tag: databases

Questions Related to databases

OTHERS is super set of all predefined internal exceptions
technology databases

  1. True

  2. False

Show answer
Correct Option: A

Which exception handler must appear LAST in the exception block?

technology databases

  1. User Defined Exception

  2. Predefined Internal Exception --- NO_DATA_FOUND

  3. Predefined Internal Exception --- VALUE_ERROR

  4. OTHERS Exception

Show answer
Correct Option: D

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

  1. Package

  2. Stored Procedure

  3. Cursor

  4. Stored Function

  5. View

  6. Trigger

Show answer
Correct Option: A,B,C,E

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

  1. Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - BEFORE ROW, Trigger Restriction - NULL

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

  3. Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - BEFORE STATEMENT, Trigger Restriction - NULL

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

  5. Trigger Event - UPDATE of TOTAL_COUNT, Trigger Type - AFTER ROW, Trigger Restriction - NULL

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

Show answer
Correct Option: F

What is true about exception propagation?
technology databases

  1. The current block is always searched first for a handler

  2. If the exception handler is NOT found in the current block, enclosing block if any is searched for the exception handler.

  3. 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.

  4. If the exception handler is NOT found, then exception is returned back to the calling environment

  5. All of above

Show answer
Correct Option: E

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

  1. UPDATING

  2. CREATING

  3. DELETING

  4. SELECTING

  5. INSERTING

  6. ALTERING

Show answer
Correct Option: A,C,E

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

  1. True

  2. False

Show answer
Correct Option: A

Stored Procedures and stored function are the same, except
technology databases

  1. Stored function returns a value and a stored procedure does not.

  2. Stored procedure returns a value and a stored function does not.

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

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

Show answer
Correct Option: A

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

technology databases

  1. When a trigger fires, a SQL statement within its trigger action potentially can fire other triggers

  2. When a trigger fires, a SQL statement within its trigger action potentially can update other tables

  3. When a trigger fires, a SQL statement within its trigger action potentially can fire other stored procedures

  4. When a trigger fires, a SQL statement within its trigger action potentially can drop other tables

Show answer
Correct Option: A

A stored procedure must have at least one argument
technology databases

  1. True

  2. False

Show answer
Correct Option: B