S.Y. MCA (Part II) (Under Faculty of Engg.) Examination, 2017
RELATIONAL DATABASE MANAGEMENT SYSTEM
Day and Date Friday, 5-5-2017 Total Marks 100
Time 3.00 p.m. to 6.00 p.m.
Instructions Figures to the right indicates full marks.
Q.3.A. and Q.5A. are compulsory.
1. Choose the correct alternative. 20
A record is one that contains a repeating group.
Unnormalized INF
2NF 3NF
A contains records that contain day-to-day business and
operational data.
Transaction file Work file
Table file Master file
A refers to a single characteristic or fact about an entity.
Record Table
Field Primary key
You can place subquency in
Where clause Having clause
From clause All of the above
Data that the db needs to manage itself is called.
User data System data
Information data All of the above
In the 2NF
Attributes may be functionally dependent on nonkey attributes
No attribute dependent on a nonkey attribute
No attributes dependent on a primary key
None of the above is correct
Non key field is a field that is
Not a candidate key for the primary key
A candidate key for the primary key
A primary key
None of the above is correct
Which of these is an example of an entity
Student A patient's name
An employee's ID All of the above
Typically, a database management system is managed by a person called a

System manager Technology manager
Database manager Database administrator
10) DVD stands for
Digital Video Disk Digital Vision Disk
Digital Varying Disk All of these
11) Which language is used to permit or prohibit access to a table
DCL DDL
DML All of these
12) The relationship between data is defined in the
Physical level View level
Logical level None of the above
13) The security features of the database are set up by the
Online Users Database Administrator
Naive Users Application Programmer
14) SQL stands for
Structured Question Language Structural Query Language
Structured Query Language Systematic Query Language
15) A refers to the complete definition of a database, including
descriptions of all fields, tables, and relationships.
Schema Data repository
Data manipulation language None of the above
16) The rule that requires that a foreign key value cannot be entered in one table
unless it matches an existing primary key in another table.
Referential integrity Domain integrity
Entity integrity constraint A data validation constraint
17) A is a person, place, thing, or event for which data is
collected and maintained.
Primary key Table
Record Entity
18) A relationship has an associative entity with its own
characteristics.
1 1 M N
1 M All of the above
19) The first entity in the relationship is the entity.
Parent Child
Mother Brother
20) A table design that contains a repeating group is called
A repetitive group Unfixed
1NF
SLR-L 16
SECTION I
2. Write short note on any four.
Null Value.
Stored Procedures.
Aggregate functions.
Mapping cardinality.
Tuple Relational Calculus.
3. Explain DDL, DML and DQL with example. 10
What is trigger Explain trigger with example. 10
OR
Explain authorization in SQL with an example. 10
SECTION II
4. Write short note on any four.
Distributed System.
Data Dictionary.
Serializibility.
Functional Dependencies.
Magnetic Disk.
5. Explain tree index file in detail. 10
What is ACID Explain ACID properties in detail. 10
OR
Explain Centralized System with example. 10