S.Y.M.C.A. (Part II) (Under Faculty of Engg.) Examination, 2016
RELATIONAL DATABASE MANAGEMENT SYSTEM
Day and Date Wednesday, 30-11-2016 Total Marks 100
Time 3.00 p.m. to 6.00 p.m.
Instructions Figures to the right indicate full marks.
Q. 3 and Q. 5 are compulsory.
1. Choose the correct alternative 20
Which language is used to permit or prohibit access to a table
DCL DDL
DML All of these
The relationship between data is defined in the
Physical level View level
Logical level None of the above
The security features of the database are set up by the
Online Users Database Administrator
Naive Users Application Programmer
SQL stands for
Structured Question Language Structural Query Language
Structured Query Language Systematic Query Language
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
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
A is a person, place, thing or event for which data is collected
and maintained.
Primary key Table
Record Entity
A relationship has an associative entity with its own characteristics.
1 1 M N
1 M All of the above
The first entity in the relationship is the entity.
Parent Child
Mother Brother
10) A table design that contains a repeating group is called
A repetitive group Unfixed
1NF
11) A record is one that contains a repeating group.
Unnormalized 1NF
2NF 3NF
12) A contains records that contain day-to-day business and
operational data.
Transaction file Work file
Table file Master file
13) A refers to a single characteristic or fact about an entity.
Record Table
Field Primary key
14) You can Place sub-query in
Where clause Having clause
From clause All of the above
15) Data that the db needs to manage itself is called
User data System data
Information data All of the above
SLR-ER 21
SLR-ER 21
16) In the 2NF
Attributes may be functionally dependent on non-key attributes
No attribute dependent on a non-key attribute
No attributes dependent on a primary key
None of the above is correct
17) 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
18) Which of these is an example of an entity
Student A patient's name
An employee's ID All of the above
19) Typically, a database management system is managed by a person called a

System manager Technology manager
Database manager Database administrator
20) DVD stands for
Digital Video Disk Digital Vision Disk
Digital Varying Disk All of these
SECTION I
2. Write short note on any four
Mapping Cardinality
Tuple Relational Calculus
Aggregate functions
Null Value
Stored Procedures.
3. What is trigger Explain trigger with example. 10
Explain DDL, DML and DQL with example. 10
OR
Explain Authorization in SQL with an example. 10
SECTION II
4. Write short note on any four
Functional Dependencies
Magnetic Disk
Serializibility
Distributed System
Data Dictionary.
5. What is ACID Explain ACID properties in detail. 10
Explain tree index file in detail. 10
OR
Explain Centralized System with example. 10