A. set Flash Recovery Area B. enable Flashback logging C. create FLASHBACK tablespace D. start the database in the ARCHIVELOG mode E. start the database in the NOARCHIVELOG mode
A. Drop User B. Tablespace Space Usage C. Resumable Session Suspended D. Recovery Area Low On Free Space E. SYSTEM Tablespace Size Increment
Evaluate the following command and its output: SQL>SELECT * FROM dba_temp_free_space; TABLESPACE_NAME TABLESPACE_SIZE ALLOCATED_SPACE FREE_SPACE LMTEMP 250609664 101048576 149561088 Which two statements correctly interpret the output?()
A. FREE_SPACE indicates only the space that is currently unallocated. B. ALLOCATED_SPACE indicates only the space currently allocated and in use. C. FREE_SPACE indicates only the space that is currently allocated and available for reuse. D. ALLOCATED_SPACE indicates both the space currently allocated and used,and the space that is available for reuse. E. FREE_SPACE indicates both the space that is currently allocated and available for reuse,and the space that is currently unallocated.