In the context of databases, what is a 'tuple'? MCQ with Answer and Explanation

In the context of databases, what is a 'tuple'?
A. A table itself
B. A row of a table
C. A column of a table
D. A key constraint
Answer: Option B
Solution (By JKSSB Mock Tests)
In relational databases, a tuple is a single row or record of a table.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What is a deadlock in a database?
A. A situation where two or more transactions are waiting indefinitely for each other to release locks
B. A type of backup
C. A system crash
D. A query error

Correct Answer: Option A


Explanation:
Deadlock occurs when each transaction holds a lock that the other needs, resulting in a circular .

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL DISTINCT keyword?
A. To filter rows based on a condition
B. To return only unique rows in the result set
C. To sort the result set
D. To group the results

Correct Answer: Option B


Explanation:
DISTINCT removes duplicate rows from the query result.

This question belongs to: Computer Database Management System (DBMS)
Question #3
The intentional process of introducing redundant data into a normalized database structure to optimize read query performance is called what?
A. Normalization
B. Fragmentation
C. Denormalization
D. Decomposition

Correct Answer: Option C


Explanation:
Denormalization is a strategy applied to normalized databases where redundant data is selectively added to speed up complex read queries by minimizing costly table joins.

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