The actual collection of data tuples stored in a table at any specific point in time is called a what? MCQ with Answer and Explanation

Question

Share Report Error

The actual collection of data tuples stored in a table at any specific point in time is called a what?

A. Relation Degree

B. Relation Domain

C. Relation Instance

D. Relation Schema

Answer: Option C

Solution (By JKSSB Mock Tests)

A Relation Instance is the specific collection of data rows (tuples) present in a table at a given moment. It changes frequently as data is modified.

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 EXISTS operator do in SQL?

A. Tests for the existence of rows returned by a subquery

B. Compares two values

C. Performs arithmetic

D. Checks if a value is null

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
EXISTS returns TRUE if the subquery returns at least one row, otherwise FALSE.

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

Question #2

What is the purpose of the COMMIT statement in SQL?

A. To undo all changes made in a transaction

B. To save a point within a transaction

C. To permanently save all changes made in a transaction

D. To start a new transaction

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option C

Explanation:
COMMIT finalizes a transaction, making all changes permanent in the database.

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

Question #3

What is a domain in the context of the relational model?

A. A set of allowed values for an attribute

B. A primary key

C. A foreign key

D. A table name

View Answer & Solution Discuss

Get Complete Subject PDF for Computer

Correct Answer: Option A

Explanation:
A domain defines the set of permissible values that an attribute can take, ensuring data consistency.

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

Explore All Database Management System (DBMS) MCQs