Database Management Systems-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

The HR manager has decided

Database Management Systems

 

Multiple choices:

Q1. The normal language of database is:

a. PHP

b. SQL

c. C++

d. Java

Q2. DDL, a database system language:

a. Creates table

b. Manipulates table

c. Cannot work with table

d. None

Q3. Symbol for one to one relationship is………………………………………………………

Q4. HDBMS stands for:

a. Hello DBMS

b. Hierarchical DBMS

c. Hyper DBMS

d. High DBMS

Q5. In Anti joining of R►S means ……………………………………………………………

Part Two:

Q1. What are “Foreign Keys”?

Q2. Differentiate between ‘DBMS’ and ‘RDBMS’.

Q3. Write the syntax to insert charts into a table from another table.

Q4. What are ‘Armstrong’s Axioms’?

Q5. Elaborate the testing of Serializability techniques with example.

Q6. Explain the working of lock manager.

Q7. What is deadlock? How is a deadlock detected? Enumerate the method for recovery from the  Deadlock.

Q8. Explain why a transaction execution should be atomic. Explain ACID properties, considering the following transaction.

a. Ti: read (A);

A : = A- 50;

Write (A);

b. Read (B);

B : = B + 50;

Write (B)

Q9. 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.

Q10. Retrieve the salesman name in ‘New Delhi’ whose efforts have resulted into atleast one sales transaction.

 

 

Need Answer Sheet of this Question paper, contact

aravind.banakar@gmail.com

ARAVIND – 09901366442 – 09902787224