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.
Related Notes
BASIC ELECTRICAL ENGINEERING
ENGINEERING PHYSICS THEORY EXAMINATION 2024-25
(SEM I) ENGINEERING CHEMISTRY THEORY EXAMINATION...
THEORY EXAMINATION 2024-25 ENGINEERING MATHEMATICS...
(SEM I) THEORY EXAMINATION 2024-25 ENGINEERING CHE...
(SEM I) THEORY EXAMINATION 2024-25 ENVIRONMENT AND...
Need more notes?
Return to the notes store to keep exploring curated study material.
Back to Notes StoreLatest Blog Posts
Best Home Tutors for Class 12 Science in Dwarka, Delhi
Top Universities in Chennai for Postgraduate Courses with Complete Guide
Best Home Tuition for Competitive Exams in Dwarka, Delhi
Best Online Tutors for Maths in Noida 2026
Best Coaching Centers for UPSC in Rajender Place, Delhi 2026
How to Apply for NEET in Gurugram, Haryana for 2026
Admission Process for BTech at NIT Warangal 2026
Best Home Tutors for JEE in Maharashtra 2026
Meet Our Exceptional Teachers
Discover passionate educators who inspire, motivate, and transform learning experiences with their expertise and dedication
Explore Tutors In Your Location
Discover expert tutors in popular areas across India
Discover Elite Educational Institutes
Connect with top-tier educational institutions offering world-class learning experiences, expert faculty, and innovative teaching methodologies