DBMS Important Questions
UNIT-1
1. What are the different levels of abstraction.
2. List the difference between File System and DBMS.
3. Explain about Data Independence.
4. Explain the Database Users.
5. Describe the different data models used in DBMS.
6. Explain how to describe and store data in DBMS.
7. Explain about transaction management.
8. What are the disadvantages of File Processing.
9. What is DBMS? Explain advantages and disadvantages of DBMS.
10.What are the different components of DBMS and explain functionality of each
component.
11.Explain the structure/Architecture of DBMS
UNIT-2
12.What are the main steps in database design? Explain the goal of each step.
13.Define the following with respect to an ER-diagram.
i. Relationship set
ii. Aggregation
iii. Multi-valued attribute
14.What is Entity set? And define Relationship set. List and explain the symbols
used to draw ER diagram.
15. Write about different types of attributes in ER Model. Show Notation of each.
16.What is weak entity type? What is a view? How to specify a view? Write about
implementation techniques.
17.What is an integrity constraint? Explain its enforcement by DBMS with
DBMS Important Questions
illustrative example.
18.Explain the conceptual database design on the ER model.
19.Describe how entity sets and relationship sets mapped into Tables?
20.With a suitable example show how relationship sets and entity sets are
translated into tables?
21.Explain integrity constraints.
22.Explains Tables and Views?
23.Explain referential integrity with example?
24.Define Primary Key and Foreign Key.
25.What is a view? What are its advantages.
26.Difference between Candidate key and primary key.
Unit-3
27.Write short notes on set operations of relational algebra.
28.What is the purpose of JOIN operation? Explain all variations of the JOIN
operation.
29.Write short notes on renaming operator.
30.Discuss the role of relational algebra equivalences in query optimization?
31.Explain the need of triggers in database?
32.Explain domain constraints with an example.
33.Explain Embedded SQL and Dynamic SQL in detail.
34.Explain about ODBC and JDBC.
35.Explain aggregate functions in SQL.
36.Explain about Nested queries and correlated nested queries.
37.Explain set-comparison operators present in sql.
38.Explain the importance of Null values and its usage.
39.Explain about outer joins.
DBMS Important Questions
40.Write notes on active database.
41.What is a query language? What are the parts of SQL language?
42.Explain except operator and use of Group-by clause.
43.Explain with an example in SQL-
a. Unspecified where-clause and use of asterisk.
b. Exists and not exists.
c. Explicit sets and NULLs.
d. Renaming attributes and joined tables.
UNIT-4
44.Briefly discuss about Schema refinement.
45.Explain about functional dependency.
46.Briefly discuss about 1NF,2NF,3NF,BCNF,4NF,5NF with example.
47.Explain the problems related to decomposition.
48.Describe about Functional, Multi-valued and Join Dependencies.
49.Give the Amstrong’s axioms for functional dependencies.
50.What is redundancy?
51.Explain loss less-join decomposition and dependency preserving with suitable
example.
52.Explain update, insertion and deletion anomalies with suitable examples.
UNIT-5
53. What is a schedule? Differentiate between a serial and a complete schedule.
54.What is a transaction? Write the properties of a transaction.
55.Explain how concurrency control can be achieved with locking methods.
56.Compare wait-die deadlock preventions scheme with wait-wound scheme.
57.Explain the lock-based concurrency control mechanism in detail.
DBMS Important Questions
58. Brief note on ACID properties.
59. What are the issues to be addressed in concurrent execution of transactions?
Explain them clearly.
60. Consider the following two transactions
T1: read(A);
read(B)
B=A+B
T2: write(A)
read(B)
Add lock and unlock instructions so that the transactions T1 and T2 observe
two-phase locking protocol. Is it deadlock free?
61.Define lock, 2PL and strict two-phase locking protocol.
62.Explain a) recoverable schedule b) cascading abort c) strict schedule
UNIT-6
63.Explain about conflict serializability.
64.Briefly describe lock management system.
65.Explain about specialized locking techniques.
66.Explain various methods of concurrency control without locking.
67.Explain granularity of locking.
68.Explain briefly about deadlock prevention and deadlock detection.
69.Explain time-stamp based concurrency control.
70.Explain Thomas write rule.
UNIT-7
DBMS Important Questions
71.Explain three phases of recovery from system crash.
72.What are the advantages and the main principles of ARIES recovery algorithm.
73.Discuss the use of transaction log in database recovery.
74.Give a detailed account of Recovery from a system crash.
75.Define check point and its impact on database recovery.
76.What is a transaction rolled back?
77. Explain write ahead log protocol.
78. Explain about media recovery.
