Database Management System (DBMS) MCQs with answers Page - 87

Here, you will find a collection of MCQ questions on Database Management System (DBMS). Go through these questions to enhance your preparation for upcoming examinations and interviews.

To check the correct answer, simply click the View Answer button provided for each question.

Have your own questions to contribute? Click the button below to share your MCQs with others!

+ Add Question

A

Admin • 833.24K Points
Coach

Q. Which view that contains more than one table in the top-level FROM clause of the SELECT statement:

  • (A) join view
  • (B) datable join view
  • (C) updatable join view
  • (D) all of the mentioned

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

A

Admin • 833.24K Points
Coach

Q. 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

Add MCQ in this Category

If you want to share an MCQ question in this category, it's a great idea! It will be helpful for many other students using this website.

Share Your MCQ

Browse Categories

Click on category to learn MCQs of that category.