Dbms QB

DBMS Question Bank 2023-24
Module-1
1.what are the main characteristics of the database approach over the
file processing approach?
2.Categorize different types of people who work in a database
environment.
3.List advantages of DBMS and also explain when to not use DBMS.
4.Define the following terms
a.Data model b.schema
c.Metadata d.snapshot
5.Discuss the different components modules of DBMS and their
interaction.
6.Illustrate with a neat diagram, three-schema architecture and explain
the data independence.
7.Explain DBMS language and interfaces.
8.Design ER diagram for bank database taking into account of atleast
four entities with relationship,weak entity and attribute for each entity.
9.Discuss different types of attributes and illustrate their use via
examples.
10.Categorize the relationship degree,role names and recursive
relationship.
11.Design ER diagram of COMPANY database
12.Categorize different types of constraints on databases.
13.Apply different steps involved in ER-Relational Mapping.
14.compare weak entity and strong entity.
Module-2
1.Define generalisation and specialization.Illustrate how it is useful with

examples.
2.Explain ER-diagram, naming conversion and design issues.
3.Illustrate with example relationship types degree of higher than two.
4.Explain subclasses,superclasses and inheritance with suitable
example in ER model.
5.Explain the characteristics of relation.
6.Analyze the importance of differential relational model constraints.
7.Explain constraints on relationship types
8.Explain attributes of relationship types.
9.Explain constraints on specialisation and generalisation.
10.Explain insert,delete and update operation.
11.Explain the following relational algebra operations with example
a.SELECT and PROJECT
b.RENAME operation
c.UNION,INTERSECTION and MINUS operations
d.CROSS PRODUCT operation
e.JOIN and OUTER JOIN operation
f. DIVISION operation
Module-3
1.Queries from basic retrieval queries in SQL.

2.what is the view? Explain how to create view and how view can be
dropped.What problems are associated with updating views.
3.Explain DBMS programming approach and issues.Define Impedance
Mismatch.
4.Define and Explain functional dependency.
a.Find the possible functional dependency with an example.
b.Inference rules for Functional dependencies.
5.Why normalisation needed? Illustrate with an example first normal
form.
6.Explain SQL data definition and data types
7.List and explain Attribute Data types and domains in SQL.
8.Explain informal guidelines for relation schemas.what happens when
guidelines are violated?
9.With example, explain how to eliminate transitive dependencies.
10.what is multivalued dependency?with example explain how to handle
multivalued dependencies in relation.
11.Discuss problems with NULL and Dangling tuples.
12.Illustrate with an example second normal form.
13.Illustrate with an example third normal form.
14.Compare and contrast 3NF with BCNF.
15.With example,demonstrate the mechanism to handle the partial
dependencies.
16.Justify how redundant information in tuples leads to update
anomalies.
17.Illustrate the mechanism to avoid the nested relations while designing
the database.
Module-4
1.Explain the properties of Relational Decomposition.

2.Define and write algorithm of Nonadditive Join Property of
Decomposition.
3.Explain the algorithm for Relational database schema diagram.
4.Illustrate with example fourth normal form.
5. Explain join dependencies and fifth normal form.
6.Draw and explain the state transition diagram illustrating the states for
transaction execution.
7.State and explain desirable properties of the transaction.
8.Design an algorithm for testing conflict serializability of a schedule with
an example.
9.Why concurrency control is needed? Examine the problems that occur
if they run.Explain with an example.
10.what is two phase locking protocol?How does it guarantee
serializability?
11.Explain the two phase locking techniques for concurrency control.
12.Explain characteristics schedules based on serializability with
examples.
13.Explain characteristics schedules based on recoverability with
example.
14.Illustrate uses of serializability.
15.Describe the violation occurs if a transaction is executed at another
level than SERIALIZABLE.
16.Define time stamp.Write an algorithm for timestamp ordering.
17.Discuss the problem of deadlock and starvation and different
approaches to dealing with these problems.
18.Explain the multiversion and optimistic control techniques.
Module-5
1.Design and Explain ARIES database recovery algorithm.

2.Describe the shadow paging recovery technique.
3.With example,explain how to perform multiple granularity locking.
4. What is meant by transaction rollback? Explain.
5.
6.
7.Analyze the procedure for recovery technique based on immediate
update and deferred update.
8.
9.
10.
11.
12.
13.
14.
15.

Dbms QB

Uploaded by

Copyright:

Available Formats

Dbms QB

Uploaded by

Document Information

Original Title

Copyright

Available Formats

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

Available Formats

Dbms QB

Uploaded by

Copyright:

Available Formats

DBMS Question Bank 2023-24

1.Define generalisation and specialization.Illustrate how it is useful with

1.Queries from basic retrieval queries in SQL.

1.Explain the properties of Relational Decomposition.

1.Design and Explain ARIES database recovery algorithm.

You might also like