The range of all permissible and valid values that an attribute can hold is formally defined as its what? MCQ with Answer and Explanation

The range of all permissible and valid values that an attribute can hold is formally defined as its what?
A. Tuple
B. Domain
C. Schema
D. Relation
Answer: Option B
Solution (By JKSSB Mock Tests)
A Domain is the pool of legal, atomic values from which an attribute can take its value.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
Which SQL set operator combines the output of two queries but preserves all duplicate rows without filtering them?
A. INTERSECT
B. MINUS
C. UNION
D. UNION ALL

Correct Answer: Option D


Explanation:
UNION ALL appends the results of multiple SELECT queries together without performing any deduplication, making it faster than UNION.

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. 14 rules
C. 12 rules
D. 8 rules

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 kind of lock allows multiple concurrent transactions to read a database row simultaneously but blocks any transaction from writing to it?
A. Shared Lock
B. Intent Lock
C. Exclusive Lock
D. Deadlock

Correct Answer: Option A


Explanation:
A Shared Lock (S-lock) permits concurrent transactions to read a resource but prevents any modification operations until the lock is released.

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