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;
Detailed Solution & Conceptual Analysis
This question has been retained as-is due to its unique context.
Key Engineering Takeaway
In Database Management, understanding the underlying mechanics of Database Management is critical for writing performant, bug-free production code and passing rigorous technical architecture reviews.