053(七十三）

361、

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

 

362、

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:\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-inD. 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;

 

363、

363.True or false: you can perform an active database duplication when the database is in NOARCHIVELOG mode.
A. True
B. False

 

364、

364.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 "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.

 

365、

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.

 

转载于:https://www.cnblogs.com/huanhuanang/p/5487029.html