CSC461 Advanced Database

Advanced Database: most repeated questions

Questions that have come up in more than one paper, matched by what they ask rather than exact wording. Most repeated first.

4×Asked in 2081, 2080, 2079, Model question
Explain ODMG object model.Answer coming5
See the wording in each paper
- Explain ODMG object model.TU Board 2081
- What is ODMG object model? What is object definition language?TU Board 2080
- Define ODMG Object model? What is Object Query Language(OQL)?TU Board 2079
- Explain object query language (OQL) with suitable example.Model question
3×Asked in 2082, 2081, Model question
Discuss the two main types of constraints on specializations and generalizations.Answer coming5
See the wording in each paper
- Discuss the two main types of constraints on specializations and generalizations.TU Board 2082
- Explain different constraints of specialization and generalization.TU Board 2081
- Explain specialization and generalization with example.Model question
3×Asked in 2082, 2080, 2079
Explain the features of NOSQL system.Answer coming5
See the wording in each paper
- Explain the features of NOSQL system.TU Board 2082
- What are the characteristics of NOSQL Systems?TU Board 2080
- Why NOSQL system is essential? What are the different characteristics of this system?TU Board 2079
3×Asked in 2081, 2080, Model question
Why do we need query optimization in databases? Explain heuristic query optimization with examples.Answer coming10
See the wording in each paper
2×Asked in 2082, Model question
Discuss the replication and allocation techniques for distributed database design.Answer coming5
See the wording in each paper
- Discuss the replication and allocation techniques for distributed database design.TU Board 2082
- Explain different techniques for distributed database design.Model question
2×Asked in 2081, Model question
Explain different distributed database architectures. What is data fragmentation?Answer coming10
See the wording in each paper
- Explain different distributed database architectures. What is data fragmentation?TU Board 2081
- What is distributed database? Explain data fragmentation techniques in detail with suitable example.Model question
2×Asked in 2080, 2079
Explain different steps in query processingAnswer coming5
See the wording in each paper
- Explain different steps in query processingTU Board 2080
- What is query processing? Differentiate query processing with query optimization.TU Board 2079
2×Asked in 2081, 2080
What is Big Data? What are its 3 V's?Answer coming5
See the wording in each paper
- What is Big Data? What are its 3 V's?TU Board 2081
- Write short notes on: a) Big data b) Information retrievalTU Board 2080
2×Asked in 2080, 2079
What is the concept of active database? What are triggers?Answer coming5
See the wording in each paper
- What is the concept of active database? What are triggers?TU Board 2080
- What is spatial database? Explain the concept of trigger with an example.TU Board 2079
2×Asked in 2081, 2079
What is the CAP theorem? Explain.Answer coming5
See the wording in each paper
- What is the CAP theorem? Explain.TU Board 2081
- Write short notes on a. CAP Theorem b. Deductive databaseTU Board 2079