What statement would display the age of Customers with the alias name as AGE?
Answer options
A
SELECT (SYSDATE - dob) / 365 AS AGE FROM customers;
B
SELECT age FROM customers;
C
SELECT AGE FROM customers;
D
SELECT dob AS AGE FROM customers;
Correct answer: SELECT (SYSDATE - dob) / 365 AS AGE FROM customers;
Explanation
Quick AnswerThe correct answer is SELECT (SYSDATE - dob) / 365 AS AGE FROM customers; because it directly addresses the core logic of Database Management.
Age is calculated from the date of birth using date arithmetic, aliased as AGE.