Questions
Syllabus
Qns. By Syllabus

Semester

Subject

Year

Bachelors Level/Fourth Year/Eighth Semester/Science csit/eighth semester/advanced database/syllabus wise questions

B.Sc Computer Science and Information Technology

Institute of Science and Technology, TU

Advanced Database (CSC475)

Year Asked: 2081, syllabus wise question

Advanced Database Models, Systems, and Applications
1.
Write short notes on: a) Map Reduce b) Multimedia database [5]
Distributed Databases, NOSQL Systems, and BigData
1.
Explain different distributed database architectures. What is data fragmentation? [10]
2.
What is the CAP theorem? Explain. [5]
3.
What is Big Data? What are its 3 V’s? [5]
4.
Why do we need spatial databases? What are common types of analysis for spatial data? [5]
Enhanced Entity Relationship Model and Relational Model
1.
Explain different constraints of specialization and generalization. [5]
Object and Object Relational Databases
1.
Explain different object database concepts in brief. What are type constructors? [10]
2.
Explain ODMG object model. [5]
Query Processing and Optimization
1.
Why do we need query optimization in databases? Explain heuristic query optimization with examples. [10]
2.
What is hashing? How does hashing improve database efficiency? [5]
3.
What are the uses of query trees in query processing? Explain. [5]
4.
What are triggers? What are the uses of triggers? [5]