Scribd
Upload
4 views2 pages

Module Wise Questions

The document outlines the curriculum for a database management system (DBMS) course, divided into five modules covering various topics. Key subjects include responsibilities of a database administrator, data models, normalization, SQL queries, and transaction management. Each module addresses specific concepts and techniques essential for understanding and working with databases.

Uploaded by

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

Module Wise Questions

The document outlines the curriculum for a database management system (DBMS) course, divided into five modules covering various topics. Key subjects include responsibilities of a database administrator, data models, normalization, SQL queries, and transaction management. Each module addresses specific concepts and techniques essential for understanding and working with databases.

Uploaded by

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

Module 1

1. Responsibilities of dba?
2. Write a short note on
3. ddl,dml,dcl?
Different types of data model?
4. Compare file system with
5. Data abstraction? DBMS?
6. Physical and logical data
7. Advantage of using independence
DBMS
8. Why do we need DBMS? approach
9. DBMS architecture?
10. Three - schema
architecture?
11. Different types of database
system users?

Module 2
1. Different relationship set?
2. Foreign key , candidate key
3. Relationship and relationship set.
4. Tuple relational calculas and domain
relational
5. Different operations used in algebra? calculus?
6. Er diagram.
7. Relational model and entity relational
model?
8. What is an attribute and types of
9. Network data model?
attribute?
10. Project operation.
11. Short note on strong entity and weak entity?
12. Database administrator, data models , schemas and instances.
13. Key constraints?
14. Features of relational database?

Module3
1. Define first normal form and fourth normal form?
2. Define decomposition?
3. Functional dependency?
4. Justify the need for normalization?
5. Join dependency and fifth normal form?
6. Normalization?
7. Multivalued dependency?

Module 4

1. How can you change the data in a table?


2. Correlated nested queries?
3. Group by clause and having clause?
4. What is the use of where clause
5. Sqlbuilt in type?
6. Why we use null value?
7. What is fetch in sql?
8. Sql queries and correlated sub queries?
9. Control structures and loops in sql?
10. Security, looping through arrays, looping through querie results?
11. Join operation?

Module 5

1. Transaction management?
2. Adv and disadv. Of stored procedures?
3. How to use working of the cursors?
4. How passing and returning data to &from stored procedures?
5. Triggers?
6. Difference between TRUNCATE and DELETE?
7. What is atomicity?
8. What is lock?
9. Concept of durability in transaction?
10. What are the different transaction states?
11. What is view?
12. How to store procedures with in a queries?
13. Integrity rules?
14. Built- in function?
15. Transaction properties?
16. How cursor is activated?

You might also like