Scribd
Upload
44 views1 page

DBMS Paper

The document outlines the structure of the Mid Term Exam for BCA 2nd Semester in 2025 for the subject DBMS, consisting of three sections with varying question formats. Section A requires students to answer 5 questions related to distributed systems, functional dependency, DBMS advantages, SQL features, data models, and database administrator powers. Sections B and C focus on constraints, database abstraction, normalization forms, and SQL command writing tasks.

Uploaded by

Sandeep Awasthi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
44 views1 page

DBMS Paper

The document outlines the structure of the Mid Term Exam for BCA 2nd Semester in 2025 for the subject DBMS, consisting of three sections with varying question formats. Section A requires students to answer 5 questions related to distributed systems, functional dependency, DBMS advantages, SQL features, data models, and database administrator powers. Sections B and C focus on constraints, database abstraction, normalization forms, and SQL command writing tasks.

Uploaded by

Sandeep Awasthi
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 1

Mid Term Exam 2025

Class : BCA - 2nd Sem ( 2025 )


Sub: DBMS
M.M: 30 TIME : 2 hrs
Section -A
Attempt only 5 questions.
2 each
Q.1 What is Distributed System? Write its pros and cons.
Q.2 What is functional dependency. Write down the inference rule.
Q.3 What are the advantages of DBMS over file system.
Q.4 What is SQL and its features.
Q.5 What are the data models. Explain Relational model with comparison with other models.
Q.6 Write down the powers of database administrator.
Section -B
Attempt only 2 questions. 5 each
Q.1 Explain types of constraints with example
Q.2 Explain database abstraction.
Q.3 Explain 1 NF, 2NF with example.

Section- C 10
Q.1 Write down the commands
EMP (empno n (5),ename c (20),sal n (5), doj date, deptno n (5))
Dept (deptno n (5), dname c (20))
(i) Write a command to create structure of both table and set referential integrity in them.
(ii) Write a command to input values (1, ‘Ram’,20000)
(iii) Write a command to remove all the record permanently.
(iv) Display that record who is getting lowest salary.
(v) Display ename,sal, dname of sales department.
(vi) Display deptno,total salary, no. of employees of each department.

Mid Term Exam 2025


Class : BCA - 2nd Sem ( 2025 )
Sub: DBMS
M.M: 30 TIME : 2 hrs
Section -A
Attempt only 5 questions.
2 each
Q.1 What is Distributed System? Write its pros and cons.
Q.2 What is functional dependency. Write down the inference rule .
Q.3 What are the advantages of DBMS over file system.
Q.4 What is SQL and its features.
Q.5 What are the data models. Explain Relational model with comparison with other models.
Q.6 Write down the powers of database administrator.
Section -B
Attempt only 2 questions. 5 each
Q.1 Explain types of constraints with example
Q.2 Explain database abstraction.
Q.3 Explain 1 NF, 2NF with example.
Section- C 10
Q.1 Write down the commands
EMP (empno n(5),ename c(20),sal n(5), doj date, deptno n(5))
Dept(deptno n(5),dname c(20))
I. Write a command to create structure of both table and set referential integrity in them.
II. Write a command to input values ( 1, ‘Ram’,20000)
III. Write a command to remove all the record permanently.
IV. Display that record who is getting lowest salary.
V. Display ename,sal, dname of sales department.
VI. Display deptno,total salary, no. of employees of each department.

You might also like