What is the alternative mathematical term used for a 'Table' in a relational database model? MCQ with Answer and Explanation

Question

Share Report Error

What is the alternative mathematical term used for a 'Table' in a relational database model?

A. Tuple

B. Relation

C. Attribute

D. Domain

Answer: Option B

Solution (By JKSSB Mock Tests)

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)

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

In an Entity-Relationship (ER) diagram, attributes are represented using which shape?

A. Diamond

B. Rectangle

C. Ellipse/Oval

D. Square

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
Ellipses or ovals are used to represent attributes (properties) of entities in ER diagrams.

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

Question #2

Share Report

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

A. 2NF

B. BCNF

C. 1NF

D. 3NF

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

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)

Question #3

Share Report

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. Both A and C

D. ADD PRIMARY KEY ON table_name (column_name);

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

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

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

Explore All Database Management System (DBMS) MCQs