BCA 2nd YEAR DBMS Last & Previous Year Question
DATABASE MANAGEMENT SYSTEM
2018
Part-A 10 x 1/5 = 15
1 Define DBMS.
2 What is a candidate key?
3 What do you mean by entity set?
4 Define entity integrity.
5 Write the difference between the 'PACK' and 'ZAP' commands.
6 What do you mean by super key?
7 Explain the 'SET CLOCK' command.
8 Define indexing.
9 Define setting filters.
10 What is a derived attribute?
Part-B 5 x 3 = 15
11. Explain physical data independence.
12. Explain domain integrity
13. Elaborate serializability.
14. Explain FV and PV().
15. How will you add a record in FoxPro?
Part-C 7,7,6 = 20
UNIT – I
16. Explain the architecture of DBMS? Who is DBA and what are his responsibilities?
OR
Explain ER model with a suitable example. Write about the hierarchical model.
UNIT – II
17. Explain normalization? Write each normalization in detail.
OR
Write short notes with suitable examples:
(i) Functional dependencies
(ii) Multi-valued dependencies.
UNIT – III
18. Explain DDL, DML, DCL with suitable examples. What is the date and time function?
OR
Explain the procedure and user-defined function with example.
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
