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?
Pick an option to check yourself, or open the answer below.
Show answer & explanation
Correct answer: B. query optimizer
Explanation
The query optimizer reorders operations, removes redundancy and chooses efficient algorithms and indexes.
More Database Management Systems questions
- Given two tables R1(x,y) and R2(y,z) with 50 and 30 numbers of tuples respectively. Find the maximum number of tuples in the output of natu…
- Given two tables EMPLOYEE (EID, ENAME, DEPTNO) DEPARTMENT (DEPTNO, DEPTNAME) Find the most appropriate statement of the given query : Selec…
- Find the minimum number of tables required for converting the following entity relationship diagram into a relational database.
- Two concurrent executing transactions 1 and T 2 are allowed to update same stock item say ' A ' in an uncontrolled manner. In such scenario…
- Minimal cover of functional F dependency set is
- Identify primary key of table with F functional dependency set