BCA-09/DCA-103
December Examination 2017
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 word. Each question carries 2 marks.
Define the aim of relational model.
What do you understand by Database management system?
Define the role of database administrator.
What do you understand by data independence?
State the operations of relational algebra.
What is database integrity?
What do you understand by concurrency in DBMS?
491
BCA-09/DCA-103 200 3 (P.T.O.)
BCA-09/DCA-103 200 3 (Contd.)
491
(viii) What is the shared locks?
State the different data types in SQL.
What do you understand by data warehouse?
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.
SQL is called as non-procedural language. Explain.
Explain different type of integrity constraints with example.
What is Normalization? Discuss its need.
Explain the use of join in RDBMS with the help of example.
Explain the growing phase of locking.
Explain the different set operations of SQL with the help of
suitable example.
What is serializability and how it works in concurrency?
Explain the different types of failures of databases with the
help of example.
BCA-09/DCA-103 200 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 is Explain various types of join with suitable
example.
11) Explain the following terms using an example:
entity-relationship model,
entity type,
weak entity,
attribute,
key attribute,
derived attribute,
Multi-valued attribute.
12) Explain E-R model and relational model; and compare it.
13) What is concurrency control? How timestamp ordering
ensure concurrency control?