DBMS-Query Processing and Optimization - Practice Questions

Question 1

The first phase of query processing is

Accepted Answer

Question 2

In which phase of the query processing is the query lexically nd syntactically analysed using prsers to find out any syntax errors ?

Accepted Answer

Question 3

Which of the following represents the result of a query in a query tree ?

Accepted Answer

Question 4

A query execution strategy is evaluated by

Accepted Answer

Question 5

The objective of  query simplifier is

Accepted Answer

Question 6

The success of estimating size and cost of intermediate relational algebra opeations depends on the emphasis of cost minimization depends on the

Accepted Answer

Question 7

The emphasis of cost minimization depends on the

Accepted Answer

Question 8

In which of the query processing are the queries that are incorrectly formulated or are contradictory are rejected ?

Accepted Answer

Question 9

Which of the following query processing method is more efficient ?

Accepted Answer

Question 10

Which of the following cost is the most important cost component to be cosnsidered during the

Accepted Answer