M.Sc. (Computer Science) (Sem II) (CBCS) Examination, 2017
Database Management System
Day Date: Saturday, 29-04-2017 Max Marks: 70
Time: 10.30 AM to 1.00 PM
Instruction: Question no. 1 and 2 are compulsory.
Attempt any 3 questions from Q. no. 3 to Q. no. 7
Figures to the right indicate full marks.
Q.1 Choose correct alternatives. 10
A default value constrains
Constant value Varying value
Given value if not supplied None
COUNT function is used for
Counting of tables Counting of values
Counting of records Counting of tuples
A table that is 1NF and includes no partial dependencies only
is said to be in
1NF 2NF 3NF 4NF
A defined as a key that is used strictly for data
retrieval purposes.
Primary key Secondary key
Foreign key Logical key
The process of attempting to improve the locking is known

Check pointing Concurrency control
Recovering Polymorphism
To delete a database is used.
delete database database_name
Delete database_name
drop database database_name
drop database_name
critical in formulating database design.
Row column order Number of tables
Functional dependency Normalizing
Page 1 of 2
A is a set of objects, each with the same data
type.
varying abstract large nested
To pass on granted privileges to other user the
is used
create option grant option
update option select option
10) operator is basically a join followed by a project on
the attributes of first relation.
Join Semi join Full join Inner join
State True or False. 04
Varchar data type allows for storage of numbers.
Data models provide logical relationship among data
elements.
Privileges once given can be denied to a user using COMMIT
command.
Varying arrays are collectors that allow repetition of only
those column values that change.
Q.2 Write short notes on the following. 08
Client Server Architecture
Nested tables
Answer the following. 06
Explain referential integrity.
Explain aggregate functions.
Q.3 Answer the following. 14
Differentiate Standalone Vs Distribute databases
What is Normalization? Explain Boyce codd's normal form.
Q.4 Answer the following. 14
Explain ACID properties with suitable examples.
Explain DML commands and DCL commands.
Q.5 Answer the following. 14
Explain indexing in detail.
Explain E-R model with examples.
Q.6 Answer the following. 14
Explain parameterized Cursor with example.
Explain various Recovery techniques.
Q.7 Answer the following. 14
Explain SET operators with examples.
Explain Data Model.