Examination Paper: Data Base Management System
IIBM Institute of Business Management 1
IIBM Institute of Business Management
Semester-I Examination Paper MM.100
Database Management System
Section A: Objective Type (20 marks)
•This section consists of Multiple Choice Questions & Fill in the blanks / True & False.
•Answer all the questions.
•Each Question carries 1 mark.
Multiple Choices:
1. Structured Query Language (SQL) is the language for working with
a. DDBMS
b. RDBMS
c. Both (a) & (b)
d. None of the above
2. Decomposition in database design means
a. Breaking one table into multiple tables
b. Breaking two table into multiple tables
c. Composing multiple tables into one table
d. None of the above
3. Locking helps
a. Hiding the database
b. To solve concurrency problems
c. Both (a) & (b)
d. None of the above
4. Database optimizer
a. Enhances the speed of query execution
b. Minimizes the speed of query execution
c. Is a program
d. None of the above
5. Data is __________.
a. Raw facts
b. Processed information
c. Both (a) & (b)
d. None of the above
6. Mobile computing means
a. Ability to use computer while on still
b. Ability to use computer while on move
c. Calculation with the help of mobile
d. None of the above
Examination Paper: Data Base Management System
IIBM Institute of Business Management 2
7. Operation Data Store (ODS) provides
a. Situation sensitive decision support & operational reporting
b. Time sensitive decision support & operational reporting
c. Both (a) & (b)
d. None of the above
8. Transaction is
a. Mathematical unit of work
b. Calculation process
c. Logical unit of work
d. None of the above
9. Transitive dependency is
a. Indirect dependency relationship
b. Direct dependency relationship
c. Problem dependency relationship
d. Both (a) & (c)
10. Row in RDBMS is called
a. Domain
b. Tuple
c. Relation
d. None of the above
True & False:
1. Database keys do not allow identification of records.
2. A key is a minimal set of key minimal.
3. Joins cannot be used to retrieve data from multiple tables.
4. Data redundancy prefers to duplication of data.
5. DML is used to retrieve or manipulate data stored in a database.
6. Database keys do not allow identification of records.
7. A super key is a set of column that identifies every row in a table.
8. System recovery is sub-classified into transaction recovery and media recovery.
9. Media recovery deals with disk error.
10. The task of a DDBMS is quite complex.
END OF SECTION A
Examination Paper: Data Base Management System
IIBM Institute of Business Management 3
Section B: Short Questions (20 marks)
•This section consists of short questions.
•Answer should be in 5 lines.
•Each Question carries 5 marks.
•Attempt any four questions.
1. What is SQL? Why is it a powerful language?
2. What are the various transaction models?
3. Discuss the principles of Security?
4. What is Cryptography?
5. What is Semi-Join?
END OF SECTION B
Section C: Long Questions (20 marks)
•This section consists of Long Questions.(word limit 150-200 words)
•Each question carries 10 marks.
•Attempt any two questions.
1. Distinguish between centralized and distributed systems.
2. Explain the idea of abstractions.
3. What is sequential organization? What are its advantages and disadvantages?
END OF SECTION C
Section D: Applied Theory Questions (40 marks)
•This section consists of applied theory questions.
•Each question carries 20 marks.
•Attempt any two questions.
•Detailed information should form the part of your answer (word limit 200-250 words).
1. Write down the layout for a student file containing the following fields:
(a) Roll number Number Maximum Length 5
(b) Student name Character Maximum Length 30
(c) Father’s name Character Maximum Length 30
(d) Address Character Maximum Length 70
Examination Paper: Data Base Management System
IIBM Institute of Business Management 4
2. What are the candidate keys in the following relationships?
(a) Employee code, Employee name, Driving License number, Passport number, Address.
(b) Part ID, Part name, unit Price, Colour, Gender.
3. Is data warehousing related to Enterprise Application Integration (EAI)? Investigate.
4. Account table
Account _ Number Numeric 5
Account _ Name Alphabetic 25
Opening _ balance Numeric 5
Opening _ type Alphabetic 2
Journal table
Account _ Number Numeric 5
Transaction _ date Date 8
Transaction _ type Alphabetic 2
Transaction _ Amount Numeric 5
The Account table specifies the account number, name and the opening balance along with its
type (credit/debit). For example, an accountholder can have an opening credit balance of Rs.
10000, which means that the bank owes the accountholder Rs. 10000. Over a period of time,
many transactions (debits/credits) happen on the account.
Based on this information, attempt the following.
1. Specify a constraint such that if an account number is deleted from the Account table, the
corresponding records in the Journal table should also be deleted.
2. How would you enforce entity integrity in the Account table?
END OF SECTION D
-----------------------------------------------------------------***----------------------------------------------------------
S-1-221110
No comments:
Post a Comment