IIBM – Database Management System

Database Management Systems

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

Multiple choices:

1. The normal language of database is:

2. PHP

3. SQL

4. C++

5. Java

2. DDL, a database system language:

3. Creates table

4. Manipulates table

5. Cannot work with table

6. None

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

4. HDBMS stands for:

5. Hello DBMS

6. Hierarchical DBMS

7. Hyper DBMS

8. 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;

What is deadlock? How is a deadlock detected

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.

We at Answer Sheet Help offer all types of online academic assistance, be it homework help, coursework help, case study help, Assignment help, Project Reports, Thesis, Research paper writing help.

At our Answer Sheet Help services, our experts are familiar about the formatting styles that are followed in the academic world. Our experts have a great knowledge about the formatting styles such as MLA, Harvard, APA, Turabian, and many others. All types of formats for the case study help are available at our case study help services. In addition, our experts can solve the case studies as per the instructions of the customers.

The experts of our Answer Sheet Help services are highly qualified and professional. We have CAs CFAs & PhD on our panel who have years of experience in the writing of case study / Assignments.

Writing Services

 

* Article writing

* Case Study writing

* Coursework writing

* Creative writing

* Custom Essay writing

* Dissertation writing

* Essay writing

* Homework writing

* Paper writing

* Presentation writing

* Report writing

* Resume writing

* Thesis writing

* Article Reviews

* Content Writing

* Coursework

* Editing Services

* Homework Assignments

* Personal Writing

* Presentations

* Research Writing

* Editing and formatting