Skip to content

Padhai By Astra Cloud

Tribhuvan University
BSc CSIT1 2 3 4 5 6 7 8
BCA1 2 3 4 5 6 7 8
BIT1 2 3 4 5 6 7 8
BIM1 2 3 4 5 6 7 8
BBA1 2 3 4 5 6 7 8
BBS1 2 3 4
Pokhara University
BE Computer (PU)1 2 3 4 5 6 7 8
BBA (PU)1 2 3 4 5 6 7 8
National Examinations Board (+2)
+2 Science1 2
+2 Management1 2
Every subject’s units and teaching hours.
TU
- BSc CSIT
- BCA
- BIT
- BIM
- BBA
- BBS
PU
- BE Computer (PU)
- BBA (PU)
NEB
- +2 Science
- +2 Management
Chapter notes, unit by unit.
TU
- BSc CSIT
- BCA
- BIT
- BIM
- BBA
- BBS
PU
- BE Computer (PU)
- BBA (PU)
NEB
- +2 Science
- +2 Management
Past board questions with worked answers.
TU
- BSc CSIT
- BCA
- BIT
- BIM
- BBA
- BBS
PU
- BE Computer (PU)
- BBA (PU)
NEB
- +2 Science
- +2 Management
Answer, check and learn why.
TU
- BSc CSIT
- BCA
- BIT
- BIM
- BBA
- BBS
PU
- BE Computer (PU)
- BBA (PU)
NEB
- +2 Science
- +2 Management
Notices
- GPA calculatorTU, PU and NEB grade points
- SearchEvery note and question

CSC461 Advanced Database

Advanced DatabaseModel question

Why do we need query optimization in databases? Compare heuristic query optimization with cost based query optimization.

10

A worked answer is on its wayMeanwhile, read the Advanced Database notes for this topic.

Discussion

Loading…

More Advanced Database questions

Discuss the reasons for converting SQL queries into relational algebra. What is meant by the term heuristic optimization? Discuss the main heuristics that are…TU Board 208210 List the types of transparency in distributed database. Explain the distributed database architecture.TU Board 208210 How do spatial databases differ from regular databases? What are deductive databases? How do you apply trigger in active database? Illustrate with an example.TU Board 208210 Discuss the replication and allocation techniques for distributed database design.TU Board 20825 State CAP theorem. What is meant by cost based query optimization?TU Board 20825 Explain the features of NOSQL system.TU Board 20825

All Advanced Database old questions