IIBM Institute of Business Management
Examination Paper MM.100
Database Management Systems
Section A: Objective Type (30 marks)
•This section consists of Multiple Choices and Short notes type questions.
•Answer all the questions.
•Part one questions carry 2 marks each & Part Two questions carry 4 marks each.
Part One:
Multiple choices:
1. The normal language of database is:
a. PHP
b. SQL
c. C++
d. Java
2. DDL, a database system language:
a. Creates table
b. Manipulates table
c. Cannot work with table
d. None
3. Symbol for one to one relationship is………………………………………………………
4. HDBMS stands for:
a. Hello DBMS
b. Hierarchical DBMS
c. Hyper DBMS
d. High DBMS
5. In Anti joining of R►S means ……………………………………………………………
Part Two:
1. What are “Foreign Keys”?
2. Differentiate between ‘DBMS’ and ‘RDBMS’.
3. Write the syntax to insert charts into a table from another table.
4. What are ‘Armstrong’s Axioms’?
Examination Paper: Information Technology
7
IIBM Institute of Business Management
5. Write short ‘Boyce-Codd Normal Form (BCNF)’.
END OF SECTION A
Section B: Long Questions (40 marks)
•This section consists of Long Questions.
•Answer all the questions.
•Each question carries 10 marks.
•Detailed information should form the part of your answer (Word limit 150 to 200 words).
1. Elaborate the testing of Serializability techniques with example.
2. Explain the working of lock manager.
3. What is deadlock? How is a deadlock detected? Enumerate the method for recovery from the
deadlock.
4. Explain why a transaction execution should be atomic. Explain ACID properties, considering the
following transaction.
Ti: read (A);
A : = A- 50;
Write (A);
Read (B);
B : = B + 50;
Write (B)
END OF SECTION B
Examination Paper: Information Technology
8
IIBM Institute of Business Management
Section C: Applied Theory (30 marks)
•This section consists of Applied Theory Questions.
•Answer all the questions.
•Each question carries 15 marks.
•Detailed information should form the part of your answer (Word limit 200 to 250 words).
1. The HR manager has decided to raise the salary for all the employees in department number 30
by 0.25. Whenever any such raise is given to the EMPLOYEES, a record for the same is
maintained in the EMP-RAISE table. It includes the employee number, the date when the raise
was given and the actual raise. Write a PL/SQL block to update the salary of each employee and
insert a record in the EMP-RAISE table.
2. Retrieve the salesman name in ‘New Delhi’ whose efforts have resulted into atleast one sales
transaction.
Table Name : SALES-MAST
Salesman-no Name City
B0001
B0002
B0003
B0004
B0005
B0006
B0007
Puneet Kumar
Pravin Kumar
Radha Krishna
Brijesh Kumar
Tushar Kumar
Nitin Kumar
Mahesh Kumar
Varanasi
Varanasi
New Delhi
New Delhi
Allahabad
Allahabad
Gr. Noida
Table Name : SALES-ORDER
Order-no Order-date Salesman-no
S0001
S0002
S0003
S0004
S0005
S0006
10-Apr-07
28-Apr-07
05-May-07
12-June-07
15-July-07
18-Aug-07
B0001
B0002
B0003
B0004
B0005
B0006
END OF SECTION C
S-2-210311
Examination Paper MM.100
Database Management Systems
Section A: Objective Type (30 marks)
•This section consists of Multiple Choices and Short notes type questions.
•Answer all the questions.
•Part one questions carry 2 marks each & Part Two questions carry 4 marks each.
Part One:
Multiple choices:
1. The normal language of database is:
a. PHP
b. SQL
c. C++
d. Java
2. DDL, a database system language:
a. Creates table
b. Manipulates table
c. Cannot work with table
d. None
3. Symbol for one to one relationship is………………………………………………………
4. HDBMS stands for:
a. Hello DBMS
b. Hierarchical DBMS
c. Hyper DBMS
d. High DBMS
5. In Anti joining of R►S means ……………………………………………………………
Part Two:
1. What are “Foreign Keys”?
2. Differentiate between ‘DBMS’ and ‘RDBMS’.
3. Write the syntax to insert charts into a table from another table.
4. What are ‘Armstrong’s Axioms’?
Examination Paper: Information Technology
7
IIBM Institute of Business Management
5. Write short ‘Boyce-Codd Normal Form (BCNF)’.
END OF SECTION A
Section B: Long Questions (40 marks)
•This section consists of Long Questions.
•Answer all the questions.
•Each question carries 10 marks.
•Detailed information should form the part of your answer (Word limit 150 to 200 words).
1. Elaborate the testing of Serializability techniques with example.
2. Explain the working of lock manager.
3. What is deadlock? How is a deadlock detected? Enumerate the method for recovery from the
deadlock.
4. Explain why a transaction execution should be atomic. Explain ACID properties, considering the
following transaction.
Ti: read (A);
A : = A- 50;
Write (A);
Read (B);
B : = B + 50;
Write (B)
END OF SECTION B
Examination Paper: Information Technology
8
IIBM Institute of Business Management
Section C: Applied Theory (30 marks)
•This section consists of Applied Theory Questions.
•Answer all the questions.
•Each question carries 15 marks.
•Detailed information should form the part of your answer (Word limit 200 to 250 words).
1. The HR manager has decided to raise the salary for all the employees in department number 30
by 0.25. Whenever any such raise is given to the EMPLOYEES, a record for the same is
maintained in the EMP-RAISE table. It includes the employee number, the date when the raise
was given and the actual raise. Write a PL/SQL block to update the salary of each employee and
insert a record in the EMP-RAISE table.
2. Retrieve the salesman name in ‘New Delhi’ whose efforts have resulted into atleast one sales
transaction.
Table Name : SALES-MAST
Salesman-no Name City
B0001
B0002
B0003
B0004
B0005
B0006
B0007
Puneet Kumar
Pravin Kumar
Radha Krishna
Brijesh Kumar
Tushar Kumar
Nitin Kumar
Mahesh Kumar
Varanasi
Varanasi
New Delhi
New Delhi
Allahabad
Allahabad
Gr. Noida
Table Name : SALES-ORDER
Order-no Order-date Salesman-no
S0001
S0002
S0003
S0004
S0005
S0006
10-Apr-07
28-Apr-07
05-May-07
12-June-07
15-July-07
18-Aug-07
B0001
B0002
B0003
B0004
B0005
B0006
END OF SECTION C
S-2-210311
No comments:
Post a Comment