MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 10 Mcqs, each offering curated multiple-choice questions to sharpen your Database knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
TUPLES_ARE_GENERATED_____________IN_PRODUCER-DRIVEN_PIPELINING,_THEY_ARE_GENERATED__________ON_DEMAND,_IN_DEMAND-DRIVEN_PIPELINING.?$ |
| A. | Lazily, Eagerly |
| B. | Eagerly, Lazily |
| C. | Slowly, Eagerly |
| D. | Eagerly, Slowly |
| Answer» C. Slowly, Eagerly | |
| 2. |
When_two_inputs_that_we_desire_to_pipeline_into_the_join_are_not_already_sorted_it_is_the_______________technique.$ |
| A. | Hash join |
| B. | Buffer join |
| C. | double-pipelined hash join |
| D. | double-pipelined join |
| Answer» E. | |
| 3. |
The iterator maintains the __________ of its execution in between calls so that successive next() requests receive successive result tuples? |
| A. | State |
| B. | Transition |
| C. | Rate |
| D. | Block |
| Answer» B. Transition | |
| 4. |
Each operation in a demand-driven pipeline can be implemented as an ____ that provides the following functions: open(), next(), and close(). |
| A. | Demand |
| B. | Pipeline |
| C. | Iterator |
| D. | All of the mentioned |
| Answer» D. All of the mentioned | |
| 5. |
In a _____________ operations do not wait for requests to produce tuples, but instead generate the tuples eagerly. |
| A. | Demand-driven pipeline |
| B. | Producer-driven pipeline |
| C. | Demand pipeline |
| D. | All of the mentioned |
| Answer» C. Demand pipeline | |
| 6. |
In a _________ the system makes repeated requests for tuples from the operation at the top of the pipeline. |
| A. | Demand-driven pipeline |
| B. | Producer-driven pipeline |
| C. | Demand pipeline |
| D. | All of the mentioned |
| Answer» B. Producer-driven pipeline | |
| 7. |
Pipelines can be executed in |
| A. | 4 |
| B. | 3 |
| C. | 2 |
| D. | 5 |
| Answer» D. 5 | |
| 8. |
______________ allows the algorithm to execute more quickly by performing CPU activity in parallel with I/O activity. |
| A. | Buffering |
| B. | Double buffering |
| C. | Multiple buffering |
| D. | Double reading |
| Answer» B. Double buffering | |
| 9. |
The results of each intermediate operation are created and then are used for evaluation of the next-level operations. This is called |
| A. | Materialized evaluation |
| B. | Expression evaluation |
| C. | Tree evaluation |
| D. | Tree materialization |
| Answer» B. Expression evaluation | |
| 10. |
Pictorial representation of an expression is called |
| A. | Expression tree |
| B. | Operator tree |
| C. | Expression flow |
| D. | Expression chart |
| Answer» C. Expression flow | |