Master of Science II (Computer Science)
Examination: Oct/Nov 2016 Semester III (New CBCS)
SLR No. Day
Date Time Subject Name Paper
No. Seat No.
SLR SC
311
Thursday
24/11/2016
10:00 A.M
to
01:30 P.M
DBMS
C
VIII
Instructions: Q.No.1 and 2 are compulsory.
Answer any three questions from Q.No.3 to Q.No.7.
All questions carry equal marks.
Marks:70
Q.1 Select correct alternatives: 10
The refers to the way data is organized in and accessible from
DBMS.
Database hierarchy Data organization
Data sharing Data model
are the different events in Triggers.
Define, Create Drop, Comment
Insert, Update, Delete Select, commit
language is the subset of SQL commands used to manipulate Oracle
Database structures, including tables.
Data Definition Data Manipulation
Data Described Data Retrieval
A set of possible data values is called
Attribute Degree
Tuple Domain
A represents the number of entities to which another entity can be
associated.
Mapping cardinality Table
Schema Information
A is a set of column that identifies every row in a table.
Composite key Candidate key
Foreign key Super key
is critical in formulating database design.
row column order number of tables
functional dependency normalizing
Privileges once given can be denied to a user using command.
GRANT PERMIT
COMMIT REVOKE
Page 1 of 2
A allows the storing of repeating attributes of a record in a single row.
Varying array Object
Abstract method All
10) character function can be used to return a specified portion of a
character string.
INSTR SUBSTRING
SUBSTR POS
State True or false: 04
The data dictionary is a tool used exclusively by the database administrator.
It is necessary to create physical tables at each level of abstraction.
System variable date$ can be assigned to any field only during design time.
Nested table is a table within a table.
Q.2 Write short notes on the following: 08
Advantages of DBMS.
ii) Functional Dependency

Answer the following: 06
Write the advantages of Optimisation.
ii) What is Replication?
0
Q.3 Answer the following: 14
Explain components of DBMS.
What is Exception? Explain user defined Exception in detail.
Q.4 Answer the following: 14
What is Recovery? Why Recovery is necessary?
Draw E-R diagrams for College Admission system.
Q.5 Answer the following: 14
Explain ACID properties of transaction.
Explain steps in Query processing.
Q.6 Answer the following: 14
Write PL SQL block to determine to 5 highest paid employees from the
employee table using Cursor.
Explain Indexing in detail.
Q.7 Answer the following: 14
Show two phase locking ensures conflict serializability.
Explain concept of Distributed databases.