RDBMS Semester -3 Important questions 2022

 BcomCA RDBMS Semester -3 important questions

Unit :- 1

 

1. Define Data, Information, Database, DBMS.*

2. What is DBMS? Explain advantages of DBMS over FPS (Database Approach).****

3. Architecture of DBMS-need of three level architecture.**

4. Functions of DBMS.

5. Explain about logical database.**

6. who is DBA? Functions and roles of DBA.****

7. Explain different data models in DBMS.***

8. Explain E.R model.***

9. Draw E.Rmodel on student and college database.**

10.Explain Database Approach.**

Click here for Answers 

Unit :- 2

1. Normalisation? Explain INF, 2NF, 3NF And BCNE. * * * * *

2.File Organisation-Explain different file organizations.

3. Storage of database on hard disk."

4. Relational database integrity-Types of keys in DBMS.***

Click here for Answers 

 

Unit :- 3

1. Explain about various sql commands with examples. ****

2. Operators in SQL.**

3. Explain Data Manipulation Languages (DML)***

4. Explain DDL commands. ***

5. Explain about order by, group by, and having clauses.**

6. Joins in SQL.**

7. Basic structure of SQL****

8. Explain the concept of sequence and its application in SQL with the syntax and examples.***

9. what are views and sequences.**

10. what is view? differentiate view with the table***

Click here for Answers 

Unit :- 4

1. What is lock? Explain two phase lock.*

2. Explain database security and database recovery ***

3. Deadlock and its prevention. *****

4. Database integrity.***

5. What is locking? Explain different locking protocols.****

6. Explain Optimistic concurrency control. ******

7. Database security and Authorisation.***

8. Backup and Recovery Techniques.***

 

Click here for Answers 

 

Unit :- 5

1. Explain need of Distributed DatabaseSystem.***

2. Explain Architecture of DDBMS.**

3. Advantages and Disadvantages of DDBMS.***

4. Need for client server database/ computing.*****

5. Client server Architecture? Advantages and Disadvantages. ****

6.Data Replication? Advantages and Disadvantages. ***

Click here for Answers