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 : ()