Database Management
primer-original-v2mediumDatabase Management07 Joins & Subqueryprimer-original-v2

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.

This question has been retained as-is due to its unique context.

Related Database Management questions

Practice more Database Management questions

PrimerPrep has independently reviewed practice questions and coding exercises — all free.