Home » MCQs » DBMS MCQs

DBMS Pipelining Implementation MCQs

DBMS Pipelining Implementation MCQs: This section contains multiple-choice questions and answers on Pipelining Implementation in DBMS.
Submitted by Anushree Goswami, on May 31, 2022

1. Creating pipelines to evaluate multiple operations of a given query requires the creation of a _____ operation that takes the multiple operations of the query and combines them into a single operation, which will create the pipeline.

1. Single
2. Double
3. Triple
4. Multiple

Answer: A) Single

Explanation:

Creating pipelines to evaluate multiple operations of a given query requires the creation of a single operation that takes the multiple operations of the query and combines them into a single operation, which will create the pipeline.

Discuss this Question

---

2. An operation at the top of the pipeline makes repeated requests for tuples from the ____ pipeline.

1. Demand-taken
2. Demand-driven
3. Demand-driver
4. Demand-drive

Answer: B) Demand-driven

Explanation:

An operation at the top of the pipeline makes repeated requests for tuples from the demand-driven pipeline.

Discuss this Question

---

3. We compute the next returning tuples from only the ____ relations if the inputs of the operation are not pipelined.

1. Input
2. Output
3. Both A and B
4. None of the above

Answer: A) Input

Explanation:

We compute the next returning tuples from only the input relations if the inputs of the operation are not pipelined.

Discuss this Question

---

4. In some cases, _____ inputs will also be requested when a ____ operation is performed.

1. Pipe
2. Pipeline
3. Line
4. None

Answer: B) Pipeline

Explanation:

In some cases, pipelined inputs will also be requested when a pipelined operation is performed.

Discuss this Question

---

5. When the operation receives ___ from pipelined inputs, it computes ___ for its output or result and passes them to the parent operation that is above.

1. Tuples
2. Attributes
3. Columns
4. None

Answer: A) Tuples

Explanation:

When the operation receives tuples from pipelined inputs, it computes tuples for its output or result and passes them to the parent operation that is above.

Discuss this Question

---

6. According to demand-driven _____, _____ are built around the tuples requested by the system.

1. Pipeline
2. Pipeset
3. Pipecircle
4. Pipesquare

Answer: A) Pipeline

Explanation:

According to demand-driven pipelines, pipelines are built around the tuples requested by the system.

Discuss this Question

---

7. Each operation is implemented as an ___ in a demand-driven pipeline.

1. Iterator
2. Pointer
3. Array
4. Stack

Answer: A) Iterator

Explanation:

Each operation is implemented as an iterator in a demand-driven pipeline.

Discuss this Question

---

8. It implements a demand-driven pipeline by providing ____ basic functions.

1. One
2. Two
3. Three
4. Four

Answer: C) Three

Explanation:

It implements a demand-driven pipeline by providing three basic functions.

Discuss this Question

---

9. What is/are the function(s) that it implements a demand-driven pipeline by providing three basic functions.

1. open()
2. next()
3. close()
4. All of the above

Answer: D) All of the above

Explanation:

The function(s) that it implements a demand-driven pipeline by providing three basic functions:

1. open()
2. next()
3. close()

Discuss this Question

---

10. Invocation of the ____ function follows each call to the open() function to return the next tuple.

1. open()
2. next()
3. close()
4. None

Answer: B) next()

Explanation:

Invocation of the next() function follows each call to the open() function to return the next tuple.

Discuss this Question

---

---