UNIT-1
1. Difference between Database Systems/DBMS Vs. File System?
#(Understand the advantages and disadvantages of both Database Systems and File System)
2. Explain the database languages (DDL, DML, DCL and TCL)? List the functions of different database
languages with examples?
#(Understand syntax for each function with an example each)
3. Explain Keywords Schema, Instance, Data Independence and Snapshot?
4. What is data Independence? What are the different Types of data Independence?
5. Explain in detail about various Data models used for database design.
(Understand the overview of each Model with an example and Focus more on ER Model)
6. Explain different Data types supported in DBMS?
7. What is data Abstraction? What are the different levels of abstraction?
All Answers are
8. Explain View of Data with a neat sketch? related almost
9. Explain Three Level Schema architecture? similar/Related.
Understand the
10. Briefly explain about architecture (1, 2, 3 Tiers) of DBMS?
concept with clear
11. With neat sketch Explain about Structure or Database Systems. differences so that
(Architecture and Structure of Database systems are different) you can answer any of
these questions
UNIT-2
1. Explain the Database Design process?
2. Explain the terms Entity, Attribute, Weak Entity and strong Entity?
3. Explain the ER model/ER Diagram, list the symbols of ER diagram
4. Explain ER Model components (Entity/Attributes/Relationships with their Types for
each)?
5. Draw the ER diagram for online bank system/Student Management/Online Shopping/etc?
(Any one ER Diagram they will give)
6. Define constraints and types on it with suitable examples?
7. Briefly explain the keys in ER Model?
8. Explain the ER diagram additional features with examples ?
9. Explain the conceptual design with ER model?
UNIT-3
1. Briefly explain about SELECTION, PROJECTION and SUB QUERIES with examples?
2. Explain the Grouping (Group by Clause) using WHERE and HAVING clause?
3. Discuss the Aggregation function with examples?
4. Explain different Types of Joins with syntax and example for each?
# (Understand syntax for each Join with an example query/Venn diagram each)
5. Briefly explain about different operators (Arithmetic, logical, Comparison and SET
OPERATORS) in SQL?
# (Understand syntax for each Operator with an example each)
6. Demonstrate the use of ORDER BY Clause and NULL Values with examples?
UNIT-4
1. Define View? Explain the operations with examples.
2. Explain the architecture of PL/SQL with neat a diagram and explain the structure of PL/SQL
Block?
3. Define Normalization(Schema Refinement)? Explain the Need of Normalisation with
different anomalies (parameters)?
4. Explain 1NF, 2NF and 3NF with Examples?
# (Understand each normalisation with RULES,DECOMPOSE STEPS and example for each)
5. Difference between 3NF & BCNF(Boyce-codd Normal Form) in detail?
6. What is decomposition? Explain the lossless join decomposition and dependency
preserving decomposition types with examples?
7. Explain functional dependency along with rules to be followed? Explain about functional
dependency with types?
UNIT-5
1. Differentiate Between SQL and NoSQL? Explain the Characteristics of NoSQL Databases?
#(Understand the features, advantages and disadvantages of both SQL and No SQL)
2. Explain about different types of Indexes? Analyse Single Level and Multi Level Indexing?
3. Explain about different Types of NoSQL In detail?
# (Understand each TYPE of NOSQL with Use cases, Example Databases and definitions with example—
Each Type is One separate IMP QUES)
4. Briefly Discuss Applications of No SQL?
5. Explain the Data modeling techniques of No SQL?
