What is a database cursor? MCQ with Answer and Explanation

Question
What is a database cursor?
A. A type of index
B. A backup file
C. A user account
D. A control structure that enables traversal over rows in a result set
Answer: Option D
Solution (By JKSSB Mock Tests)
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)
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
In relational database terminology, a row in a table is precisely called a what?
A. Tuple
B. Field
C. Attribute
D. Relation
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A single row or record in a relational database table is formally called a tuple.
This question belongs to: Computer Database Management System (DBMS)
Question #2
In SQL, the WHERE clause is used in:
A. Only INSERT statements
B. Only CREATE statements
C. SELECT, UPDATE, DELETE statements
D. Only SELECT statements
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
WHERE clause filters records in SELECT, UPDATE, and DELETE operations.
This question belongs to: Computer Database Management System (DBMS)
Question #3
Which constraint ensures that every value in a specific column is unique across all rows in that table, but still permits a NULL value?
A. CHECK
B. UNIQUE
C. FOREIGN KEY
D. PRIMARY KEY
Discuss
Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
The UNIQUE constraint prevents duplicate entries in a column. Unlike a Primary Key, a UNIQUE constraint typically allows one or more rows to store NULL values depending on the database engine.
This question belongs to: Computer Database Management System (DBMS)
Explore All Database Management System (DBMS) MCQs
Today's Top Topics
Computer Hardware 430 Operating Systems 510 Programming Languages 0 Cyber Security 269 Database Management System (DBMS) 278
Explore Subjects
Reasoning 2064 Science 4430 Accountancy and Statistics 3179 Economy GK 2220 Computer 5279
Practice Mix
Which national park in Himachal Pradesh is known for its high-altitude grasslands and is a key habitat for the Himalayan Tahr?
Who was the first Indian to be the Coordination Secretary?
Which of the following is an example of an animal cell that lacks a nucleus in its mature form?
What is the primary limitation of configuring a network using a point-to-point Full Mesh Topology as the number of nodes scales high?
Double fertilization in angiosperms was discovered by: