×

Multiple-Choice Questions

Web Technologies MCQs

Computer Science Subjects MCQs

Databases MCQs

Programming MCQs

Testing Software MCQs

Digital Marketing Subjects MCQs

Cloud Computing Softwares MCQs

AI/ML Subjects MCQs

Engineering Subjects MCQs

Office Related Programs MCQs

Management MCQs

More

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





Comments and Discussions!

Load comments ↻





Copyright © 2024 www.includehelp.com. All rights reserved.