What is a domain in the context of the relational model? MCQ with Answer and Explanation

What is a domain in the context of the relational model?
A. A primary key
B. A foreign key
C. A table name
D. A set of allowed values for an attribute
Answer: Option D
Solution (By JKSSB Mock Tests)
A domain defines the set of permissible values that an attribute can take, ensuring data consistency.

Discuss this Question (0)

No comments yet. Be the first to start the discussion!

Practice More Database Management System (DBMS) Questions

Question #1
An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what?
A. Multi-valued Attribute
B. Stored Attribute
C. Derived Attribute
D. Base Attribute

Correct Answer: Option C


Explanation:
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What type of entity cannot be uniquely identified by its own attributes alone and must rely on a relationship with a parent entity?
A. Associative Entity
B. Weak Entity
C. Abstract Entity
D. Strong Entity

Correct Answer: Option B


Explanation:
A Weak Entity is an entity that does not possess its own primary key and depends on an identifying relationship with a strong (owner) entity.

This question belongs to: Computer Database Management System (DBMS)
Question #3
In SQL, which statement is used to change a user's password?
A. UPDATE USER
B. CHANGE USER
C. ALTER USER
D. MODIFY USER

Correct Answer: Option C


Explanation:
ALTER USER is used in many DBMS to change user attributes, including password. The exact syntax varies by DBMS.

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