BCA Semester 4 – Database Management System – Unit 7: Developing Stored Procedures, DML Triggers and Indexing (5Hrs.)

Question 1

Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.

Marks: 5

Year: 2020 Final TU FOHSS

1. Why Indexing is Essential in a Database Indexing is essential because it improves the speed and efficiency of data retrieval. Without indexes, the DBMS must scan the entire table (full table scan

Question 2

What is the advantage and Disadvantage of using stored procedure? How can you create and execute stored procedure?

Marks: 5

Year: 2020 Final TU FOHSS

1. Definition of Stored Procedure A Stored Procedure is a precompiled SQL program stored in the database that can be executed repeatedly to perform a specific task. Example: Calculating total salary o

Question 3

Define stored procedures and triggers. How they are applicable in database? Illustrate with examples, how can you create before and after triggers on INSERT query.

Marks: 10

Year: 2021 Final TU FOHSS

Unit: DBMS – Stored Procedures & Triggers --- 1. Stored Procedures Definition: A stored procedure is a set of SQL statements that are stored in the database and can be executed repeatedly by call

Question 4

Why indexing is essential in database? Differentiate dense index from sparse index with suitable example.

Marks: 5

Year: 2022 Final TU FOHSS

Unit: DBMS – Indexing --- 1. Why Indexing is Essential Definition: Indexing is a technique that improves the speed of data retrieval from a database table without scanning the entire table. Imp

Question 5

What is a stored procedure? How can it be used in a database? Explain with an example.

Marks: 5

Year: 2023 Final TU FOHSS

Unit: DBMS – Stored Procedures --- 1. Definition A Stored Procedure is a precompiled set of SQL statements stored in the database that can be executed repeatedly by calling it. - It allows modula