RDBMS impqns

 

                        

                RDBMS Important Questions                                 Click Here For Answers      

Unit-I

1. Explain Three-level Ansi Sparc Architecture for DBMS?
2. Explain functions of DBMS
3. Explain Advantages and Disadvantages of DBMS
4. Explain ER Model With an Example?
5. Explain Relational Operations in DBMS
6. Explain Functions and role of DBA?
7. Explain Various Data Models?

 

Unit-II

1. Explain types of file organizations?
2. Explain normalization and 1nf,2nf,3nf,4nf ,BCNF?
3. What is an index? Explain types?
4. Explain storage of database on harddisk?
5. Explain different types of keys in DBMS?

 

Unit-III

1. Explain various DDL Commands?
2. Explain Various DML Commands?
3. Explain Sequences in Sql?
4. Explain order by , group by ,aggregate functions ?
5. Explain views  with example?
6. Explain joins with example?

 

Unit-IV

1. Explain two phase locking protocol?
2. Explain Dead lock and prevention techniques ?
3. Explain Optimistic concurrency control techniques ?
4. Explain Database recovery , security ,authorization, Backup?
5. Explain Transaction and ACID properties?
6. Explain Different types of locks (Shared Lock, Exclusive Locks)?

Unit-V

1. Explain the need of Distributed database system/Features of DDBMS?
2. Explain structure of Distributed database system/Architectures of DDBMS?
3. Explain Adv-Disadv of DDBMS?
4. Explain Client Server database?
5. Explain Data Fragmentation Techniques?