How would you achieve this? 

Which two methods can you use?

Your database has three undo tablespaces and the default undo tablespace is not 

autoextensible. Resumable space allocation is not enabled for any sessions in the database 

instance. What is the effect on new transactions when all undo space in the default undo 

tablespace is in use by active transaction? 

manager plan, and a job class? 

RMAN is configured to perform control file autobackup. In which three scenarios do you need media 

recovery? 

intervals. The data file for the USERS tablespace is corrupt. Which command must you execute 

before starting the recovery of this tablespace?

A data file in the USERS tablespace is damaged. Which command must you execute before 

starting the recovery of this tablespace? 

following command to change the value of the LOG_BUFFER initialization parameter. 

ALTER SYSTEM SET LOG_BUFFER=32M; 

What is the outcome of this command? 

SQL> CREATE TABLESPACE tbs1 DATAFILE ‘/u02/oracle/data/tbs01.dbf’ SIZE 50M; 

The u02 file system has 1 GB of free space available. 

What is the outcome? 

NAME TYPE VALUE 

----------------------------- ----------------------- ----------------------------- 

temp_undo_enabled boolean TRUE 

undo_management string AUTO 

undo_retention integer 900 

undo_tablespace string UNDOTBS1 

Which two statements are true?

applications creates a temporary table for a session and performs transactions on it. This 

consumes a lot of undo tablespace and generates lots of redo. Which two actions would you 

take to solve this problem? 

*Level 0 backup on Sunday 

*Cumulative incremental level 1 backup on Monday, Wednesday, and Saturday 

*Differential incremental level 1 backup on Tuesday, Thursday, and Friday 

Which three statements are true about the strategy? 

system. 

Which two would you do to accomplish this? 

intervention from a DBA. Which method would you use?