Examine these SQL statements and their output:
SQL> select name, value
2 the from v $parameter
3 where the name like 'undo %';
NAMEVALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Undo_management AUTO
Undo_tablespace UNDO
The undo_retention appropriately 900
SQL> select contents, retention
2 the from dba_tablespaces
3 where tablespace_name='UNDO';
CONTENTSRETENTION
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
UNDOGUARANTEE
SQL> select blocks, autoextensible maxblocks
2 the from dba_data_files
3 where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
6400 no 0
Which two are true?
A) the Transactions will wait until the free space becomes available in the undo in tablespace when they havefailed to the allocate space
B) The undo in tablespace will grow automatically if there is not enough space to retain The active undo
C) the Inactive undo will be retain for 15 minutes at further
D) Expired undo will be retained as long as possible within the limits of the current size of the undo
In tablespace
E) the Active undo will be retained as long as men by the the transactions

Answer: CE




Examine these SQL statements and their output:
SQL> select name, value
2 the from v $parameter
3 where the name like 'undo %';
NAMEVALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Undo_management AUTO
Undo_tablespace UNDO
The undo_retention appropriately 900
SQL> select contents, retention
2 the from dba_tablespaces
3 where tablespace_name='UNDO';
CONTENTSRETENTION
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
UNDONOGUARANTEE
SQL> select blocks, autoextensible maxblocks
2 the from dba_data_files
3 where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
6400 yes 64000
Which two are true?
A) Inactive UNDO will be retained as long as possible within the limits of the current size of the UNDO
In tablespace.
B) The UNDO in tablespace can grow automatically if there is not enough space to retain The active UNDO.
C) the Active UNDO will be retained as long as men by the transactions.
D) the Inactive UNDO will never be retained for more than 15 minutes.
E) Inactive UNDO will always be retained for 15 minutes at further.

Answer: CE




Examine these SQL statements and their output:
SQL> select name, value
2 the from v $parameter
3 where the name like 'undo %';
NAMEVALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Undo_management AUTO
Undo_tablespace UNDO
The undo_retention appropriately 900
SQL> select contents, retention
2 the from dba_tablespaces
3 where tablespace_name='UNDO';
CONTENTSRETENTION
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
UNDONOGUARANTEE
SQL> select blocks, autoextensible maxblocks
2 the from dba_data_files
3 where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
6400 yes 64000
Which two are true?
A) Inactive expired UNDO will be retained as long as possible within the limits of the current size of the UNDO in tablespace.
B) The UNDO in tablespace can grow automatically if there is not enough space to retain The active UNDO.
C) the Active UNDO will be retained as long as men by the transactions.
D) the Inactive expired UNDO will never be retained for more than 15 minutes.
E) Inactive expired UNDO will always be retained for 15 minutes at further.

Answer: the BC




Examine these SQL statements and their output:
SQL> select name, value
2 the from v $parameter
3 where the name like 'undo %';
NAMEVALUE
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
Undo_management AUTO
Undo_tablespace UNDO
The undo_retention appropriately 900
SQL> select contents, retention
2 the from dba_tablespaces
3 where tablespace_name='UNDO';
CONTENTSRETENTION
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
UNDOGUARANTEE
SQL> select blocks, autoextensible maxblocks
2 the from dba_data_files
3 where tablespace_name='UNDO';
BLOCKS AUT MAXBLOCKS
-- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- -- --
6400 no 0
Which three are true?
A) Active UNDO took be retained for 15 or more minutes.
B) the Inactive UNDO took be retained for 15 or more minutes.
C) The UNDO in tablespace is guaranteed to be retained for (.
D) Expired UNDO took be retained for 15 or more minutes.
E) UNDO Blocks are retained for 900 days.
F) UNDO segments are guaranteed to be retained for (.

Answer: ABD