USN B24BCA304

RAJARAJESWARI COLLEGE OF ENGINEERING

Third Semester BCA Examinations

B24BCA304 - RELATIONAL DATA BASE MANAGEMENT SYSTEM

TIME: 03HOURS [Link]

Note:
1. Answer all the questions in Part A.
2. Answer any FIVE full questions, choosing at least ONE question from each MODULE in Part
B.
3. M: Marks, L: Bloom’s Taxonomy Level.
Instructions to Candidates: (Shall include instructions regarding issue of hand books / charts / tables etc)

PART A
Q No. QUESTIONS M L
1.1 A __________ is a collection of interrelated data and a set of programs 1 L1
to access that data.

1.2 In a Relational Database, data is organized in the form of __________ 2 L1

1.3 The process of designing the logical structure of a database is known 1 L1

1.4 A transaction must satisfy four properties called ACID, which stands for 1 L1
Atomicity, Consistency, Isolation, and ________.
1.5 A good database design eliminates __________ and ensures data 1 L1
consistency
1.6 A relation is in 2NF if it is in 1NF and has no __________ dependency. 2 L1
1.7 A database buffer is a portion of __________ memory used to 1 L1
temporarily store data blocks read from disk.

1.8 DDL stands for __________, which is used to define the structure of a database. 1 L1
1.9 The SQL command used to remove all records from a table but keep 1 L1
its structure is __________.

1.10 The SQL command used to change the structure of an existing table is _____. 1 L1
1.11 The SQL command used to remove a view from the database is 2
__________. L1

1.12 A PL/SQL block consists of three sections: the __________ section, the 2 L1
__________ section, and the exception section.
1.13 Bind variables are prefixed with a __________ symbol, while substitution 2 L1
variables are prefixed with a __________ symbol.

1
 B24BCA205

1.14 A cursor is used to retrieve __________ from a table and process them _______. 2 L1

PART B
(Shall be two or three full questions from each module carries 16 marks each
Q No. QUESTIONS M CO L
MODULE-1
2. a. Analyze the purpose of database systems. Discuss how database systems differ from 6 1 L4
2 a traditional file systems and the advantages of using a DBMS.
b. Describe the three-level architecture (view of data) in a database system and 8 1 L1
b explain the roles of the internal, conceptual, and external levels.
c. What are database languages? Explain in detail the functions of DDL, DML, 2 1 L1
DCL, and TCL in a database management system.
OR
3. a. Discuss the different types of keys used in a relational database with suitable 8 1 L6
3 a examples.
b. Explain the roles and responsibilities of different types of database users and 8 1 L2
b administrators in a DBMS environment.
MODULE-2
4. a. Explain the features of a good relational database design. Discuss how 8 2 L2
3 a redundancy, consistency, and data independence are managed in a well-
designed database.
b. What is normalization? Explain 2NF and 3NF in detail with suitable examples. How 8 2 L1
b do they help in removing partial and transitive dependencies?
OR
5. a. Discuss the Boyce–Codd Normal Form (BCNF) and how it differs from Third 8 2 L4
3 a Normal Form (3NF). Provide an example of a relation that satisfies 3NF but
not BCNF.
b. Explain how records are organized in a file. Differentiate between fixed- 8 2 L2
b length and variable-length record organization. What are the advantages of
each?
MODULE-3
6. a. Explain the concept of a database transaction. Describe the importance of 8 3 L2
2 a transactions in maintaining database consistency with suitable examples.
b. Describe the states of a transaction in a simple transaction model. 8 3 L4

OR
7. a. List and explain the different data types supported by SQL (such as CHAR, 8 3 L1
2 a VARCHAR, NUMBER, DATE). Provide suitable examples for each.
b. Explain the SQL commands used to modify and manage tables — 8 3 L2
ALTER TABLE, DROP TABLE, RENAME TABLE, and TRUNCATE
TABLE — with suitable syntax and examples.
MODULE-4
8. a. What is a JOIN in SQL? Explain the following types of joins with syntax and 8 4 L1
2 a suitable examples.
b. Explain how the WHERE clause helps in filtering [Link] SQL examples 8 4 L2
b using comparison, BETWEEN, IN, and LIKE operators.
OR
2
 B24BCA205

9. a. Explain the different Data Manipulation Language (DML) operations in SQL. 8 4 L2

MODULE-5
10. a. Explain the structure of a PL/SQL block with an example. 4 5 L2
2 a
b. List and explain the different data types available in PL/SQL. 4 5 L1
b
c. Explain the different control structures available in PL/SQL. Describe the 8 5 L2
syntax and use of IF–THEN–ELSE, CASE, and LOOP constructs with
examples
OR
11. a. What are exceptions in PL/SQL?Discuss types of exceptions (predefined and 8 5 L1
2 a user-defined) and demonstrate how to handle them using the EXCEPTION
block.
b. Write short notes on the following: 8 5 L1
b a) Procedures – creation and execution syntax
b) Functions – difference from procedures
c) Triggers – purpose and example of BEFORE and AFTER triggers

Subject Coordinator HOD Dean-Academics Principal