Tag: databases

Questions Related to databases

  1. User Defined Exception

  2. Predefined Internal Exception --- NO_DATA_FOUND

  3. Predefined Internal Exception --- VALUE_ERROR

  4. OTHERS Exception


Correct Option: D
  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


Correct Option: F
  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


Correct Option: E
  1. UPDATING

  2. CREATING

  3. DELETING

  4. SELECTING

  5. INSERTING

  6. ALTERING


Correct Option: A,C,E
  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.


Correct Option: A

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

  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


Correct Option: A

A stored procedure must have at least one argument

  1. True

  2. False


Correct Option: B

AI Explanation

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.