Bsc paper-III DBMS question bank

DBMS QUESTION BANK FOR FINAL BSC PAPER III CHAPTER WISE

Chapter 1

1.      What is database and DBMS? What are the advantages of DBMS?

2.      What are the different types of DBMS?

3.      What is file system management? What are the advantages and disadvantages of file system management?

4.      Explain different components of database environment with a neat diagram?

5.      Explain all DBMS functions in detail.

6.      Explain costs and risks of database approach.

7.      Explain in detail range of applications.

Chapter 2

1.      What are business rules? How do you discover them and translate them into data model components?

2.      What are the different types of data models? Explain them in detail.

3.      Explain different data models based on degree of abstraction.

4.      What is E-R model? Explain.

5.     

Chapter 3

1.      Explain different keys and integrity constraints available in DBMS.

2.      What are relational set operators? Explain them in detail.

3.      What is a relationship? Explain different types of relationships in detail.

4.      Explain different Codd’s relational database rules.

Chapter 4

1.      What is an entity? What are strong and weak entities and associative entities?

2.      What is an attribute? Explain different types of attributes.

3.      What is a relationship? Explain weak and strong relationships with examples.

4.      What is a degree of relationship? Explain various degrees of relationships in detail.

5.      Explain step wise procedure of how do you develop an ER diagram using an example of tiny college.

6.      What are various database design challenges while developing an ER diagram.

7.      Explain key decisions in physical database design.

Chapter 5

1.      What is normalization?  Explain 1^st, 2^nd and 3^rd normal forms with examples.

2.      Explain Boyce-Codd normal form, 4^th normal form with examples.

3.      Explain denormalization.

Chapter 6

1.      What are super types and sub types? Explain them in detail.

2.      Explain specialization hierarchy and inheritance.

3.      Explain subtype discriminator, disjoint and overlapping constraints and completeness constraints.

4.      Explain entity clustering.

5.      Explain when to use primary keys, composite primary keys and surrogate primary keys.

6.      Explain at least 2 design cases in flexible database design.

7.      Explain attribute inheritance with example.

Chapter 7

1.      Explain different DDL, DML AND DCL commands in detail with examples.

2.      Explain different data types in SQL? Explain the syntax of creating a table.

3.      Explain different SQL constraints and indexes creation with examples.

4.      Explain the complete syntax of select statement? What are the different comparision and logical operators used in it.

5.      Explain some special operators used in SQL.

6.      How do you add and drop columns for a table using advanced data definition commands.

7.      What are order by, group by and having clauses? Explain them with suitable examples.

8.      What are aggregate functions? Explain them in detail with examples.

9.      What are views or virtual tables? Explain their creation.

10.  Explain different types of joins with suitable examples.

Chapter 8

1.      What are relational set operators? Explain with examples.

2.      Explain join operators with using and on clauses.

3.      What are queries? Explain them with where, in, having, any, all and from clauses.

4.      What are correlated sub queries? Explain them with suitable examples.

5.      Explain different SQL functions of various categories with suitable examples.

6.      What are oracle sequences? How are they created and used?

7.      What are updatable views? Explain how are they updated?

8.      What are triggers? Explain with suitable examples

9.      Explain stored procedures with suitable examples.

10.  Explain PL/SQL  processing with cursors with suitable examples.

11.  What are PL/SQL  stored functions?  How are they created?

Chapter 9

1.      What is information system? Explain system development life cycle(SDLC) in detail.

2.      Explain all steps of DBLC in detail. (each step can be an individual question).

3.      Explain database design strategies.

4.      Differentiate between centralized and decentralized design.

Chapter 10

1.      What is a transaction? Explain transaction properties and transaction log.

2.      Explain different problems of concurrency control.

3.      Explain concurrency control with locking methods.

4.      Explain different types of locks and two phase locking system for serializability.

5.      What are dead locks? What are basic techniques to control deadlocks.

6.      Explain concurrency control with time stamping methods.

7.      Explain concurrency control with optimistic methods.

8.      What is database recovery? Explain various techniques used to recover the databases.

Chapter 12

1.      What are the advantages and disadvantages of distributed database management systems.

2.      What are the characteristics of distributed database management systems.

3.      What is distributed processing in distributed databases.

4.      Explain the various components of distributed databases.

5.      Explain in detail various levels of data and process distribution.

6.      Explain various distributed database transparency features.

7.      Explain various levels of distribution transparency and also explain various query cases related to it.

8.      What is transaction transparency? Explain about distributed requests and distributed transactions.

9.      Explain distributed concurrency control. Explain two phase commit protocol.

10.  What is performance transparency and query optimization.

11.  Explain various steps in distributed database design including fragmentation, replication and allocation.

12.  Explain various C.J. DATE’s twelve commandments for distributed databases.

Chapter 13

1.      What is business intelligence? Explain business intelligence architecture and framework. Explain its components.

2.      Differentiate between decision support data and operational data.

3.      Explain decision support database requirements.

4.      What is a data warehouse? What are its characteristics? How do you create it?

5.      Explain the twelve rules to define a data warehouse.

6.      What is OLAP? Explain its four main characteristics.

7.      Explain OLAP architecture in detail.

8.      What is relational OLAP? Explain its extensions.

9.      What is multidimensional OLAP? Differentiate between relational AND multidimensional OLAP.

10.  Explain star schema data modeling technique and its components in detail.

11.  Explain about attribute hierarchies.

12.  Explain star schema representation and performance improving techniques for star schema.

13.  Explain various factors common in implementing data warehouse.

14.  Explain data mining in detail.

15.  Mention the various SQL extensions of OLAP and explain in detail about roll up, cube and material views extensions.