BCA-09 DCA-103
June Examination 2016
BCA Pt. II DCA Examination
Database Management System
Paper BCA-09 DCA-103
Time 3 Hours Max. Marks 100
Note: The question paper is divided into three sections B and C. Write answers as per given instructions.
Section A 10 × 2 20
(Very Short Answer Questions)
Note: Answer all questions. As per the nature of the question delimit your answer in one word, one sentence or maximum upto 30 words. Each question carries 2 marks.
What is the full form of RDBMS?
What do you mean by strong entity?
Define schema.
What is null artribute?
Who are end users?
Name some popular RDBMS packages.
What is the use of check pointing?
(viii) What is the full form of OLAP?
491
BCA-09 DCA-103 100 3 (P.T.O.)
BCA-09 DCA-103 100 3 (Contd.)
491
What do you mean by functional dependency?
What do you mean by degree of a relationship type?
Give example.
Section B 4 × 10 40
(Short Answer Questions)
Note: Answer any four questions. Each answer should not
exceed 200 words. Each question carries 10 marks.
Give the defination of serializable schedule. Discuss
serializability algorithm with example.
What are the role of Data Warehouse? Give the difference
between Database and Data Warehouse.
What is key? Discuss the concepts of primary key with
example.
Compare generalization and specialization.
What do you mean by constraints? Discuss various types of
constraints.
Explain the concept of DDL and DML commands in DBMS.
Write short note on triggers.
Why SQL is called non-procedural language? Explain with
suitable example.
BCA-09 DCA-103 100 3
491
Section C 2 × 20 40
(Long Answer Questions)
Note: Answer any two questions. You have to delimit your each
answer maximum upto 500 words. Each question carries
20 marks.
10) What are the requirement of join operation? Discuss various
types of join operations with example.
11) What is the need of normalization? Explain 1NF, 2NF and
3NF with example.
12) Consider the following tables:
Employee Name, Emp_city)
Company Company_name, Salary)
Write the following queries in SQL
Write a query to display employee name, employee city,
company name.
Write a query to display emp_name, employee city;
company name and salary of the employee whose
salary 10000
Write a query to display all the employees working in
company.
13) Explain why we study the data models in database. Also
differentiate between E-R model and Relational model.