THEORY EXAMINATION (SEM–VIII) 2016-17 DBMS, DATA MINING AND WAREHOUSE

Section A 
 

Section A contains short questions that test basic concepts of DBMS, relational models, SQL, and data warehouse fundamentals. Students need to give brief definitions and short explanations of database terms and concepts.

Example Questions from Section A:

What is a file processing system?

Explain mapping constraints in ER model.

Define super key.

Explain three-level architecture of DBMS.

List SQL data types.

What are cursors in SQL?

Define relational algebra.

Explain union and intersection in SQL.

What are integrity constraints?

Explain Boyce-Codd Normal Form.

Section B
 

Section B contains medium-length questions that require explanations of SQL queries, normalization, data warehouse models, and distributed databases. Students must describe database design issues and solve query-based problems.

Example Questions from Section B:

Explain features and advantages of SQL.

Write SQL queries based on given schemas.

Discuss insertion, deletion, and update anomalies.

Explain multidimensional data warehouse model.

Explain distributed DBMS and its implementation.

Explain multivalued and join dependency.

Discuss client-server architecture.

Explain 2-tier and 3-tier architecture.

Discuss parallel server hardware options.

Section C

Section C contains long and advanced questions that require detailed explanations of data warehouse concepts, metadata, and decision support systems. Students must solve complex SQL queries and explain system architectures.

Example Questions from Section C:

Explain importance of metadata in data warehouse.

Write SQL queries using nested queries.

Explain mapping of data warehouse to multiprocessor architecture.

Discuss DBMS schemes for decision support.

Explain data warehouse administration techniques.