B.Sc. III (Semester (CGPA) Examination, 2018
Database Management System I (Paper II)
Day and Date Monday, 19-11-2018 Total Marks 70
Time 2.30 p.m. to 5.00 p.m.
1. Multiple choice questions. 14
Monitoring jobs running on databases, should be supervised by
Database System Database Manager
Database Users Database Administrator
Functional dependencies are used for
Testing instances of relations
Specify constraints on legal relations
Both a and b
Specifying domain
Definition of 3NF permits certain functional dependencies that are not allowed in
BCNF 1 NF 2 NF 3 NF
Model that uses a collection of tables to represent data and relationships
among data, is known as
Relational model View model
Logical model Physical model
Mapping cardinalities can be of type
2 type 3 type 4 type 5 type
Generating a set of relation schemas that allows storing information without
unnecessary redundancy, is goal of
Normalization Assertion
Association Integration
Algebraic operation that outputs specified attributes from all rows of input
relation, is said to be
Natural join Union operation
Projection Selection
Command that is used to add attributes to an existing relation, is said to be
Alter Delete Select Insert
Application resides at client machine and invokes database system
functionality at server machine through query statement, is type known as
One-tier architecture Two-tier architecture
Three-tier architecture No-tier architecture
10) ON predicate is written like a
From clause Select clause
Where clause None of the above
11) Which of the following is an aggregate function in SQL
Union Like Group Min
12) Which is a database objects from which multiple users can generate unique
integer
Views Sequences
Synonyms None of the above
13) Which of the following database object does not physically exist
Base table Index
View None of the above
14) Which syntax is correct to remove index
Drop index index name Delete index index_ name
Alter index index name None of the above
2. Answer the following (any four) 8
What is DBMS
What is the relationship and relationship set
Define Derived and stored attributes with suitable example.
Define weak entity and strong entity with suitable example.
What is Union and Set difference relational operators explain with
suitable example
Write notes on (any two). 6
Data dictionary.
IN and NOT IN operators in SQL.
Sequences.
3. Answer the following (any two). 8
Explain components of DBMS in detail.
Explain Database languages in detail.
Draw E-R Diagram of 'Hospital Management System'.
Answer the following (any one). 6
Explain Generalization and specialization with suitable example.
Explain operations in file.
4. Answer any two of the following. 10
What are the advantages of Normalization And explain BCNF in
Detail.
What is Join Explain types of Outer joins with proper syntax and
suitable example.
Explain all Clauses in SQL with proper syntax and suitable example.
Answer the following (any one). 4
What is sub query Explain its types with example.
Explain Data models in detail.
5. Answer any two of the following. 14
What is view Explain view with proper syntax and suitable example.
What are benefits using of indexes Explain Indexes with proper syntax
and suitable example.
Explain aggregate functions and string functions in SQL with proper syntax
and suitable example.