Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time? MCQ with Answer and Explanation

Question

Which concept represents a temporary workspace in memory used by database engines to fetch, manipulate, and navigate through query rows one at a time?

A. Index

B. View

C. Trigger

D. Cursor

Answer: Option D

Solution (By JKExamLibrary)

A Cursor is a database control structure that allows an application or script to traverse over the records of a query result set row by row.

This question belongs to: Computer Database Management System (DBMS)

Request complete Subject PDF

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1

Share Report

In SQL, which operator is used to combine two conditions and returns true if both are true?

A. OR

B. NOT

C. AND

D. XOR

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
The AND operator returns true only if both conditions are true.

This question belongs to: Computer Database Management System (DBMS)

Question #2

Share Report

A key that consists of more than one attribute to uniquely identify rows in a table is called a what?

A. Composite Key

B. Primary Key

C. Foreign Key

D. Secondary Key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
When a primary key or unique key comprises two or more columns (attributes) combined together, it is known as a Composite Key.

This question belongs to: Computer Database Management System (DBMS)

Question #3

Share Report

An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what?

A. Derived Attribute

B. Base Attribute

C. Multi-valued Attribute

D. Stored Attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

This question belongs to: Computer Database Management System (DBMS)

Explore All Database Management System (DBMS) MCQs