In relational database terminology, a row in a table is precisely called a what? MCQ with Answer and Explanation

Question

Share Report Error

In relational database terminology, a row in a table is precisely called a what?

A. Relation

B. Tuple

C. Field

D. Attribute

Answer: Option B

Solution (By JKSSB Mock Tests)

A single row or record in a relational database table is formally called a tuple.

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

What is a candidate key in a relation?

A. A super key that is minimal

B. A foreign key

C. A key that is not unique

D. Any column that can be used as a primary key

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A candidate key is a minimal super key, meaning no subset of it can uniquely identify a row.

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

Question #2

Which of the following is a valid SQL statement to add a primary key to an existing table?

A. ALTER TABLE table_name ADD CONSTRAINT pk_name PRIMARY KEY (column_name);

B. ALTER TABLE table_name ADD PRIMARY KEY (column_name);

C. ADD PRIMARY KEY ON table_name (column_name);

D. Both A and C

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option D

Explanation:
Both syntaxes are valid: ADD PRIMARY KEY (column) and ADD CONSTRAINT ... PRIMARY KEY (column).

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

Question #3

A table is in Third Normal Form (3NF) if it is in 2NF and has absolutely no non-prime attributes that exhibit what type of dependency?

A. Trivial Dependency

B. Transitive Dependency

C. Join Dependency

D. Partial Dependency

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
Third Normal Form (3NF) requires a relation to be in 2NF with no transitive dependencies, meaning non-prime attributes cannot be determined by other non-prime attributes.

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

Explore All Database Management System (DBMS) MCQs