BCA 2nd YEAR DBMS Last & Previous Year Question
DATABASE MANAGEMENT SYSTEM
2013
Part-A 10 x 1 = 10
1. What do you understand by data independence ?
2. Explain Schema.
3. What is derived attribute ?
4. What is Heap file organization ?
5. Describe data models.
6. Explain domain.
7. Write the syntax of REINDEX Command in foxpro.
8. What do you understand by functional dependency?
9. Explain ZAP Command in foxpro.
10. What we use GATHER Command in foxpro ?
Part-B 5 x 2 = 10
1 Explain Integrity Constraints.
2 Explain following foxpro command with the help of example
(a) Skip
(b) Get
(C) Scan
(d) Copy Structure.
3. What do you understand by mapping ? Explain mapping constraints.
4. What is the difference between centralized and client server architecture ? Explain 3 tier client server architecture.
5. Explain Time stamp protocol.
Part-C 10 x 3 = 30
1 (a) Explain Normalization upto UNE.
(b) What do you understand by recovery ? Explain the recovery techniques.
OR
1(a)Explain serial and non serial schedule with the help of an example.
(b) What do you undrstand by concurrency control ? Explain locking techniques.
2 Write a program in foxpro to print the report in following format.
STUDENT DETAIL
Name :- Father's Name :
Mother's Name : Roll Number :
Date : Class :
SUBJECT NAME
C++
CST
JAVA
CS
CG
DBMS
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