DBMS_Imp_Questions

 

DBMS Important Questions

Unit-I

1. Explain Advantages and Disadvantages of DBMS?
2. Explain Functions of DBMs?
3. Explain Three-level ANSI-SPARC Architecture
4. Describe Various Data Models?
5. Explain Relational Algebra Operations?
6. Explain File based System and Disadvantages?

 

Unit-II

1. Explain DDL ,DML Commands?
2. a). Order By               

b). Group By       

c). Aggregate Functions

3. a).  Describe  Views with example? 

b)Define Joins and Types of Joins?

4.    a). Explain Trigger with Example?       

b) Explain Control statements in PL/SQL?   

       c) Explain Functions and Procedures? 

            d) Explain cursor with Example?

 

Unit-III

1. What is ER modeling ? Explain Entities & Types ,Relations Ship & Types , Attributes & Types?
2. Define Normalization ? Explain Various Normal Forms?
3. Describe Specialization and generalization ,Aggregation?
4. Problems With ER Models?
5. Draw ER Model For     a)Library Management System       

b) Hospital Management System      c) etc…..

Unit-IV

1. Explain about Deadlock in detail?
2. Describe Timestamp Based Protocol for Concurrency Control?
3. a). Explain Lock and Types of Locks?                 

  b). Explain 2 Phase Locking Protocol?         

c) Explain Optimistic Techniques?

4. a) Granularity of Data item      

b) Recovery Techniques                          

c) Computer Based Controls                  

d) Database Backup and Recovery

e)Properties of a transaction

 

          Visit    degreecsa.blogspot.com