多项选择题

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.

点击查看答案

上一题目录下一题

相关考题

单项选择题

our database instance is running. You are not able to access Oracle Enterprise Manager Database Control because the listener is not started.Which tool or utility would you use to start the listener?（）

A. Oracle Net Manager
B. Listener Control utility
C. Database Configuration Assistant
D. Oracle Net Configuration Assistant

多项选择题

Which three statements must be true before transporting a tablespace from a database on one platform to a database on another platform?（） (Choose three.)

A. Both source and target database must be the same character set
B. Both source and target database must have the same endian format
C. The COMPATIBLE parameter must be the same in the source and target databases.
D. The minimum compatibility level for both the source and target database must be 10.0.0.
E. All read-only and offline data files that belong to the tablespace to be transported must be platform aware.

单项选择题

You want the ability to recovery any time within the last seven days and therefore you configured the recovery window retention policy using the command：
RMAN> CONFIGURE RETENTIOH POLICY TO RKCOVFRY WINDOW OF 7 DAYS；
After configuring the recovery window， you performed the database backup as follows：（）

A. Backup RB1 at log sequence number 12871 on 5th Jan
B. Backup RB2 at log sequence number 15622 on 12th Jan
C. Backup RB3 at log sequence 16721 on 15th Jan
D. On 20th Jan when the log sequence number was 18112 you realize that there Is a need to a point in time at the beginning of the recovery window. You have all an hived redo log files to date.

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？（）

相关考题

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？（）