M. Sc. (Semester (CBCS) Examination Oct/Nov-2017
Computer Science
DBMS
Day Date: Thursday, 23-11-2017 Max. Marks: 70
Time: 10.30 AM to 01.00 PM
Instructions: Q.1 and Q.2 is compulsory.
Attempt any three questions from Q. 3 to 7.
Figures to the right indicate full marks.
Q.1 Choose correct alternatives: 10
An index file is an example of
Sequential file Data block
Application of indices All of the above
Which of the following is a valid SQL type?
CHARACTER NUMERIC
FLOAT All of the above
ODBC stands for
Object data base connectivity.
Oral data base connectivity.
Oracle data base connectivity.
Open data base connectivity.
Relational calculus is a
Procedural language Non Procedural language
High level language All of the above
Which of the normal form is considered adequate for relational
database design?
2NF 5NF
4NF 3NF
In the architecture of a database system external level is the.
Physical level Logical level
Conceptual level View level
A primary key for a entity is
Candidate key Any attribute
unique attribute super key
The data base schema is written in.
HLL DML
DDL DCL
SET concept I used in
Network model Hierarchical model
Relational model None of the above
10) An operation that will increase the length of a list is.
Modify Look-up
Insert All of the above
Page 2 of 2
SLR-MG-291
State whether true or false: 04
E-R model uses diamond symbol to represent weak entity set.
The RDBMS terminology for a row is tuple.
The full form of DDL is dynamic data language.
Transaction processing is associated with everything below except
conforming an action or triggering response.
Q.2 Write short notes on the following: 08
Shadow paging
DBA
Answer the following: 06
What is difference between replication and fragmentation?
What is transaction Explain its states.
Q.3 Answer the following: 14
Briefly discuss the advantages and functions of DBMS.
Define entity and attribute. Explain the different types of attribute that occur
in E-R model.
Q.4 Answer the following: 14
Define normalization. Explain 1NF, 2NF AND 3NF.
What are triggers? Explain its advantages and needs.
Q.5 Answer the following: 14
Explain in detail client-server architecture.
Explain log based recovery in detail.
Q.6 Answer the following: 14
Explain basic steps involved in query processing.
Discuss two phase commit protocol and its significance.
Q.7 Answer the following: 14
What is mean by views in SQL? Explain how we can create views in SQL.
Explain conflict serializability with example.