327.You have a database with the following tablespaces: SYSTEM, SYSAUX, UNDO, USERS, TEMP.
You want to"roll back" the data in the USERS tablespace to the way it looked yesterday. Which
tablespaces do you need to perform a point-in-time restore operation on in order to complete this task?
(Choose all that apply.)
A. SYSTEM
B. SYSAUX
C. UNDO
D. USERS
E. TEMP
F. This restore is not possible.
345.What view might you use to try to determine how long a particular backup will take?
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SESSION_LONGOPS
375.Over the course of a day, a department performed multiple DML statements (inserts, updates, deletes)
on multiple rows of data in multiple tables. The manager would like a report showing the time, table name,
and DML type for all changes that were made. Which Flashback technology would be the best choice to
produce the list?
A. Flashback Drop
B. Flashback Query
C. Flashback Transaction Query
D. Flashback Versions Query
E. Flashback Table
379.Users notify you that their application is failing every time they try to add new records. Because of
poor application design, the actual ORA error message is unavailable. What might be the problem?
(Choose the best answers.)
A. The application user has exceeded their undo quota.
B. The FLASHBACK GUARANTEE option is set on the undo tablespace.
C. The table is currently being queried by a Flashback Transaction Query operation.
D. The table is currently being queried by a Flashback Versions Query operation.
E. The RETENTION GUARANTEE option is set on the undo tablespace.
395.Which of these formats represents the correct hierarchy for the ADR?
A. <diagnostic_dest>/rdbms/diag/<dbname>/<instname>
B. <diagnostic_dest>/diag/rdbms/<instname>/<dbname>
C. <diagnostic_dest>/diag/rdbms/<dbname>/<instname>
D. None of the above
301.Which command is used to configure RMAN to perform a compressed backup for every backup
executed?
A. BACKUP AS COMPRESSED BACKUPSET DATABASE
B. BACKUP AS COMPRESSED COPY OF DATABASE
C. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSET
D. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRESS
E. BACKUP DATABASE COMPRESS
Answer: C
302.You issue the following command:
RMAN>CONFIGURE BACKUP OPTIMIZATION ON;
What is the result of this command on your backups?
A. An incremental backup strategy will be used automatically.
B. Read-only datafiles will not be backed up as long as backups of those files already exist and those
backups meet established retention criteria.
C. RMAN will configure itself for maximum performance at the cost of CPU.
D. RMAN will configure itself for minimal OS/CPU impact at the cost of time to back up the database.
E. RMAN will automatically compress backups.
Answer: B
303.What is the purpose of the RMAN recovery catalog? (Choose all that apply.)
A. It must be used because all RMAN-related backup and recovery metadata information is contained in
it.
B. It provides a convenient, optional, repository of backup- and recovery-related metadata.
C. It provides the ability to store RMAN scripts for global use by any database that has access to the
repository.
D. It provides a means of storing all RMAN backup sets physically in an Oracle database server.
E. It provides the ability to store backup records for more than a year.
Answer: BCE
304.What privileges must be granted to allow an account to create the recovery catalog? (Choose all that
apply.)
A. RECOVERY_CATALOG_OWNER
B. DBA
C. RESOURCE
D. SELECT ANY DICTIONARY
E. CONNECT
Answer: AC
305.Which command do you use to create a recovery-catalog schema?
A. create recovery catalog
B. create catalog
C. build catalog
D. catalog create
E. mount catalog
Answer: B
306.If you back up a database without connecting to the recovery catalog, which operations will cause the
recovery catalog to be updated? (Choose all that apply.)
A. The next time you back up the database when you are also connected to the recovery catalog and the
target database
B. The next time you are connected to the target database and the recovery catalog database and issue
the resync command
C. The next time you connect RMAN to just the recovery catalog
D. The next time you connect to the recovery catalog and the target database with RMAN
E. Connecting to the recovery catalog and issuing the resync all databases command
Answer: AB
307.You have created a script in the recovery catalog called backup_database. Which of the following
commands would successfully execute that script?
A. run { open script backup_database; run script backup_database }
B. run { engage script backup_database; }
C. run { run script backup_database; }
D. Run { execute script backup_database; }
E. The name backup_database is an invalid name for an RMAN script. Trying to run it from RMAN would
result in an error.
Answer: D
308.In what order would you execute the following steps to create a recovery catalog?
A. Issue the create catalog command.
B. Create the recovery-catalog database.
C. Create the recovery-catalog user.
D. Grant the recovery_catalog_owner privilege to the recovery-catalog user.
E. Issue the register database command from the target database.
F. a, b, c, d, e
G. b, a, d, c, e
H. b, c, d, a, e
I. b, c, d, e, a
J. b, d, c, a, e
Answer: C
309.How would you grant the RVPC user access to specific RMAN database records in the RMAN virtual
private catalog?
A. Issue the grant command from the SYS user (or equivalent) of the target database.
B. Issue the grant command from the SYS user (or equivalent) of the recovery-catalog database.
C. Issue the grant command from the recovery catalog-owning schema user account in the recovery
catalog.
D. Issue the grant command from RMAN when connected to the recovery catalog-owning schema.
E. Issue the grant command from RMAN when connected to the target database.
Answer: D
310.The RVPC user can do which of the following? (Choose all that apply.)
A. Register databases if granted the register database privilege
B. See all databases in the recovery-catalog schema
C. See all database-related metadata in the recovery catalog if they are granted access to that database
D. Unregister databases from the RVPC catalog that were not granted to the RVPC catalog owner with
the grant command
E. Not be connected to with the RMAN command-line catalog parameter for backup or recovery purposes
Answer: AC
311.Given the script
create script db_backup_datafile_script
{backup datafile and 1, and2 plus archivelog delete input;}
What is the result of running this command?
Run {execute script db_backup_datafile_script using 2;}
A. The script will fail since you instructed RMAN to back up only one datafile rather than two.
B. The script will successfully back up datafile 3 without error.
C. The script will fail since it uses a substitution variable which is not supported.
D. The execute script command will prompt for the value of and2 since it's not included in the command.
E. The script will fail because you cannot use the plus archivelog command when backing up database
datafiles.
Answer: D
312.Which is the correct way to connect to both the target database and the recovery catalog from the
RMAN command line? Assume that the target database is called ORCL and that the recovery catalog
database is called RCAT. Also assume that the recovery-catalog owner is called RCAT_OWN. Assume
the environment is configured for the ORCL database. (Choose all that apply.)
A. rman target=/ catalog=/@rcat
B. rman target=/ catalog=rcat_own/rcat_own
C. rman target=/ catalog=rcat_own/rcat_own@RCAT
D. rman target=sys/robert@orcl catalog=rcat_own/rcat_own@RCAT
E. You cannot connect to the target database and the recovery catalog at the same time.
Answer: CD
313.What command would you issue to enable automated backups of control files?
A. alter database controlfile autobackup on
B. alter system controlfile autobackup on
C. configure controlfile autobackup on
D. enable controlfile autobackup
Answer: C
314.Given the following RMAN commands, choose the option that reflects the order required to restore
your currently operational ARCHIVELOG-mode database.
A. restore database;
B. recover database;
C. shutdown immediate
D. startup
E. restore archivelog all;
F. alter database open
G. a, b, c, d, e, f
H. c, b, a, d, e, f
I. c, b, a, d, f
J. c, a, b, d
K. c, a, e, b, d, f
Answer: E
315.Which commands are used for RMAN database recovery? (Choose all that apply.)
A. restore
B. repair
C. copy
D. recover
E. replace
Answer: AD
316.Given a complete loss of your database, in what order would you need to perform the following
RMAN operations to restore it?
A. restore controlfile
B. restore database
C. restore spfile
D. recover database
E. alter database open
F. alter database open resetlogs
G. b, a, c, d, e
H. a, c, b, d, f
I. c, a, b, d, e
J. c, a, b, d, f
K. e, a, b, d, c
Answer: D
318.Which command will restore all datafiles to the date 9/30/2008 at 18:00 hours?
A. restore datafiles until time '09/28/2008:21:03:11';
B. restore database files until time '09/28/2008:18:00:00';
C. restore database until time '09/28/2008:18:00:00';
D. recover database until time '09/28/2008:18:00:00';
E. recover database until timestamp '09/28/2008:18:00:00';
Answer: C
319.What is the end result of these commands if they are successful?
RMAN> show retention policy;
RMAN configuration parameters for database with db_unique_name
ORCL are: CONFIGURE RETENTION POLICY TO REDUNDANCY 1; # default
Backup database tag=gold_copy plus archivelog tag=gold_copy delete input; Backup database
tag=silver_copy plus archivelog tag=silver_copy delete input;
A. Attempting to restore silver_copy will fail.
B. Attempting to restore gold_copy will fail.
C. Both backups will be available for restore without question.
D. Attempting to restore gold_copy may or may not succeed.
E. You will not be able to restore either gold_copy or silver_copy.
Answer: D
320.You are using RMAN to backup your ARCHIVELOG mode database. You have enabled control-file
autobackups. Which files are not backed up during the RMAN backup?
A. Database Datafiles
B. Database Control Files
C. Online redo logs
D. Archived redo logs
E. The database SPFILE
F. None of the above, all these files are backed up.
Answer: C
321.True or false: RMAN offers the equivalent of the SQL command alter database backup controlfile to
trace.
A. True
B. False
Answer: B
322.You need to restore your database back to 9/30/2008 at 18:00. In what order would you run the
following commands to compete this task?
A. restore controlfile until time
`09/30/2008:18:00:00';
B. restore database until time
`09/30/2008:18:00:00';
C. restore spfile until time
`09/30/2008:18:00:00';;
D. recover database until time
`09/30/2008:18:00:00';
E. alter database open resetlogs;
F. alter database open;
G. b, d, e
H. b, d, f
I. c, a, b, d, e
J. c, a, b, d, f
K. a, b, d, e
Answer: A
323.What is the correct order of the following commands if you wanted to restore datafile 4, which was
accidentally removed from the file system?
A. sql 'alter database datafile 4 online';
B. restore datafile 4;
C. recover datafile 4;
D. sql 'alter database datafile 4 offline';
E. startup
F. shutdown
G. a, c, b, d
H. d, b, c, a
I. f, d, b, c, a, e
J. c, a, b, d, f
K. a, b, d, e
Answer: B
324.Your database is up and running and one of your three control files is accidentally erased. You start
RMAN and run the following command:
RESTORE CONTROLFILE FROM AUTOBACKUP;
Which of the following statements is true? (Choose all that apply.)
A. The command restores only the missing control file.
B. The command restores all the control files.
C. The command fails because the database is running.
D. This is the correct way to address this problem.
E. This is not the correct way to address this problem.
Answer: CE
326.Which of the following does the recover command not do?
A. Restore archived redo logs.
B. Apply archived redo logs.
C. Restore incremental backups.
D. Apply incremental backups.
E. Restore datafile images.
Answer: A
328.You have backed up your database using image copies. You have lost the SYSTEM tablespace and
need to restart your database as quickly as possible. What is the correct solution?
A. Restore the SYSTEM tablespace from the last backup set and then recover the database.
B. Restore the SYSTEM tablespace image copy using the restore command and then restore the
database.
C. Use the switch datafile command to instantly switch to the datafile copy, recover the tablespace, and
open the database.
D. The database is not recoverable in this situation with image copies.
E. Manually copy the datafile image copy to the correct location and then manually restore the database
from SQL*Plus.
Answer: C
329.If you find errors in the view V$DATABASE_BLOCK_CORRUPTION with a status of
MEDIA_CORRUPT, what RMAN command would you run to correct the problem?
A. recover lost blocks;
B. recover corrupt blocks;
C. recover media corrupt blocks from list;
D. recover corrupt blocks from list;
E. recover corruption list;
Answer: E
330.What will be the end result of this set of RMAN commands?
shutdown abort
startup mount
restore datafile 4 until time ,,09/30/2008:15:00:00;
recover datafile 4 until time ,,09/29/2008:15:00:00;
alter database open resetlogs;
A. Datafile 4 will be recovered until 9/30/2008 at 15:00 and the database will open.
B. The restore command will fail.
C. The recover command will fail.
D. The alter database open resetlogs command will fail.
E. All these commands will fail because they must be in the confines of a run block.
Answer: D
332.David managed to accidentally delete the datafiles for database called DSL. He called Heber and
Heber tried to help but he managed to delete the control files of the database. Heber called Bill and Bill
saved the day. They are using a recovery catalog for this database. What steps did Bill perform to recover
the database and in what order?
A. Restored the control file with the RMAN restore controlfile command.
B. Mounted the DSL instance with the alter database mount command.
C. Restored the datafiles for the DSL database with the RMAN restore command.
D. Opened the DSL database with the alter database open resetlogs command.
E. Recovered the datafiles for the DSL database with the RMAN recover command.
F. Started the DSL instance.
G. Connected to the recovery catalog with RMAN.
H. a, b, c, d, e, f, g
I. b, c, d, g, f, e, a
J. g, f, a, b, c, e, d
K. c, a, d, b, f, e, g
L. g, f, a, b, e, c, d
Answer: C
334.What command would you use to ensure that backup records in the control file are pointing to actual
physical files on the backup media?
A. crosscheck
B. list backup
C. confirm
D. resync
E. backup validate
Answer: A
335.You have backed up your database twice without connecting to the recovery catalog. What command
do you issue to transfer the control-file metadata to the recovery catalog?
A. synch catalog
B. resync catalog
C. replicate catalog
D. update catalog
E. restore catalog
Answer: B
336.You want to make sure that your database backup does not exceed 10 hours in length. What
command would you issue that would meet this condition?
A. backup database plus archivelog;
ivlog until time 10:00;
B. backup database plus arch
C. backup database plus archivelog timeout 10:00;
D. backup database plus archivelog duration 10:00;
E. backup database plus archivelog timeout 10:00;
Answer: D
338.You run the following commands:
RMAN> list expired backup;
RMAN> delete expired backup;
What will happen to the backup set pieces associated with the backups that appear in the list expired
backup command?
A. They will be renamed.
B. Nothing will happen to them. The backup set pieces do not exist.
C. They will be deleted immediately since they are not in the flash recovery area.
D. You will need to manually remove the physical files listed in the output of the commands.
E. They will become hidden files and removed 10 days later.
Answer: B
339.Why would you run the delete obsolete command? (Choose all that apply.)
A. To remove missing backup set pieces physically from disk
B. To remove metadata related to backup set pieces in the control file and the recovery catalog
C. To mark as deleted records in the control file and the recovery catalog associated with obsolete backup
sets
D. To delete backup set pieces associated with backups that are no longer needed due to retention
criteria
E. To remove old versions of RMAN backups
Answer: CD
340.What does it mean if a backup is expired?
A. The backup set has exceeded the retention criteria set in RMAN and is eligible for removal.
B. The backup set has one or more invalid blocks in it and is not usable for recovery.
C. The backup set contains one or more tablespaces no longer in the database.
D. The backup set contains one or more missing backup set pieces.
E. The backup set is from a previous version of RMAN and was not upgraded.
Answer: D
341.If a backup set is expired, what can you do to correct the problem?
A. Change the retention criteria.
B. Make the lost backup set pieces available to RMAN again.
C. Run the crosscheck command to correct the location for the backup set piece contained in the
metadata.
D. Nothing. The backup set piece is lost forever.
E. Call Oracle support, their assistance is required.
Answer: B
342.How long will this backup be allowed to run?
Backup as compressed backupset duration 2:00 minimize load database ;
A. 2 minutes
B. 2 hours
C. 2 days
D. The command will generate an error.
E. This backup is not constrained by any time limitation.
Answer: B
343.What is the impact of the following backup if it exceeds the duration allowance? (Choose all that
apply.)Backup as compressed backupset duration 2:00 partial minimize load database ;
A. The entire backup will fail. It will not be usable for recovery.
B. The entire backup will fail, but any datafile successfully backed up will be usable for recovery.
C. If this backup fails, subsequent backups will prioritize datafiles not backed up.
D. If this backup fails, an error will be raised and any other commands will not be executed.
E. If this backup fails, no error will be raised and any other commands will be executed.
Answer: B
344.In what view are you likely to see the following output?
SID SERIAL# EVENT SECONDS_IN_WAIT
121 269 RMAN backup & recovery I/O 2
129 415 SQL*Net message from client 63 130 270 SQL*Net message from client
A. V$SESSION_EVENT
B. V$SESSION
C. V$WAITS
D. V$WAITSTAT
E. V$SYSSTAT
Answer: B
346.What is the impact of the results of the output of the following command?
RMAN> report unrecoverable database;
Report of files that need backup due to unrecoverable operations
File Type of Backup Required Name
4 full or incremental C:ORACLEORADATAORCLUSERS01.DBF
A. There are no backup sets with any backups of the users01.dbf datafile.
B. The users01.dbf datafile has had unrecoverable operations occur in it. It will need to be backed up or
some data loss is possible during a recovery.
C. The users01.dbf datafile is corrupted.
D. The users01.dbf datafile backup exceeds the retention criteria.
E. The last backup of the users01.dbf datafile failed and must be rerun.
Answer: D
347.What does the output on this report indicate?
RMAN> report need backup;
RMAN retention policy will be applied to the command
RMAN retention policy is set to redundancy 1
Report of files with less than 1 redundant backups
File #bkps Name
5 0 C:ORACLEORADATAORCLMY_DATA_01.DBF
A. The my_data_01.dbf datafile is corrupted and needs to be restored.
B. The my_data_01.dbf datafile has not yet been backed up. This report does not imply that the data in
the datafile can not be recovered.
C. The my_data_01.dbf datafile has not yet been backed up. This report implies that the data in the
datafile can not be recovered.
D. The my_data_01.dbf datafile no longer meets the retention criteria for backups.
E. Datafile 5 is missing.
Answer: B
348.What does the minimize load database parameter mean when backing up a database?
A. RMAN will attempt to make the backup run as fast as possible without any IO limitations.
B. RMAN will automatically restrict the number of channels in use to one.
C. RMAN will spread the backup IO over the total duration stated in the backup command.
D. RMAN will skip any datafile that currently is involved in an IO operation. RMAN will retry backing up the
datafile later and an error will be raised at the end of the backup if the datafile cannot be backed up.
E. Datafiles will be backed up; those having the lowest current number of IO operations will be backed up
first.
Answer: C
350.Why would you execute the report obsolete command?
A. To list all backups that were no longer available for restore operations
B. To list all backups that had aged beyond the RMAN retention criteria
C. To list all backup set pieces listed in control-file or recovery-catalog metadata that are not on the
backup media
D. To list all datafiles that are no longer part of the database and thus do not need to be backed up
E. To list all archived redo logs that are no longer needed for any database recovery
Answer: B
351.What information does the report schema command not provide? (Choose all that apply.)
A. Size of the datafiles
B. Size of the tempfiles
C. Date of last backup for datafiles and tempfiles
D. Filenames for each datafile
E. Checkpoint SCN associated with the last RMAN backup
Answer: CE
352.If a backup is expired, which of the following is true?
A. It can never be used for a restore/recover operation.
B. Oracle will remove the backup set pieces from the flash recovery area.
C. The backup has been used at least once to restore and recover the database.
D. The backup is no longer valid because of a resetlogs operation.
E. The physical backup set pieces are missing from the media.
Answer: E
353.True or false: tablespace point-in-time recovery is possible only with RMAN.
A. True
B. False
Answer: B
354.Which command is used to begin a tablespace point-in-time recovery?
A. Restore tablespace
B. Recover tablespace
C. Tablespace recover
D. Recover to time
E. recover datafile
Answer: B
355.When youre performing active database duplication, a backup of what kind is required?
A. A current RMAN backup-set backup is required.
B. No backup is required.
C. An RMAN image backup is required.
D. A manual backup is required.
E. A "duplicate" preparatory backup is required.
Answer: B
356.Which of the following commands will perform an active database duplication of the ORCL database
to the ORCL2 database?
A. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 create duplicate target
database to neworcl from active database nofilenamecheck spfile set control_files '
c:oracleoradata
eworclcontrol01.ctl',
'c:oracleoradata
eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata
eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata
eworcl';
B. Set oracle_sid=orcl
rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database nofilenamecheck spfile set
control_files
'c:oracleoradata
eworclcontrol01.ctl', 'c:oracleoradata
eworclcontrol02.ctl' set
db_file_name_convert
'c:oracleoradataorcl','c:oracleoradata
eworcl' set log_file_name_convert
'c:oracleoradataorcl','c:oracleoradata
eworcl';
C. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to
neworcl nofilenamecheck spfile set control_files 'c:oracleoradata
eworclcontrol01.ctl',
'c:oracleoradata
eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata
eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata
eworcl';
D. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert duplicate target database to neworcl
from active database nofilenamecheck spfile set control_files 'c:oracleoradata
eworclcontrol01.ctl',
'c:oracleoradata
eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata
eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata
eworcl';
E. Set oracle_sid=orcl rman target=sys/robert auxname=sys/Robert@orcl2 duplicate target database to
neworcl from active database nofilenamecheck spfile set control_files
'c:oracleoradata
eworclcontrol01.ctl',
'c:oracleoradata
eworclcontrol02.ctl' set db_file_name_convert 'c:oracleoradataorcl','
c:oracleoradata
eworcl' set log_file_name_convert 'c:oracleoradataorcl','c:oracleoradata
eworcl';
Answer: E
357.How many database instances are used during a database-duplication process?
A. One
B. Two
C. Three
D. Four
E. Five
Answer: B
358.What command is used to reset a database to a previous incarnation?
A. reset incarnation
B. incarnation reset
C. reset database to incarnation
D. reset database incarnation
E. reset databse incarnation number
Answer: C
360.When performing a full database disaster recovery with RMAN, in what order would you execute
these steps?
A. Restore the control file from autobackups.
B. Run the RMAN restore and recover command.
C. Restore the database spfile from autobackups.
D. Make the RMAN backup set pieces available.
E. Open the database with the alter database open resetlogs command.
F. Open the database with the alter database open command.
G. a, b, c, d, e, f
H. c, d, a, b, f
I. d, c, a, b, f
J. d, b, d, c, e
K. d, c, a, b, e
Answer: E
361.When performing a database duplication, which duplicate database parameter would you set to
ensure that the online redo logs are created in the correct location?
A. log_file_name_convert
B. convert_log_file_name
C. file_name_convert_log
D. redo_log_file_name_convert
E. logfile_convert_directory
Answer: A
362.Which command would correctly start a TSPITR of the USERS tablespace?
A. recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary ,,c:oracleauxiliary;
B. recover tablespace users time ,,10/06/2008:22:42:00 auxiliary destination ,,c:oracleauxiliary; time ,,
10/06/2008:22:42:00 auxiliary destination ,,c:oracleauxiliary;
C. recover tablespace users to point-in-
D. recover tablespace users except time ,,10/06/2008:22:42:00 auxiliary destination ,,c:oracleauxiliary;
E. recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:oracleauxiliary;
Answer: E
363.True or false: you can perform an active database duplication when the database is in
NOARCHIVELOG mode.
A. True
B. False
Answer: B
364.When running the tablespace point-in-time command
recover tablespace users
until time ,,10/06/2008:22:42:00
auxiliary destination ,,c:oracleauxiliary;
you receive the following error:
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571:
===========================================================
RMAN-03002: failure of recover command at 10/08/2008 16:00:30
RMAN-20202: Tablespace not found in the recovery catalog
RMAN-06019: could not translate tablespace name "USERS"
What is the likely cause of the error?
A. The database is in ARCHIVELOG mode.
B. There is not a current backup of the database available.
C. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR
alone.
D. The USERS tablespace is not eligible for TSPITR because it has invalid objects.
E. The recover tablespace command is incorrect and generates the error.
Answer: B
365.Which of the following restrictions are not true with respect to tablespace point-in-time recovery?
(Choose all that apply.)
A. The target database must be in NOARCHIVELOG mode.
B. No backup is required of the database before you perform a TSPITR.
C. You must have all archived redo logs generated since the last backup up to the point to which you want
to restore the transport set.
D. If you rename a tablespace, you can not perform a TSPITR to any point in time before that rename
operation occurred.
E. If you have tables in tablespace_1 that have associated constraints in tablespace_2, then you must
transport both tablespaces.
Answer: AB
366.If you are going to run a TSPITR recovery, which view will help you to determine which objects will be
lost during the TSPITR?
A. TS_OBJECTS_TO_BE_DROPPED
B. TS_PTTR_OBJECT_DROPPED
C. TS_PITR_OBJECTS_TO_BE_DROPPED
D. TS_OBJECTS_DROPPED
E. TS_DROPPED_OBJECTS
Answer: C
367.Youre performing tablespace point-in-time recovery on a tablespace called USERS. If an object in
that tablespace has a foreign key constraint owned by another object in the INDEX_TBS, which statement
is true?
A. You cannot perform the TSPITR with the constraints enabled.
B. You must perform the TSPITR recovery of both tablespaces for it to be successful.
C. You can perform TSPITR only on the USERS tablespace.
D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it
automatically.
E. The TSPITR will only be successful if the constraint is enabled.
Answer: B
368.When issuing the duplicate database command, you use the parameter
DB_FILE_NAME_CONVERT. For what purpose do you use this parameter?
A. To indicate the location of the auxiliary-instance online redo logs.
B. To indicate the location of the target database datafiles.
C. To indicate the location of the auxiliary-instance control file and online redo logs.
D. To indicate the location of the auxiliary-instance database datafiles.
E. This is not a valid parameter when duplicating a database.
Answer: D
369.Which of the following identifies and creates an index to minimize the DB time for a particular SQL
statement?
A. The SGA Tuning Advisor
B. The SQL Access Advisor
C. The SQL Tuning Advisor
D. The Memory Advisor
Answer: C
370.Why should you back up a duplicated tablespace after a TSPITR is complete?
A. The tablespace cannot be duplicated or restored to any point in time after the duplication.
B. The tablespace cannot be duplicated or restored to the point in time before the duplication.
C. The entire database cannot be restored after a TSPITR, so a backup is required.
D. You cannot bring the tablespace online until its been backed up.
E. There is no requirement to do so, as RMAN will back up the tablespace after the TSPITR.
Answer: B
371.In what state are the datafiles of a tablespace after a TSPITR has been successfully completed?
A. The datafiles have an ONLINE status.
B. The datafiles have an OFFLINE status.
C. The datafiles have an ONLINE status and are in hot backup mode prepared for an online backup.
D. The datafiles have an OFFLINE status and are in hot backup mode for an online backup.
E. The datafiles are in STANDBY mode.
Answer: A
372.Which command do you use to generate a report of database incarnations?
A. list incarnation of database
B. report incarnation of database
C. list database incarnation
D. database incarnation list
E. report database incarnation
Answer: A
373.Which of the following Oracle features utilize the undo tablespace? (Choose all that apply)
A. Flashback Query
B. Flashback Drop
C. Flashback Table
D. Flashback Database
E. Transaction Processing
F. Recycle Bin
Answer: ACE
374.Which of the following statements are true regarding the Recycle Bin? (Choose all that apply.)
A. The Recycle Bin is a physical storage area for dropped objects.
B. The Recycle Bin is a logical container for dropped objects.
C. The Recycle Bin stores the results of a Flashback Drop operation.
D. The objects in the Recycle Bin are stored in the tablespace in which they were created.
Answer: BD
376.A user named Arren is executing this query:
select table_name, operation, undo_sql
from
flashback_transaction_query t,
(select versions_xid as xid
from employees versions between scn minvalue
and maxvalue
where employee_id = 123) e
where t.xid = e.xid;
When the query runs, he receives an ORA-01031: insufficient privileges error. Since the user owns the
employees table, you know that it is not the problem. Which of the following SQL statements will correct
this problem?
A. GRANT SELECT ANY TRANSACTION TO ARREN;
B. GRANT SELECT ON FLASHBACK_TRANSACTION_QUERY TO ARREN;
C. GRANT SELECT_ANY_TRANSACTION TO ARREN;
D. GRANT FLASHBACK TO ARREN;
E. GRANT SELECT ANY VIEW TO ARREN;
Answer: A
377.AUM has been retaining about 15 minutes worth of undo. You want to double the retention period, but
not at the expense of new transactions failing. You decide to alter the system to set the parameter
UNDO_RETENTION=18000. However, AUM still retains only about 15 minutes worth of undo. What is the
problem? (Choose the best answer.)
A. You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.
B. You need to increase the size of the undo tablespace.
C. The undo tablespace is not set to auto-extend.
D. You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.
Answer: C
378.In order to perform Flashback Transaction Query operations, which of these steps are required?
(Choose all that apply.)
A. Ensure that database is running with version 10.1 compatibility.
B. Enable Flashback Logging.
C. Enable Supplemental Logging.
D. Ensure that the database is running with version 10.0 compatibility.
E. Ensure that the database is in ARCHIVELOG mode
Answer: CD
381.Which pseudocolumn could you use to identify a unique row in a Flashback Versions Query?
A. XID
B. VERSIONS_PK
C. VERSIONS_XID
D. VERSIONS_UNIQUE
Answer: C
382.Which of the following can be used in conjunction with a Flashback Versions Query to filter the results?
(Choose all that apply.)
A. A range of SCN values
B. A list of SCN values
C. A starting and ending timestamp
D. Minimum and maximum sequence values
E. A list of sequence values
Answer: AC
383.At the request of a user, you issue the following command to restore a dropped table: flashback table
"BIN$F2JFfMq8Q5unbC0ceE9eJg==$0" to before drop; Later, the user notifies you that the data in the
table seems to be very old and out of date.
What might be the problem?
A. Because a proper range of SCNs was not specified, the wrong data was restored.
B. A proper range of timestamps was not specified, so the wrong data was restored.
C. A previous Flashback Drop operation had been performed, resulting in multiple versions of the table
being stored in the Recycle Bin.
D. Either option A or B could be correct. Not enough information was provided to determine which.
E. None of the above.
Answer: C
384.Which of the following statements is true regarding the VERSIONS BETWEEN clause?
A. The VERSIONS BETWEEN clause may be used in DML statements.
B. The VERSIONS BETWEEN clause may be used in DDL statements.
C. The VERSIONS BETWEEN clause may not be used to query past DDL changes to tables.
D. The VERSIONS BETWEEN clause may not be used to query past DML statements to tables.
Answer: C
385.Which of the following statements is true regarding implementing a Flashback Table recovery?
A. An SCN is never used to perform a Flashback Table recovery.
B. If a significant number of changes have been made to the table, row movement must be enabled.
C. The tablespace must be offline before performing a Flashback Table recovery.
D. Flashback Table recovery is completely dependent on the availability of undo data in the undo
tablespace.
Answer: D
386.You have just performed a FLASHBACK TABLE operation using the following command:
flashback table employees to scn 123456;
The employees table has triggers associated with it. Which of the following statements is true regarding
the state of the triggers during the Flashback Table operation?
A. All the triggers are disabled.
B. All the triggers are enabled by default.
C. Enabled triggers remain enabled and disabled triggers remain disabled.
D. Triggers are deleted when a Flashback Table operation is performed.
Answer: A
387.Which method could be utilized to identify both DML operations and the SQL statements needed to
undo those operations for a specific schema owner? (Choose all that apply.)
A. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows
by START_SCN and TABLE_OWNER.
B. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_SCN and TABLE_OWNER.
C. Query FLASHBACK_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL.
Limit rows by START_TIMESTAMP and TABLE_OWNER.
D. Query DBA_TRANSACTION_QUERY for TABLE_NAME, OPERATION, and UNDO_SQL. Limit rows
by START_SCN and TABLE_OWNER.
Answer: BC
388.Flashback Database relies on which technologies to recover to a point in time?
A. Flashback Data Archive
B. Flashback logs in the flash recovery area
C. FlashbUndo tablespace
D. RMAN command line
E. None of the above
Answer: B
389.The _______ writes the Flashback Database logs in the flash recovery area.
A. FLSH
B. FLDB
C. RVWR
D. RVRW
E. FBDA
Answer: C
390.Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)
A. SCN
B. Timestamp
C. Named recovery point
D. Transaction ID
E. Session ID
Answer: ABC
391.When setting up the Flashback Data Archive, which of these key parameters are required? (Choose
all that apply.)
A. Tablespace name
B. Storage quota
C. Retention
D. Table name
E. Create a default archive
Answer: AC
392.To clean up old records that are in a Flashback Data Archive and are past the retention period, what
must the DBA do?
A. TRUNCATE the archive table.
B. DROP the Flashback Data Archive.
C. Nothing; expired rows are automatically removed.
D. Nothing; expired rows are moved to an archive table.
E. Delete entries from the archive where the metadata date retained is greater than the retention period.
Answer: C
393.Which of the following initialization parameters have been deprecated in Oracle 11g because of the
introduction of the Automatic Workload Repository? (Choose all that apply.)
A. BACKGROUND_DUMP_DEST
B. FOREGROUND_DUMP_DEST
C. CORE_DUMP_DEST
D. USER_DUMP_DEST
E. DIAGNOSTIC_DEST
F. All of the above
Answer: ACD
394.Which of the following statements is true regarding the initialization parameter DIAGNOSTIC_DEST?
The default value is the value of the environment variable $ORACLE_HOME; if $ORACLE_HOME isn't
set,
A. then the default is set to $ORACLE_BASE. The default value is the value of the environment variable
$ORACLE_BASE; if $ORACLE_BASE isn't set,
B. then it is set to $ORACLE_HOME.
C. DIAGNOSTIC_DEST is always equal to $ORACLE_HOME.
D. DIAGNOSTIC_DEST is always equal to $ORACLE_BASE.
Answer: B
396.Which of the following are not fundamental tasks of the Support Workbench? (Choose all that apply.)
A. View long-running SQL workloads
B. View problem details
C. Gather additional diagnostic information
D. Create a Service Request
E. Clean up incident data after upload to Oracle Support
Answer: AE
397.Which of the following tasks does the tool Incident Packaging Service (IPS) perform?
A. Cleans up the ADR by deleting files not associated with an incident uploaded to Oracle Support.
B. Identifies all files associated with a critical error and adds them to a zip file to be sent to Oracle
Support.
C. Automatically opens a Service Request with Oracle Support for each critical error and sends all
relevant files.
D. Displays a high-level view of critical errors on the database home page.
Answer: B
398.Choose the correct order to package and upload data for an incident to Oracle Support.
A. Schedule, create new package, view manifest, view contents
B. Create new package, view manifest, view contents, schedule
C. Schedule, create new package, view contents, view manifest
D. Create new package, view contents, view manifest, schedule
E. None of the above.
Answer: D
400.Which of the following methods can be used to detect block corruption?
A. ANALYZE operations
B. dbv
C. SQL queries that access the potentially corrupt block
D. RMAN
E. All of the above
Answer: E