Buffer Management Questions and Answers

Multiple Choice Questions and Answers

Question 1 : The assignment and management of memory blocks is done by 

(a) Buffer
(b) Buffer manager
(c) DBMS
(d) None of the above

Answer : ()

Question 2 : The process of choosing a suitable execution strategy for processing a query is known as 

(a) Query optimization
(b) Query evaluation
(c) Query execution plan
(d) None of the above

Answer : ()

Question 3 : The process of sending the result of one operator to another operator without creating a temporary relation to hold the  intermediate results is known as

(a) Query
(b) Relation
(c) Pipelining
(d) None of the above

Answer : ()

Question 4 : The process of temporarily writing the intermediate algebra operations is called as

(a) Pipelining
(b) Query execution plan
(c) Materialization
(d) None of the above

Answer : ()

Question 5 : The syntax of the query is checked by 

(a) Parser
(b) Compiler
(c) Assembler
(d) None of the above

Answer : ()

Question 6 : The first phase of query processing is 

(a) Decomposition
(b) Restructuring
(c) Analysis
(d) None of the above

Answer : ()

Question 7 : The result of a query, in a query tree is represented by 

(a) Root node
(b) Leaf node
(c) Intermediary node
(d) None of the above

Answer : ()

Question 8 : Which is false rule from the following:

(a) R U S ≡ S U R
(b) R ∩ S ≡ S ∩ R
(c) R – S ≡ S – R
(d) None of the above

Answer : ()

Question 9 : A query execution strategy is evaluated by 

(a) Execution plan
(b) Query tree
(c) Database catalog
(d) None of the above

Answer : ()

Question 10 : 

(a) Pipelining
(b) Materialization
(c) Tunnelling
(d) None of the above

Answer : ()

DBMS Questions and Answers