2025 BCA 4th Semester RDBMS & Oracle Question Paper | Purnea University PDF

UniversityPURNEA UNIVERSITY

CourseBCA

SemesterIV

SubjectRelational Database Management System and Oracle

Year2025

CODE: 4 BCA 3

RollNo: _________________

PURNEA UNIVERSITY, PURNEA

B.C.A. (Semester - IV) Examination, June-2025

Subject: RELATIONAL DATABASE MANAGEMENT SYSTEM AND ORACLE

TIME: 3 HOURS

FULL MARKS: 70

SECTION A (Multiple Choice Questions)

Multiple Choice Questions:

i. Which SQL command removes a table?

(a) Delete Table

(b) Drop Table

(d) Truncate Table

ii. Permissions are granted using:

(a) Grant

(b) Revoke

(d) Allow

iii. Which join returns only matching rows?

(a) Inner Join

(b) Left Join

(d) Full Join

iv. A FOREIGN KEY constraint:

(a) Ensures uniqueness

(b) Links tables

(d) Validates data range

v. The SQL command to delete all rows but retain the table structure is:

(a) Drop Table

(b) Truncate Table

(d) Remove Table

vi. A UNIQUE constraint allows:

(a) One Null Value

(b) Multiple Null Values

(d) Only Duplicate values

vii. The GRANT statement is associated with:

(a) Data manipulation

(b) User privileges

(d) Transaction control

viii. Which join returns all rows from the left table and matched rows from the right?

(a) Inner Join

(b) Left Join

(d) Full Join

ix. The COMMIT command:

(a) Undoes transactions

(b) Saves transactions permanently

(d) Creates backup

x. Which command is used to revoke privileges?

(a) Remove

(b) Revoke

(d) Delete

xi. A CHECK constraint ensures:

(a) Uniqueness

(b) Referential integrity

(d) Default values

xii. The ALTER TABLE command can:

(a) Drop a database

(b) Modify column data types

(d) Grant privileges

xiii. Which of the following is a DDL command?

(a) Select

(b) Insert

(d) Update

xiv. Which command is used to add a new column to an existing table?

(a) Modify Table

(b) Alter Table

(d) Add Column

SECTION B (Short/Long Answer Type)

Explain the different types of keys used in relational database. Provide real-world examples for each type.

Discuss Oracle's transaction management features. Explain the ACID properties.

Explain the concept of normalization in relational databases. Explain 1NF, 2NF, 3NF, and BCNF with examples of how normalization reduces redundancy and improves data integrity.

Describe the structure of a PL/SQL block, including the DECLARE, BEGIN, EXCEPTION, and END sections. Provide a detailed example of a block that declares variables, uses a cursor to fetch data, and includes exception handling for common errors like NO_DATA_FOUND.

Compare and contrast procedures and functions in PL/SQL. Highlight their creation syntax, execution methods, and key differences (e.g., functions returning values vs. procedures using OUT parameters).

Write a PL/SQL procedure to update employee salaries.

Discuss implicit and explicit cursors in PL/SQL.

Explain BEFORE and AFTER triggers with syntax.

10.

How does the DBA ensure database security? Explain the use of GROUP BY and HAVING clauses in SQL.