MCQOPTIONS
Saved Bookmarks
MCQOPTIONS
This section includes 13 Mcqs, each offering curated multiple-choice questions to sharpen your Rdbms knowledge and support exam preparation. Choose a topic below to get started.
| 1. |
Which of the following functions does an iterator not provide |
| A. | Open() |
| B. | Next() |
| C. | Close() |
| D. | Wait() |
| Answer» E. | |
| 2. |
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 |
| Answer» D. Double algorithm | |
| 3. |
State true or false: Hybrid hash join is partially pipelined on the probe relation |
| A. | True |
| B. | False |
| Answer» B. False | |
| 4. |
State true or false: Join is an inherently blocking operation |
| A. | True |
| B. | False |
| Answer» C. | |
| 5. |
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 |
| Answer» D. Double algorithm | |
| 6. |
Which_of_the_following_functions_does_an_iterator_not_provide$ |
| A. | Open() |
| B. | Next() |
| C. | Close() |
| D. | Wait() |
| Answer» E. | |
| 7. |
State true or false: Hybrid hash join is partially pipelined on the probe relatio? |
| A. | True |
| B. | False |
| Answer» B. False | |
| 8. |
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 |
| Answer» E. | |
| 9. |
State true or false: Sorting is an inherently blocking operation |
| A. | True |
| B. | False |
| Answer» B. False | |
| 10. |
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 |
| Answer» C. Query driven pipeline | |
| 11. |
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 |
| Answer» B. Producer driven pipeline | |
| 12. |
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 |
| Answer» D. Demand driven evaluation | |
| 13. |
If the results of one operation are passed on to the other, it is called as ________ |
| A. | Chain |
| B. | Pipeline |
| C. | Materialized |
| D. | Tree |
| Answer» C. Materialized | |