RDBMS Questions and Answers – Evaluation of Expressions

This set of RDBMS Multiple Choice Questions & Answers (MCQs) focuses on “Evaluation of Expressions”.

1. If the results of one operation are passed on to the other, it is called as ________
a) Chain
b) Pipeline
c) Materialized
d) Tree
View Answer

Answer: b
Explanation: If the results of one operation are passed on to the other, it is called as Pipelined. This can be used to evaluate several expressions simultaneously.

2. The result of each intermediate operation are created and then are used for valuation of the next level operations, this evaluation is called as ________
a) Chain evaluation
b) Pipeline evaluation
c) Materialized evaluation
d) Demand driven evaluation
View Answer

Answer: c
Explanation: The result of each intermediate operation are created and then are used foe valuation of the next level operations, this evaluation is called as Materialized evaluation. This is not space effective as we need to construct the temporary relations which must be written to a disk.

3. If the system makes repeated requests for tuples from the operation at the top of the table, it is called as _________
a) Demand driven pipeline
b) Producer driven pipeline
c) Query driven pipeline
d) None of the mentioned
View Answer

Answer: a
Explanation: If the system makes repeated requests for tuples from the operation at the top of the table, it is called as demand driven pipeline. Each time an operation receives a request for tuples, it computes the next tuple or tuples to be returned and then returns that tuple.
advertisement
advertisement

4. If the operations do not wait to produce tuples, then it is called as _________
a) Demand driven pipeline
b) Producer driven pipeline
c) Query driven pipeline
d) None of the mentioned
View Answer

Answer: b
Explanation: If the operations do not wait to produce tuples, then it is called as producer driven pipeline. IT does not wait to produce tuples but it produces tuples eagerly.

5. State true or false: Sorting is an inherently blocking operation
a) True
b) False
View Answer

Answer: a
Explanation: Sorting is an inherently blocking operation i.e. output is not given until all the tuples from their input are examined

6. State true or false: Join is an inherently blocking operation
a) True
b) False
View Answer

Answer: b
Explanation: Join is not an inherently blocking algorithm. This is because all the tuples need not be examined to execute the join operation.

7. Which of the following techniques does not exist?
a) Pipelined join technique
b) Left pipelined join technique
c) Right pipelined join technique
d) None of the mentioned
View Answer

Answer: d
Explanation: Pipelined join technique, both left and right are evaluation techniques that can be used to organize data.
advertisement

8. State true or false: Hybrid hash join is partially pipelined on the probe relation
a) True
b) False
View Answer

Answer: a
Explanation: Hybrid hash join is partially pipelined on the probe relation since it can output tuples from the first partition as tuples are received for the probe relation.

9. The usage of two buffers, with one continuing execution of the algorithm while the other is written is called as __________
a) Double execution
b) Multi tasking
c) Double buffering
d) Double algorithm
View Answer

Answer: c
Explanation: The usage of two buffers, with one continuing execution of the algorithm while the other is written is called as Double buffering. This makes the algorithm quicker by performing CPU operations simultaneously with the I/O operations.
advertisement

10. Which of the following functions does an iterator not provide
a) Open()
b) Next()
c) Close()
d) Wait()
View Answer

Answer: d
Explanation: The iterator does not provide the wait() function but it provides open(), next() and close() operations.

Sanfoundry Global Education & Learning Series – RDBMS.

To practice all areas of RDBMS, here is complete set of 1000+ Multiple Choice Questions and Answers.

If you find a mistake in question / option / answer, kindly take a screenshot and email to [email protected]

advertisement
advertisement
Subscribe to our Newsletters (Subject-wise). Participate in the Sanfoundry Certification contest to get free Certificate of Merit. Join our social networks below and stay updated with latest contests, videos, internships and jobs!

Youtube | Telegram | LinkedIn | Instagram | Facebook | Twitter | Pinterest
Manish Bhojasia - Founder & CTO at Sanfoundry
Manish Bhojasia, a technology veteran with 20+ years @ Cisco & Wipro, is Founder and CTO at Sanfoundry. He lives in Bangalore, and focuses on development of Linux Kernel, SAN Technologies, Advanced C, Data Structures & Alogrithms. Stay connected with him at LinkedIn.

Subscribe to his free Masterclasses at Youtube & discussions at Telegram SanfoundryClasses.