KEMBAR78
Question Bank DBMS | PDF
Scribd
Upload
25 views2 pages

Question Bank DBMS

The document is a question bank for a Database Management Systems (DBMS) course, organized into five units covering fundamental concepts such as database definitions, DBMS architecture, data models, normalization, transactions, and NoSQL databases. Each unit contains multiple questions that require detailed explanations and examples, focusing on both theoretical and practical aspects of DBMS. Topics include advantages of DBMS, relational operations, SQL functions, normalization principles, transaction properties, and comparisons between SQL and NoSQL databases.

Uploaded by

Jayshree Borkar
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
25 views2 pages

Question Bank DBMS

The document is a question bank for a Database Management Systems (DBMS) course, organized into five units covering fundamental concepts such as database definitions, DBMS architecture, data models, normalization, transactions, and NoSQL databases. Each unit contains multiple questions that require detailed explanations and examples, focusing on both theoretical and practical aspects of DBMS. Topics include advantages of DBMS, relational operations, SQL functions, normalization principles, transaction properties, and comparisons between SQL and NoSQL databases.

Uploaded by

Jayshree Borkar
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
You are on page 1/ 2

Question Bank

DBMS
Unit-1
Q.1 What is Database? Explain advantages & applications of DBMS.
Q.2 Explain DBMS architecture in detail.
Q.3 Explain various approaches to build database.
Q.4 Explain Tree schema architecture.
Q.5 What is the data model? Explain entity relation data model and object base
data model.
Q.6 Draw an ER diagram for the college management system. Where entity
must be college student, teacher, etc.
Q.7 List out & describe various types of relational operations.
Q.8Discuss the advantages of DBMS Over File processing System .

Unit-2
Q.1 List and explain Various types of keys in DBMS.
Q.2 Define:-
A. DDL
B. DML
C. DCL
Q.3List out and describe the various types of Aggregation Functions with
suitable example
Q.4Analyze the benefits and limitations of using SQL joins versus subqueries
for data retrieval.

Q.5 Differentiate between order by and group by clause in DBMS.

Q.6 Explain join And its types.

Unit-3
Q.1 Recall the key principles of normalization and explain their significance in
database design.
Q.2 Explain the concept of functional dependencies and transitive dependencies
and how they relate to normalization.
Q.3 Describe the Relational Decomposition and its types with suitable example.
Q.4 Apply normalization techniques to a given set of data to eliminate data
redundancy and ensure data integrity.
Q.5 Explain 1NF,2NF in details .
Q.6Explain BCNF & 4NF.

Unit-4
Q.1 Define Transaction. Explain the ACID properties of Transaction..
Q.2 Describe log based recovery.
Q.3 Explain two phase locking protocol with the help of example..
Q.4 What is serializability? Explain conflict & view serializability.

Unit-5
Q.1 List out and describe the various types NoSQL Databases.
Q.2 Explain CRUD operation in details..
Q.3 What is Data Mining? Explain types of Data Mining.
Q.4 Describe the Features of NoSQL
Q.5 Difference between NoSQL & SQL .

You might also like