Iibm - Database Management System

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

www.mbacasestudyanswers.com

ARAVIND – 09901366442 – 09902787224

Database Management Systems

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’?

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)

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 at least one sales transaction.

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

www.mbacasestudyanswers.com

ARAVIND – 09901366442 – 09902787224