The following query returns a single number as a total (or sum)of all blocks,used by all datafiles in the database: ____.
A) SELECT TOTAL(BLOCKS)FROM DBA_DATA_FILES;
B) SELECT SUM(BLOCKS)FROM DBA_DATA_FILES;
C) SELECT AVG(BLOCKS)FROM DBA_DATA_FILES;
D) SELECT COUNT(BLOCKS)FROM DBA_DATA_FILES;

Question

Quizplus · Accepted Answer

The SUM function is used to add up the values in the BLOCKS column of the DBA_DATA_FILES table and return a single number as the total. The other functions (AVG, COUNT, and TOTAL) would not provide the desired result.

The Following Query Returns a Single Number as a Total