1.
Which initialization parameter must you set to enable automatic archiving?
2.
The listener uses dynamic information about the database and instance it has received through service
registration before using information statically configured. Some services such as heterogeneous services and
external procedures require the use of information statically configured within listener.ora. In order to support
this, which tool could be used to configure the listener statically?
3.
You need to import all definitions of objects belonging to the TS_EMPLOYEES tablespace by using the export
file expdat.dmp.
Which import statement is correct?
4.
You are implementing a very simple TCP/IP network. It rarely changes and you would like to use Oracle
Connection Manager to filter client requests. Which naming method can you use?
5.
Which statement is true regarding Dynamic Service Registration?
6.
Examine the RMAN command:
SWITCH DATAFILE '/DISK3/user_data01.dbf';
Which command do you need to issue before you issue the above command, so that RMAN finds the file in the
restored location of 'DISK2/user_data01.dbf'?
7.
You issue these LSNRCTL commands:
LSNRCTL> SET CURRENT_LISTENER listener01
LSNRCTL> START listener02
What is the result of issuing these commands?
8.
You experience a loss of the disk on which the USER_DATA tablespace data files are stored. You attempt to
recover the data files but discover that the archived redo log file with sequence number 45, which is needed to
perform complete recovery, is invalid. You then begin incomplete recovery-
You receive this prompt:
ORA-00279:change 309012...03/09/01 11:33:56 needed for thread ORA-00289: suggestion : /disk1/archive/
arch_45.rdo
ORA-00280: change 309012 for thread 1 is in sequence #45 Specify log: {=suggested | filename | AUTO
| CANCEL}  
 
What is the correct response?
9.
Which statement is true regarding RMAN allocation of channels?
10.
After running the CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS command, what
has been accomplished?