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

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. Cursor
C. Trigger
D. View
Answer: Option B
Solution (By JKSSB Mock Tests)
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.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
In SQL, what does the 'IS NULL' operator check?
A. Whether a value equals NULL
B. Whether a value is empty string
C. Whether a value is zero
D. Whether a value is missing (null)

Correct Answer: Option D


Explanation:
IS NULL is used to test for NULL values, because NULL is not equal to anything.

This question belongs to: Computer Database Management System (DBMS)
Question #2
RDBMS is based on which model?
A. Relational model
B. Object-oriented model
C. Hierarchical model
D. Network model

Correct Answer: Option A


Explanation:
Relational Database Management System (RDBMS) is based on the relational model proposed by E.F. Codd.

This question belongs to: Computer Database Management System (DBMS)
Question #3
An attribute that can be broken down into smaller, independent sub-parts with independent meanings (such as Name into First_Name and Last_Name) is called a what?
A. Multi-valued Attribute
B. Simple Attribute
C. Composite Attribute
D. Derived Attribute

Correct Answer: Option C


Explanation:
A Composite Attribute is one that can be divided into smaller sub-components or meaningful independent fields.

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