Chapter 15. Answer Key to Practice Test #1

Question 1

Answers B and E are correct. A is invalid because a date cannot be summed up using SUM. B is correct because a maximum (MAX) value for a group of dates can be found. C is incorrect because aggregation functions cannot be applied in a WHERE clause because it filters rather than groups. D is incorrect because the ...

Get Oracle® 9i SQL Exam Cram™ 2 (Exam 1Z0-007) now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.