All Questions

Stored Procedures, Functions, and Triggers – Automation in databases.

MCQ Question 1 of 10

Question 1: RDBMS - Stored Procedure Definition

What is a stored procedure in RDBMS?

A single SQL queryA precompiled set of SQL statements stored in the databaseA temporary tableAn index on a table

Question 2: RDBMS - Function Definition

How does a function differ from a stored procedure in RDBMS?

Functions cannot return a valueFunctions always return a single value and can be used in SQL expressionsFunctions can only create tablesFunctions are not stored in the database

Question 3: RDBMS - Trigger Definition

What is a trigger in RDBMS?

A query executed manuallyA set of SQL statements automatically executed in response to certain eventsA stored procedure without parametersA type of index

Question 4: RDBMS - Advantages of Stored Procedures

Which of the following is an advantage of using stored procedures?

Improve performance and reduce network trafficIncrease storage usageReplace indexesMake database slower

Question 5: RDBMS - Advantages of Functions

Why are functions useful in RDBMS?

They cannot be reusedThey simplify complex calculations and can be embedded in queriesThey store data permanentlyThey replace triggers

Question 6: RDBMS - Types of Triggers

Which are common types of triggers in RDBMS?

BEFORE, AFTER, INSTEAD OFSINGLE, DOUBLE, MULTISTATIC, DYNAMICPRIMARY, FOREIGN

Question 7: RDBMS - Trigger Example

A trigger is created to log changes whenever a row is deleted from a table. This type of trigger is an example of:

BEFORE INSERTAFTER DELETEINSTEAD OF UPDATEBEFORE SELECT

Question 8: RDBMS - Difference Between Procedure and Trigger

Which statement is true?

Procedures run automatically on events, triggers are executed manuallyTriggers run automatically on events, procedures are executed manuallyBoth triggers and procedures are always automaticBoth cannot accept parameters

Question 9: RDBMS - Parameterized Stored Procedures

Why are parameters used in stored procedures?

To make the procedure slowerTo allow dynamic input values and reuse the procedureTo create indexes automaticallyTo replace triggers

Question 10: RDBMS - Automation Benefits

How do stored procedures, functions, and triggers help in database automation?

By enforcing rules, simplifying repetitive tasks, and maintaining data integrityBy storing extra data physicallyBy eliminating the need for transactionsBy replacing backups