Centre for Distance and Online Education

Model Question Paper (MQP)

Name of Programme: Master of Computer Applications

Semester: I

Course Code: OMCA104

Course Name: Database Management System

Instructions
This paper consists of three sections: A, B, and C. Answer all questions from Section A, any four questions from
Section B, and any three questions from Section C. Marks are indicated against each question.

• Section A: Multiple choice questions (MCQs)

Each question carries two marks
No. of questions: 10 (all to be answered)
Maximum marks: 10 x 2 = 20 marks

• Section B: Short answer questions (200-250 words)

Each question carries five marks
No. of questions: Six (answer any four)
Maximum marks: 4 x 5 = 20 marks

• Section C: Long answer questions (400-450 words)

Each question carries ten marks
No. of questions: Four (answer any three)
Maximum marks: 3 x 10 = 30 marks

Maximum marks: 70 marks

Exam duration: 3 hours
SECTION A: MCQ
Answer options
Sl. Question
A B C D
What are the three tasks are
involved in Traditional Query
Processing:
A) Optimisation A, C, D A, B, E A, B, C C, B, E
1
B) Execution
C) Statistics Tracking
D) Compilation
E) Catalog
Which of the following is not a
2 Hierarchical Network Distributed Decentralized
type of database?
The DBMS acts as an interface
Database
between ________________ and Data and the Application The user and
3 application and
________________ of an DBMS and SQL the software
the database
enterprise-class system.
TCL
The ability to query data, as well DCL (Data DDL (Data DML (Data
(Transaction
4 as insert, delete, and alter tuples, Control Definition Manipulation
Control
is offered by ____________ Language) Langauge) Langauge)
Language)
_________________ operations
Inner join Natural join Right outer
5 do not preserve non-matched Left outer join
join
tuples.
Which one of the following
6 keyword is used to find out the TOTAL COUNT SUM SUM
number of values in a column?
T1 T2 T3
R(Y)
R(Z)
R(X)
W(X)
W(Y)
W(Z)
7 T1 − T2 − T3 T3 − T1 − T2 T2 − T1 − T3 T1 − T3 − T2
W(Z)
R(Y)
W(Y)
R(Y)
W(Y)
R(X)
W(X)
Which of the following command
8 DROP DELETE TRUNCATE REMOVE
is used to delete a table in SQL?
 Given the following SQL Retrieves the
statement: names of all Deletes Inserts names
Updates the
SELECT Name FROM Employees employees names of into
names of
WHERE DepartmentID IN who work in employees in Employees for
9 employees in
(SELECT DepartmentID FROM departments departments departments
well-funded
Departments WHERE Budget > with a budget with high with large
departments
100000); greater than budgets budgets
What does this query do? 100000
The results of
The database The
Transactions the
remains in a transaction
In the context of transactions, are isolated transaction
consistent only shows
10 what does the consistency from each are
state before committed
property ensure? other permanently
and after the data to
stored in the
transaction external users
database
 SECTION B: Short answer questions* (200-250 words)

Sl. No. Question Marks

1 Enlist and explain four aggregate functions. 5

2.5 +
2 What is DDL and DML commands with syntax and examples?
2.5
Discuss the main characteristics of the database approach and specify how it
3 2.5+2.5
differs from traditional file system.

4 State 1NF, 2NF & 3NF and explain with examples. 5

5 What is 2-phase locking protocol? How does it guarantee serializability? 2.5+2.5

6 Why is the concurrency control needed? Explain it. 5

*Answer any four questions

SECTION C: Long answer questions* (400-450 words)

Sl. No. Question Marks

1 What is transaction? Mention the desirable properties of a transaction. 5+5

2 Briefly discuss about various lock-based mechanisms used in concurrency control. 10

Enlist and explain the properties of database management systems? Enlist and explain
3 5+5
the properties of database management systems?
Write SQL query for following consider table
EMP(empno , deptno, ename ,salary, Designation, joiningdate, DOB,city)
i) Display names of employees whose experience is more than 10 years 2+
4
ii) Display age of employees (2x4)
iii) Display average salary of all employee
iv) Display name of employee who earned highest salary
*Answer any three questions

****************************************************** END OF SHEET ******************************************************