E. logfile_convert_directory
Answer: A Section: (none)
Explanation/Reference:
QUESTION 462
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:\\oracle\\auxiliary;
B. recover tablespace users time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\\oracle\\auxiliary; time ,,
10/06/2008:22:42:00 auxiliary destination ,,c:\\oracle\\auxiliary; C. recover tablespace users to point-in-
D. recover tablespace users except time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\\oracle\\auxiliary; E. recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\\oracle\\auxiliary;
Answer: E Section: (none)
QUESTION 463
True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode. A. True B. False
Answer: B Section: (none)
QUESTION 464
When running the tablespace point-in-time command
recover tablespace users until time ,,10/06/2008:22:42:00 auxiliary destination ,,c:\\oracle\\auxiliary; 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 \
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.
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 Section: (none)
QUESTION 465
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 Section: (none)
Explanation/Reference:
QUESTION 466
C. The USERS tablespace has dependent objects in other tablespaces and can not be a part of a TSPITR alone.
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 Section: (none)
QUESTION 467
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. E. The TSPITR will only be successful if the constraint is enabled.
Answer: B Section: (none)
QUESTION 468
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 Section: (none)
D. RMAN will determine if the INDEX_TBS tablespace must also be duplicated and will duplicate it automatically.
Explanation/Reference:
QUESTION 469
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 Section: (none)
QUESTION 470
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 Section: (none)
QUESTION 471
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
Section: (none)
QUESTION 472
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 Section: (none)
QUESTION 473
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 Section: (none)
Explanation/Reference:
QUESTION 474
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.