An attribute whose value is computed dynamically from another attribute (such as calculating Age from Date_of_Birth) is called a what? MCQ with Answer and Explanation

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. Base Attribute
C. Stored Attribute
D. Derived Attribute
Answer: Option D
Solution (By JKSSB Mock Tests)
A Derived Attribute is an attribute whose values are not stored physically in the database but are calculated at runtime from other stored attributes.

Discuss this Question (0)

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

Practice More Database Management System (DBMS) Questions

Question #1
What is the purpose of an index in a database?
A. To enforce foreign key constraints
B. To encrypt data
C. To speed up data retrieval operations
D. To compress data

Correct Answer: Option C


Explanation:
Indexes are used to improve the speed of data retrieval queries, at the cost of additional storage and maintenance overhead.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is the purpose of the SQL 'WITH' clause (Common Table Expression)?
A. To create a view
B. To update data
C. To define a temporary result set that can be referenced within a query
D. To delete data

Correct Answer: Option C


Explanation:
A Common Table Expression (CTE) provides a temporary named result set that can be used within a SELECT, INSERT, UPDATE, or DELETE statement.

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which type of subquery executes once for each row evaluated by the outer query, depending on values provided by the outer statement?
A. Scalar Subquery
B. Independent Subquery
C. Correlated Subquery
D. Static Subquery

Correct Answer: Option C


Explanation:
A Correlated Subquery is an inner query that references columns from the outer query, meaning it must be executed repeatedly for each row evaluated by the outer query.

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