What is a database cursor? MCQ with Answer and Explanation

What is a database cursor?
A. A backup file
B. A control structure that enables traversal over rows in a result set
C. A user account
D. A type of index
Answer: Option B
Solution (By JKExamLibrary)
A cursor allows row-by-row processing of query results, often used in procedural extensions of SQL.

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

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1 Report Error
What is the purpose of the SQL 'IN' operator?
A. To check if a value is between two values
B. To join tables
C. To check if a value matches any value in a list
D. To check if a value is null

Correct Answer: Option C


Explanation:
IN is used to test membership in a set of values.

This question belongs to: Computer Database Management System (DBMS)
Question #2 Report Error
Data that has been processed, organized, structured, or presented in a given context to make it useful is known as what?
A. Field
B. Information
C. Database
D. Raw facts

Correct Answer: Option B


Explanation:
Information is data that has been processed, structured, or organized in a meaningful way to provide context and utility to the user.

This question belongs to: Computer Database Management System (DBMS)
Question #3 Report Error
What is the alternative mathematical term used for a 'Table' in a relational database model?
A. Tuple
B. Attribute
C. Domain
D. Relation

Correct Answer: Option D


Explanation:
In relational model terminology introduced by E.F. Codd, a table is formally referred to as a relation.

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