Scribd
Upload
3 views2 pages

Imp QP

The document contains a comprehensive list of questions and topics related to Database Management Systems (DBMS), including applications, SQL functions, normalization, locking mechanisms, and database security techniques. It also covers advanced concepts such as the three-level architecture of DBMS, ER models, CAP theorem, and various file organization methods. Additionally, it includes practical tasks like constructing B+ trees and writing SQL commands for a student database.

Uploaded by

abinayaselvam700
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
3 views2 pages

Imp QP

The document contains a comprehensive list of questions and topics related to Database Management Systems (DBMS), including applications, SQL functions, normalization, locking mechanisms, and database security techniques. It also covers advanced concepts such as the three-level architecture of DBMS, ER models, CAP theorem, and various file organization methods. Additionally, it includes practical tasks like constructing B+ trees and writing SQL commands for a student database.

Uploaded by

abinayaselvam700
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

A

List of any eight applications of DBMS.


What are aggregate functions? And list the aggregate functions supported by SQL?
What is a Derived attributes? Give an example.
What is meant by Normalization?
Difference between shared lock and exclusive lock.
What is Serializable schedule?
Differentiate Active and Passive data dictionaries.
What are the causes of bucket overflow in a hash file organization?
What is SQL injection?
Difference between homogeneous and heterogeneous database.

B AND C

1. Explain the three-level architecture of DBMS with neat diagram. Also explain data
independence.
2. Explain SQL queries with examples: Nested queries, Joins, Group by & Having.
3. Explain ER model concepts (entity, attributes, relationships, constraints) with example.
4. Explain decomposition and discuss lossless join and dependency preservation.
5. Explain two-phase locking protocol (2PL) and its types.
6. Explain deadlock handling techniques: prevention, avoidance, detection.
7. Explain B+ tree insertion and deletion operations with example.
8. Explain dynamic hashing and compare it with static hashing.
9. Explain CAP theorem and its implications in distributed databases.
10. Explain database security techniques: authentication, authorization, encryption.
11. Given R(A,B,C,D,E) with FDs: A→B, BC→D, D→E. Find candidate keys, check
BCNF, decompose.
12. Write relational algebra queries for given schema (Student, Course, Enroll).
13. Explain various operations in relational algebra with examples
14. Write a short notes on Data model and its types.
15. Briefly explain about Database System Architecture with neat diagrams?
16. What is normalization? Explain in detail about all normal forms.
17. Briefly discuss about the Functional Dependency concept
18. Explain about mapping cardinality with an example.
19. Define Deadlock. Outline the deadlock prevention and detection mechanisms.
20. Write a neat sketch explain the state of transaction.
21. Explain the ACID properties of transaction.
22. What is RAID? List the different levels of RAID technology and its features
23. Explain the different types of file organization with its example.
24. Briefly explain about Distributed database with neat diagram?
25. What is NOSQL? What is the need for it? Explain the types of NOSQL database.
26. Construct B+ tree for the following set of key values (2,3,5,7,11,19,23,29,31). The
number of pointers that fit one node is four. After Creation of B+ Tree perform following
series of operations: (a) Insert 9, (b) insert 10, (c) insert 8, (d) delete 23, (e) delete 19
27. Write the DDL,DML,DCL commands for the student database. Which contains supliers
(sid,sname,address), parts (pid,pname,color), catalog(sid,pid,cost).

You might also like