UGC NET Computer Science December 2019 | Question 70

Question 70

---

Which of the component module of DBMS does rearrangement and possible ordering of operations, eliminate redundancy in query and use efficient algorithms and indexes during the exceution of a query?

1. 1. query compiler
2. 2. query optimizer
3. 3. Stored data manager
4. 4. Database processor

Answer : 2. query optimizer

Explanation

The query optimizer (called simply the optimizer) is built-in database software that determines the most efficient method for a SQL statement to access requested data. The optimizer choose the plan with the lowest cost among all considered candidate plans (the cost computation accounts for factors of query execution such as I/O, CPU, and communication).

So, option 2 is correct answer

Previous	Next
UGC NET CS December 2019 - Question 69	UGC NET CS December 2019 - Question 71