BCA 2nd YEAR DBMS Last & Previous Year Question
DATABASE MANAGEMENT SYSTEM
2012
Part-A 10 x 1 = 10
1. Differentiate between data and information.
2. What is a system?
3. What is security?
4. What is a database file?
5. What is data abstraction?
6. Define Network Database.
7. Explain the syntax of 3 FoxPro commands.
8. What is the concept of Recursion?
9. What is OLAP?
10. What is broad band technology?
Part-B 5 x 2 = 10
11 Discuss the client-server architecture in detail.
12 What do you mean by Normalization forms ?
13 What is the concept of D.C.L.?
14 What are the functions performed by D.B.A ?
15 Differentiate between physical and logical data independence.
Part-C 10 x 3 = 30
16 Discuss in detail the programming facility available in FoxPro. What is file in FoxPro ?
OR
What do you understand by Referential Integrity ? Give examples.
17 What is entity-relationship model? What are its components?
OR
What is Relational Model of D.B.M.S ? Write a note on Relational Algebra.
18 What is the meaning of concurrency and concurrency control?
OR
What are searching commands of FoxPro ? Write a note on multi-valued dependencies.
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
BCA - CLIENT-SERVER TECHNOLOGY