Download GTU MBA 2015 Winter 3rd Sem 2830401 Database Management Question Paper

Download GTU (Gujarat Technological University) MBA (Master of Business Administration) 2015 Winter 3rd Sem 2830401 Database Management Previous Question Paper

1

Seat No.: ________ Enrolment No.___________

GUJARAT TECHNOLOGICAL UNIVERSITY
MBA ? SEMESTER 3? ? EXAMINATION ? WINTER 2015

Subject Code:2830401 Date: 03/12/2015
Subject Name: Database Management
Time: 10.30 AM to 01.30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

6
Q.1 (a) Entity is a
1.
A. Object of relation B. Present working model
C. Thing in real
world
D. Model of relation
2.
A relational database consists of a collection of
A.
Tables
B. Fields
C. Records D Keys
3.
Which one of the following is used to define the structure of the relation,
deleting relations and relating schemas?

A. DML(Data
Manipulation
Language)
B. DDL(Data Definition Language)
C. Query D. Relational Schema
4.
Which one of the following provides the ability to query information
from the database and to insert tuples into, delete tuples from, and
modify tuples in the database?

A. DML(Data
Manipulation
Language)
B. DDL( Data Definition Language)
C. Query D. Relational Schema
5.
The entity set person is classified as student and employee .This process is
called

A. Generalization B. Specialization
C. Inheritance D. Constraint generalization
6.
Which of the following is not modification of database
A. Deletion B. Insertion
C. Sorting D. Updating
Q.1 (b) Define:
1. Entity
2. Referential Integrity
3. Candidate Key
4. Meta data

04
Q.1 (c) Explain Multitier Client/Server Databases 04

FirstRanker.com - FirstRanker's Choice
1

Seat No.: ________ Enrolment No.___________

GUJARAT TECHNOLOGICAL UNIVERSITY
MBA ? SEMESTER 3? ? EXAMINATION ? WINTER 2015

Subject Code:2830401 Date: 03/12/2015
Subject Name: Database Management
Time: 10.30 AM to 01.30 PM Total Marks: 70
Instructions:
1. Attempt all questions.
2. Make suitable assumptions wherever necessary.
3. Figures to the right indicate full marks.

6
Q.1 (a) Entity is a
1.
A. Object of relation B. Present working model
C. Thing in real
world
D. Model of relation
2.
A relational database consists of a collection of
A.
Tables
B. Fields
C. Records D Keys
3.
Which one of the following is used to define the structure of the relation,
deleting relations and relating schemas?

A. DML(Data
Manipulation
Language)
B. DDL(Data Definition Language)
C. Query D. Relational Schema
4.
Which one of the following provides the ability to query information
from the database and to insert tuples into, delete tuples from, and
modify tuples in the database?

A. DML(Data
Manipulation
Language)
B. DDL( Data Definition Language)
C. Query D. Relational Schema
5.
The entity set person is classified as student and employee .This process is
called

A. Generalization B. Specialization
C. Inheritance D. Constraint generalization
6.
Which of the following is not modification of database
A. Deletion B. Insertion
C. Sorting D. Updating
Q.1 (b) Define:
1. Entity
2. Referential Integrity
3. Candidate Key
4. Meta data

04
Q.1 (c) Explain Multitier Client/Server Databases 04

2
Q.2 (a) Explain Advantages of Database Management System in detail. 07
(b) Explain Working of Two tier client/server database architecture with reference
to an Educational Institution.
07


OR
(b) Clearly define the ER diagram for database of Paper manufacturing company
with cardinality ratio.
07

Q.3 (a) Explain Insert, Delete and Update command in SQL and give example for
every command.
07
(b) Write down the steps in building the data model by using E-R Diagram
Approach.
07
OR
Q.3 (a) Explain TCL and DQL with proper syntax 07
(b) Explain SQL and How it is used to create and edit database. 07

Q.4 (a) Explain base table and virtual table. Discuss Dynamic view with Pros and Cons. 07
(b) Describe the JOIN operation. What does it accomplish? Explain with
Example.
07
OR
Q.4 (a) Write Short note on
1. Network model
2. Hierarchical Model
07
(b) Who is DBA? Explain the functions of DBA in Automobile parts
manufacturing company.
07

Q.5 Develop a Database application for Stationary Supplier by considering
Software development life cycle approach.
14
OR

Q.5 Develop an E-R diagram to keep record of the patients admitted to the hospital. 14

*************
FirstRanker.com - FirstRanker's Choice