DBA_DATA_FILES is used for?

Options
- Look at all the data files
- Look at the characters of a data file
- Both b and d
- Look at the size of a data file


CORRECT ANSWER : Look at the size of a data file

Discussion Board
DBA_DATA_FILES

DBA_DATA_FILES means total size of the data file. The data file size is total of DBA_FREE_SPACE and DBA_SEGMENTS: DBA_DATA_FILES = DBA_FREE_SPACE + DBA_SEGMENTS

DBA_SEGMENTS means used size of the data file.
DBA_FREE_SPACE means free size of the data file.

Prajakta Pandit 02-10-2017 06:30 AM

Comments on your questions

Hi,

I appreciate your question bank - but many answers are not correct - Sorry to say this .

All the best

Murari 11-12-2015 11:00 AM

At my opinion all answers are correct

In dba_data_files are listed all datafiles with size, status and characteristics.

Maksim 01-3-2014 05:21 AM

Write your comments


Enter the code shown above:

(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement