BCA-09/DCA-103
June Examination 2017
BCA Pt. II/DCA Examination
Database Management System
Paper BCA-09/DCA-103
Time 3 Hours Max. Marks 100
Note: The question paper is divided into three sections B and C. Write answers as per given instructions.
Section A 10 × 2 20
(Very Short Answer Questions)
Note: Answer all questions. As per the nature of the question delimit your answer in one word, one sentence or maximum upto 30 words. Each question carries 2 marks.
Give the defination of RDBMS.
List the usage of key.
Who are End Users?
What is checkpoint?
List the limitations of Oracle.
What is NULL value?
How you can check the constraints in SQL? Give an example.
491
BCA-09/DCA-103 200 3 (P.T.O.)
BCA-09/DCA-103 200 3 (Contd.)
491
(viii) Define degree of relationship.
What is meta-data?
Joining a table to itself is called as ................. Join.
Section B 4 × 10 40
(Short Answer Questions)
Note: Answer any four questions. Each answer should not
exceed 200 words. Each question carries 10 marks.
Give the usage of SELECT query in SQL. Also Explain the
basic difference between where and having clause of SELECT
statement.
Explain Log based recovery technique.
Write short note on Referential Integrity.
Define the concept of Aggregation. Give two example where
this concept is used.
Define functional dependency and explain inference rules of
functional dependencies.
What is view? What are their significance.
What is transaction? What are the properties of transaction?
Define Relational Algebra. Explain briefly various set
operations in Relational Algebra with suitable example.
BCA-09/DCA-103 200 3
491
Section C 2 × 20 40
(Long Answer Questions)
Note: Answer any two questions. You have to delimit your each
answer maximum upto 500 words. Each question carries
20 marks.
10) What are the uses of Joins in SQL queries? Explain different
types of Joins in SQL queries with suitable example.
11) How DDL commands are different from DML? Explain with the
help of suitable example.
12) Why Database Model are used in DBMS? Describe
Hierarchical, Network and Relational Model.
13) What do you mean by serializability? Discuss the conflict and
view serializability with suitable example. Discuss the testing
of serializability also.