Database Management System, Question Paper of BCA (D) 4th Semester, Download Previous Years Question Paper 2

Roll no ……..
Total No. of Questions : 13]

PAPER ID A0217

BCA (Semester -4th)

DATABASE MANAGEMENT SYSTEM

BCA-402

Time :3 Hours

Instruction to Candidates:

1.     Section – A is compulsory.

2.     Attempt any Nine questions from section- B

Section –A

Q1)

a) What is difference between data and information?

b) What are data views?

c) What do you mean by data redundancy?

d) What is data independence?

e) What are single-valued and multivalued attributes?

f) What is a binary relationship set?

g) What is a tuple variable?

h) What is a query language?

i) What do you mean by database schema?

j) Define the term data manipulation language.

k) What are stored procedures?

1) What do you mean by the term deadlock?

m) What are graphical user interfaces?

n) What do understand by a distributed database?

o) What is data replication?

Section - B

Q2) Describe major advantages and disadvantages of a database system.

Q3) Explain the difference between physical and logical data independence.

Q4) List major steps that you would take in setting up a database for a particular

enterprise.

Q5) Define the concept of aggregation. Give two examples of where this concept

is useful.

Q6) Explain the distinctions among the terms primary key, candidate key and super key.

Q7) Explain the difference between a weak and a strong entity.

Q8) Describe the differences in meaning between the terms relation and relation

schema with the help of suitable examples.

Q9) Discuss the basic operations that can performed using relational algebra.

Q10) Discuss various set operations that can be performed in SQL.

Q11) Draw an ER diagram for a hospital management system, make suitable

assumptions.

Q12) Discuss the advantages of distributed databases.

Q13) Compare the shadow-paging recovery scheme with log-based recovery

schemes.