BCA 2nd YEAR DBMS Last & Previous Year Question
DATABASE MANAGEMENT SYSTEM
2017
Part-A 10 x 1/5 = 15
Q.1 What is ‘Weak Entity Set'?
Q.2 Explain Project Operation.
Q.3 Explain SELECT' command.
Q.4 What is derived attribute?
Q.5 What do you understand by Instances and Schema?
Q.6 Write syntax and example of 'BROWSE' command.
Q.7 Write the difference between PACK' and ZAP' command.
Q.8 Explain SET CLOCK' command.
Q.9 Differentiate between ACCEPT' and 'INPUT' commands.
Q.10 What is a memory variable?
Part-B 5 x 3 = 15
Q.11 Explain distributed databases.
Q.12 What are the prime responsibilities of a DBA?
Q.13 Explain referential integrity.
Q.14 Explain FV ( ) and PV ().
Q.15 Explain * @ ...say ... get and read with example.
Part-C 7,7,6 = 20
UNIT – I
Q.16 What is DBMS? Write differences between a file -processing system and a DBMS.
OR
Q.16 What do you understand by data model? Explain relational model with example.
UNIT – II
Q.17 Discuss the need of Normalization. Explain BCNF in detail.
OR
Q.17 Write short note on following
(1) Serializability.
(2) Concurrency.
(3) Recovery.
UNIT – III
Q.18 What is Indexing? Write difference between sorting and indexing.
OR
Q.18 Explain procedure and user defined function (UDF) 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