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

Question

Share Report Error

In the context of databases, what is a 'tuple'?

A. A table itself

B. A key constraint

C. A column of a table

D. A row of a table

Answer: Option D

Solution (By JKSSB Mock Tests)

In relational databases, a tuple is a single row or record of a table.

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

Which clause is used in SQL queries to filter rows and retrieve only those records that satisfy a specific condition?

A. GROUP BY

B. HAVING

C. ORDER BY

D. WHERE

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
The WHERE clause is used to filter records based on a specified condition before any grouping takes place.

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

Question #2

Share Report

Which of the following is a non-aggregate function in SQL?

A. SUM()

B. COUNT()

C. LENGTH()

D. AVG()

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
LENGTH() (or LEN()) is a string function that returns the length of a string, not an aggregate. SUM, COUNT, AVG are aggregates.

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

Question #3

Share Report

Which normal form requires that every determinant is a candidate key?

A. 2NF

B. 3NF

C. 1NF

D. BCNF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Boyce-Codd Normal Form (BCNF) is a stricter version of 3NF where every determinant must be a candidate key.

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

Explore All Database Management System (DBMS) MCQs