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 query

A precompiled set of SQL statements stored in the database

A temporary table

An index on a table

Question 2: RDBMS - Function Definition

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

Functions cannot return a value

Functions always return a single value and can be used in SQL expressions

Functions can only create tables

Functions are not stored in the database

Question 3: RDBMS - Trigger Definition

What is a trigger in RDBMS?

A query executed manually

A set of SQL statements automatically executed in response to certain events

A stored procedure without parameters

A 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 traffic

Increase storage usage

Replace indexes

Make database slower

Question 5: RDBMS - Advantages of Functions

Why are functions useful in RDBMS?

They cannot be reused

They simplify complex calculations and can be embedded in queries

They store data permanently

They replace triggers

Question 6: RDBMS - Types of Triggers

Which are common types of triggers in RDBMS?

BEFORE, AFTER, INSTEAD OF

SINGLE, DOUBLE, MULTI

STATIC, DYNAMIC

PRIMARY, 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 INSERT

AFTER DELETE

INSTEAD OF UPDATE

BEFORE SELECT

Question 8: RDBMS - Difference Between Procedure and Trigger

Which statement is true?

Procedures run automatically on events, triggers are executed manually

Triggers run automatically on events, procedures are executed manually

Both triggers and procedures are always automatic

Both cannot accept parameters

Question 9: RDBMS - Parameterized Stored Procedures

Why are parameters used in stored procedures?

To make the procedure slower

To allow dynamic input values and reuse the procedure

To create indexes automatically

To 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 integrity

By storing extra data physically

By eliminating the need for transactions

By replacing backups