www.assignmentsolution.co.in

Get Assignments and Projects prepared by experts at a very nominal fee.

assignmentssolution@gmail.com

Or

contact@assignmentsolution.co.in


Our website : http://www.assignmentsolution.co.in/

Wednesday, 25 July 2012

Database Management Systems: IIBM Exam paper sem 2 : contact us for help


Examination Paper: Information Technology
6
IIBM Institute of Business Management
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


1 comment:

  1. answer for,,Retrieve the salesman name in ‘New Delhi’ whose efforts have resulted into atleast one sales transaction.
    Table Name : SALES-MAST
    Salesman-no 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
    B

    ReplyDelete