A. list incarnation of databaseB. report incarnation of……

单项选择题InwhatstatearethedatafilesofatablespaceafteraTSPITRhasbeensuccessfullycompleted？（）

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.

单项选择题WhyshouldyoubackupaduplicatedtablespaceafteraTSPITRiscomplete？（）

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.

单项选择题WhichofthefollowingidentifiesandcreatesanindextominimizetheDBtimeforaparticularSQLstatement？（）

A. The SGA Tuning Advisor
B. The SQL Access Advisor
C. The SQL Tuning Advisor
D. The Memory Advisor

单项选择题Whenissuingtheduplicatedatabasecommand，youusetheparameterDB_FILE_NAME_CONVERT.Forwhatpurposedoyouusethisparameter？（）

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.

单项选择题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.