Master of Computer Application II (Science)
Examination: Oct/ Nov 2016 Semester III (Old CGPA)
SLR No. Day
Date Time Subject Name Paper
No. Seat No.
SLR U
24
Wednesday
23/11/2016
02:30 P.M
To
05:00 P.M
DBMS
C

Instructions: Question no. 1 2 are compulsory
Attempt any three questions from Q. No. 3 to Q. No. 7
Figures to the right indicate full marks.
Total Marks: 70
Q.1 Choose correct alternatives 10
and _(underscore) are operators:
Relational Arithmetic
Like None of these
Which of the following is correct?
Data DBMS Database
Data Database DBMS
Database DBMS Database system
None of these
Number of tuples in a relation, known as
Cardinality Degree
Tuple set Modality
Relational calculus describes about
to evaluate a query is to be retrieved
to evaluate a query to evaluate a query
Initial state of transaction is
Active state Partially committed state
Failed state Aborted state
Two actions on the same data object conflict if at least one of them is
Read Write
Read/Write None of these
Shadowing may result in
Page loss Page swap
Data scattering both
LOB stands for
Large Object Base List Object
List Object Base Large Object
A repository of information about database is known as
Data dictionary Distributed Database
Data table Data repository
10) How many tables can be joined to create a view?
1 2
Depends on DBMS None of these
Page 1 of 2
State whether true or false 04
GRANT and REVOKE are DML commands.
Every conflict serializable schedule is view serializable too.
SQL supports procedural statements.
2nd normal form removes partial dependency.
Q.2 Write a short note on followings: 08
Limitations of traditional file processing system.
Naming conventions for objects
Answer the following: 06
What are the advantages of optimization in query processing?
What is distributed database? Describe its types in brief.
Q.3 Answer the following:
Explain all components of DBMS in detail.
Construct an ER-diagram for a hospital with a set of patients and a set of
medical doctors. Associate with each patient of log of various tests and
examination conducted.
07
07
Q.4 Answer the followings:
Discuss about the 4th normal form and 5th normal form with example.
What is relational algebra? Explain following operations of relational algebra
with example: select, project, cross product, union and division.
07
07
Q.5 Answer the followings:
What is query processing? Explain the steps involved in in it.
Explain the concept of nested table. Describe how to insert data in nested tables
and how to retrieve from it.
07
07
Q.6 Answer the following
What is lock? What are its types? Explain two phase locking protocol.
Discuss about differed database updates and immediate database updated with
examples of each
07
07
Q.7 Answer the following
What is distributed database? Explain the concept of fragmentation and its
types with example of each.
Consider the following database schema.
STUDENT (Name, Student_Number, Class, Major)
COURSE (Course_name, Course_number, Credit_Hours, Department)
SECTION (Selection_Identifier, Course_Number, Semester, Year,
Instructor)
GRADE_REPORT (Student_Number, Section_Identifier, Grade)
PREREQUISITE (Course_Number, Prerequisite_Number)
Answer the following queries:
1. Retrieve the name of all courses taught by professor Mishra in year
2014.
2. Retrieve the name and transcripts of each student majoring in
'COSE (Computer Science). Transcript includes Course_Name,
Course_Number, Credit_Hours, Semester, Year and Grade.
3. Retrieve the name and major departments of all students who do not
have grade in any of their courses.