What is a relation in relational database terms? MCQ with Answer and Explanation

Question

Share Report Error

What is a relation in relational database terms?

A. A key

B. A table

C. A row

D. A column

Answer: Option B

Solution (By JKSSB Mock Tests)

In the relational model, a relation is a table consisting of rows and columns.

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 does the ROLLBACK statement do?

A. Undoes all changes made in the current transaction

B. Saves the changes

C. Starts a new transaction

D. Creates a savepoint

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
ROLLBACK reverts the database to the state it was in at the beginning of the transaction, undoing all changes.

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

Question #2

How many fundamental rules did E.F. Codd define to determine whether a database system qualifies as a true relational database management system?

A. 10 rules

B. 8 rules

C. 12 rules

D. 14 rules

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
E.F. Codd formulated 12 rules (numbered 0 to 11, often called Codd's 12 Rules) to evaluate relational database management systems.

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

Question #3

What is an attribute called when it can hold more than one value for a single entity instance, such as multiple phone numbers for a person?

A. Composite Attribute

B. Multi-valued Attribute

C. Derived Attribute

D. Complex Attribute

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option B

Explanation:
A Multi-valued Attribute is an attribute that can store multiple distinct values for a single entity instance (e.g., skill_set, phone_numbers).

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

Explore All Database Management System (DBMS) MCQs