Solved

The Following Query Returns a Single Number as a Total

Question 23

Multiple Choice

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;

Correct Answer:

verifed

Verified

Unlock this answer now
Get Access to more Verified Answers free of charge

Related Questions