BCA 2nd YEAR DBMS Last & Previous Year Question
DATABASE MANAGEMENT SYSTEM
2016
Part-A 10 x 1 = 10
Q.1 What is a data base?
Q.2 What is a DBMS?
Q.3 What is client server model?
Q.4 Define normalization.
Q.5 What is logical data model?
Q.6 What is physical data model?
Q.7 What is an Entity set?
Q.8 What is DDL?
Q.9 What is DML?
Q.10 What is deadlock?
Part-B 5 x 2 = 10
Q.11 What do you understand by physical v/s logical data independence?
Q.12 Discuss the advantages of database approach.
Q.13 What is ER model?
Q.14 What is Relational Model?
Q.15 Define data base integrity and integrity constants.
Part-C 10 x 3 = 30
UNIT – I
Q.16 Discuss the responsibilities of a database administrator
OR
Q.16 Discuss the architecture of a DBMS. What are the key concerns in distributed databases?
UNIT – II
Q.17 What do you understand by an ER model? Discuss the key concepts of ER model and illustrate with an example of a student database.
OR
Q.17 Compare and contrast the Hierarchal, Network and Relational model.
UNIT – III
Q.18 Write short notes on any two of following: (a) Primary key (b) Foreign key (c) Candidate key (d) Database security (e) Sorting of data in Foxpro
MORE OF DBMS: -
BCA - DATABASE MANAGEMENT SYSTEM - 2012
BCA - DATABASE MANAGEMENT SYSTEM - 2013
BCA - DATABASE MANAGEMENT SYSTEM - 2014
BCA - DATABASE MANAGEMENT SYSTEM - 2016
BCA - DATABASE MANAGEMENT SYSTEM - 2017
BCA - DATABASE MANAGEMENT SYSTEM - 2018
OTHER SUBJECT: -
BCA - DATABASE MANAGEMENT SYSTEM