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:

Verified
Correct Answer:
Verified
Related Questions
Q18: A(n)_ flashback query allows you to pull
Q19: Leaving a column value set to NULL
Q20: If you obtain a description of the
Q21: The NULLS _ clause can be used
Q22: Within the realm of a database a
Q25: Provide an example of a query in
Q26: The DUAL table can be queried and
Q27: What is a correlated subquery?
Q27: A(n)_ is not a function,but can be
Q28: The GROUP BY clause column list _