adplus-dvertising
frame-decoration

Question

The procedure of choosing a suitable query out of all the queries is classified as

a.

query optimization

b.

parser optimization

c.

processing optimization

d.

all of above

Posted under DBMS

Answer: (d).all of above

Engage with the Community - Add Your Comment

Confused About the Answer? Ask for Details Here.

Know the Explanation? Add it Here.

Q. The procedure of choosing a suitable query out of all the queries is classified as

Similar Questions

Discover Related MCQs

Q. The representation of the query in the form of data structure is classified as

Q. The representation of the queries in the form of data structure graph is classified as

Q. In sort merge strategy, the small sub files sorted are called

Q. Which of the following are steps in query processing?

Q. A relational algebra operation annotated with instructions on how to evaluate it is called _______

Q. A sequence of primitive operations that can be used to evaluate a query are called as __________

Q. The lowest level operator to access data in query processing is _______

Q. Search algorithms that use an index are referred to as _________

Q. Sorting of relations that do not fit in memory is called as _______

Q. A selection of the form satisfying the intersection of all records satisfying individual simple conditions is

Q. A selection of the form satisfying the union of all records satisfying individual simple conditions is

Q. A selection of the form giving all the records not satisfying simple individual conditions is ______

Q. Which of the following can be implemented?

Q. If the results of one operation are passed on to the other, it is called as ________

Q. The result of each intermediate operation are created and then are used for valuation of the next level operations, this evaluation is called as ________

Q. If the system makes repeated requests for tuples from the operation at the top of the table, it is called as _________

Q. If the operations do not wait to produce tuples, then it is called as _________

Q. State true or false: Sorting is an inherently blocking operation

Q. State true or false: Join is an inherently blocking operation

Q. Which of the following techniques does not exist?