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. Stored Attribute
C. Base 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
Which of the following is NOT an advantage of DBMS over traditional file systems?
A. Simpler implementation and lower cost
B. Higher data security
C. Data independence
D. Data redundancy control

Correct Answer: Option A


Explanation:
DBMS generally involves higher initial costs and complexity compared to simple file systems, though it offers better control over redundancy, independence, and security.

This question belongs to: Computer Database Management System (DBMS)
Question #2
What is a subquery in database terminology?
A. A query that executes after the main query terminates.
B. A query that runs on a backup server.
C. A nested SQL query placed completely inside another outer query statement.
D. An error log file.

Correct Answer: Option C


Explanation:
A subquery (or nested query) is an inner SQL SELECT statement embedded within an outer statement (such as a WHERE, FROM, or SELECT clause).

This question belongs to: Computer Database Management System (DBMS)
Question #3
Which of the following is a valid SQL string function?
A. All of the above
B. SUBSTRING
C. REPLACE
D. CONCAT

Correct Answer: Option A


Explanation:
SUBSTRING, CONCAT, and REPLACE are common string functions in SQL.

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