DBMS Question Bank

DBMS

Question Bank: Unit –I

2 Marks Questions

Q1. What is Database and Database Management System?

Q2. Explain various application of DBMS.

Q3. Explain various characteristics of DBMS.

Q4. Explain task of DBA.

Q5. What is schema of database?

Q6. Define Entity and entity set.

Q7.  Define Attributes and types of attributes.

Q8. Define Relationship and relationship set.

Q9. Define Weak Entity and Strong entity

Q10.  List different symbols used in E-R diagram with their meaning.

Q11. Define Keys and types of keys.

Q12.  Write short note on Specialization.

Q13.  Write short note on Generalization.

Q12.  Write short note on Specialization.

Q14.  Write short note on Partition constraints.

Q15.  What is integrity constraints? Explain.

Q16. What are null values? Why they should be avoided.

Q17.  State Armstrong’s axioms for functional dependency.

Q18.  Specify the need of normalization.

5 Marks question

Q1. Explain advantage and disadvantage of DBMS.

Q2. Differentiate logical and physical data independence.

Q3.  Explain different types of data models.

Q4. Design E-R model for Online Book Shop Database System  

i) List the entity sets and their primary keys

ii) Extend the E-R diagram, using Specialization.

Q3. Design E-R model for University Database System  

i) List the entity sets and their primary keys

ii) Extend the E-R diagram, using Aggregation

Q4. Compare DBMS and file processing system.

Q5. Compare RDBMS, ORDBMS and OODBMS.

Q6. Explain Database users and DBA.

Q7.What is Normalization. Explain 1NF, 2NF and 3NF with example.

Q8. Differentiate 3NF and BCNF with example.

Q9. Write Short Note on:-

  a) Legacy Model

  b) R model

Q10. Explain MySQL datatypes.

Q11. Explain DDL, DML, DCL and TCL.

Q12. Explain various aggregate functions available in MySQL.

Q13. What are views? Why they can’t be used for updates.

Q14. Explain the concept of Index in DBMS.

Q15. Consider following relational tables 5

Instructor (ID, name, dept_name)

Student (ID, dept_name, tot_cred)

Takes (ID, course_id, sec_id, semester, year)

Course (course_id, title, dept_name, credits)

Dept. (Dept_id, dept_name)

Solve following quries using SQL

i) Design above relation tables using SQL DDL statements, primary key and foreign key

ii) Find the names and average salaries of all departments whose average salary is greater

     than 42000.

Question Bank: Unit –II

2 Marks Questions

Q1.  Differentiate Structured and Unstructured Data.

Q2. What is NoSQL? Why is it required?

Q3. State various benefits of NoSQL.

Q4. Explain following terms in MongoDB:-

a)       Database

b)       Collection

c)       Document

Q5. Explain with example create and drop database command in MongoDB.

Q6. Explain with example create and drop Collection command in MongoDB.

Q7. Which method is used to sort records in MongoDB?

Q8. Explain Base Model of NoSQL.

Q9. Define ACID properties.

 5 Marks Question

Q1. Compare SQL and NoSQL.

Q2. Define CAP theorem.

Q3. Explain different types of database of NoSQL.

Q4. `Define Different data models of MongoDB.

Q5. Explain benefits of NoSQL.

Q6. Define Key features of MongoDB.

Q7. Explain different data types of MongoDB.

Q8. Explain with example insert, update and delete command in MongoDB.

Q9. Compare find () and Pretty () method in MongoDB.

Q10 Compare skip () and limit () method in MongoDB.

Q11. How index is created in MongoDB.

Q12. Explain various aggregate functions in MongoDB.

Q13. Explain mapReduce in MongoDB.

Question Bank: Unit –III

2-3  Marks Questions

Q1. Define Transaction. Describe ACID properties of transaction.

Q2. Explain different state of a transaction.

Q3. What is the need of concurrent execution of transaction?

Q4. What is Serializable schedule?

Q5. What is recoverable schedule? Why it is desirable/

Q6. Define performance tuning.

Q7. Define query optimization.

Q8. Explain conflict serializable schedule.

Q9. Explain View serializable schedule.

Q10. Explain need of serializability.

Q11. Define Thoma’s write rule.

Q12. Explain  recoverable schedule.

5-8  Marks Questions

Q1.What is serializability. Describe briefly conflict serializability and view serializability .

Q2. Compare serial and serializable schedules.

Q3. Explain testing strategy for conflict serializability and view serializability with suitable example.

Q4. Check whether following schedule is conflict serializable.

T1	T2
Read(A)
Write(A)
	Read(A)
	Write(A)
Read(B)
Write(B)
	Read(B)
	Write(B)

Q5. Explain two phase locking protocol with example. State its advantage and disadvantages.

Q6. Show that the two phase locking protocol ensures conflict serailizability.

Q7. Define concurrency control. Also explain what mechanism used to control concurrent execution of transaction.

Q8. Explain time stamp based protocol with example.

Q9. Define Deadlock. Explain different method for dealing with deadlock problem.

Q10. What is query optimization? Explain.