ITPub博客

177-Q58: Which of the following database objects are not candidates for RMAN image copies?(Choose all that apply.)A. DatafilesB. Online redo log filesC. Flashback log fileD. Archived redo log filesE. Password filesAnswer: B C ERMAN> backup as copy;RMAN-00571: =...

177-Q49: You need to determine the proper target time for TSPITR. What methods can you use to detemine the correct target time?(Choose all that apply.)A. Flashback DatabaseB. Flashback Version QueryC. Flashback Transaction QueryD. Flashback QueryE. Flashback DropF. Flashba...

177-Q46: Identify the statement that is true about Flashback Data Archive.(Choose the best answer.)A. You can use multiple tablespaces for an archive, and each archive can have its own retention time.B. You can have one archive, and for each tablespace that is part of the archive you can ...

177-Q41: As the DBA, you run this command on the recovery catalog database:SQL> GRANT RECOVERY_CATALOG_OWNER to KMSHELT;What privileges do the user KMSHELT have?A. KMSHELT can create users that own virtual private catalogs.B. KMSHELT can immediately use an existsing virtual catalo...

177-Q38: Which of the following DML operations use a significant portion of the PGA?(Choose all that apply.)A. Hash joinsB. Buffers for bulk load operationsC. Full table scansD. Bitmap mergesE. Bitmap createAnswer: A B D E下列DML操作使用PGA的很大一部分吗？...

177-Q37: You are creating a duplicate (auxiliary) database for testing purpose. Which of the following initialization parameter files can you use on the auxiliary database to specify the filenames on the new database?(Choose all that apply.)A. CONTROL_FILE_NAME_CONVERTB. LOG_FILE_NAME_CON...

 177-Q35:You lose all of the datafiles in your TEMP tablespace after the database shuts down. When the database starts again, what happens?A. The database instance will not start and you must re-create the TEMP tablespace in MOUNT mode.B. The database instance will not start and ...

177-Q34: You want to create an archival backup for historical purposes. Where can you store the archival backup?A. To a disk location outside of the recovery area or a tape groupB. To a disk device or the flash recovery areaC. In the flash recovery area onlyD. To a tape device or ...

177-Q33: Which two dynamic performance views can you use to identify files that need to be backed up, regardless of whether you are in ARCHIVELOG mode or NOARCHIVELOG mode?A. V$DATAFILE and V$LOGFILEB. V$DATAFILE and V$TEMPFILEC. V$LOG and V$LOGFILED. V$DATAFILE and V$CONTROLFILE...

177-Q32: You switch from Automatic Memory Management(AMM) to Automatic Shared Memory Management(ASMM) by executing this statement:alter system set memory_target = 0;Next, you restart the instance and set these values:alter system set sga_max_size = 10gb;alter system set sga_target...

177-Q31: After you unregister a database from a recovery catalog, what happens to backup metadata in the recovery catalog?A. You must migrate the backup metadata from the recovery catalog to the control file before unregistering the database from the recovery catalog.B. The backup metadat...

177-Q30: Identify the advantage of recovery an image copy of a datafile during RMAN backup.(Choose all thar apply.)A. During media recovery, fewer incremental updates need to be applied to the last image copy.B. The overhead for the block change tracking file is minimal.C. You do not ...

 177-Q28:You are using TISPITR to recover one or more tablespaces to a previous time in point or back to a specific SCN. What included in the recovery set?(Choose all that apply.)A. A copy of the SYSTEM tablespaceB. A copy of the SYSAUX tablespaceC. A copy of the UNDO tablesp...

177-Q27: You are using the RMAN Data Recovery Advisor functionality. When an error occurs, which of the following commands can you use to monitor and maintain failures?(Choose all that apply.)A. IDENTIFY FAILUREB. REPAIR FAILUREC. CHANGE FAILURED. ADVISE FAILUREE. RESET FAILUR...

177-Q18: You configure AUTOBACKUP to ON in an RMAN session. When will RMAN back up the control file?(Choose all that apply.)A. When you run an RMAN BACKUP commandB. When you run an RMAN ALLOCATE commandC. When you add or drop a table in the SYSTEM tablespaceD. When you change the ...

177-Q16: You want to use Flashback Transaction Query to identify the SQL needed to reserse a transaction in the HR.EMPLOYEES table. Where can you find out the value of the transaction ID column XID to use when you query FLASHBACK_TRANSACTION_QUERY?(Choose the best answer.)A. From the VERSIONS...

 177-Q15:To enable remote connections to the database using the password file, what values should REMOTR_LOGIN_PASSWORDFILE have?(Choose all that apply.)A. NONEB. SHAREDC. EXCLUSIVED. REMOTEAnswer: B C参考：http://docs.oracle.com/cd/B28359_01/server.111/b28320/ini...

177-Q14: Which of the following commands successfully allocates a channel?(Choose all that apply.)A. ALLOCATE CHANNEL T2 TYPE TAPE;B. ALLOCATE CHANNEL T2 TYPE SBT_TAPE;C. ALLOCATE CHANNEL DB2 TYPE DISK PARMS='SBT_LIBRARY=MMV.so';D. ALLOCATE CHANNEL T1 TYPE DISK;Answer: B D...

177-Q13: Which of the following methods can you use to run a job chain?(Choose all that apply.)A. Create and schedule a job with CREATE JOB of type CHAIN.B. Create and schedule a chain using the CREATE_CHAIN procedure.C. Create and schedule a chain using the CREATE_JOB_CHAIN procedure...

177-Q122: Which data dictionary views will display information about the current user's recycle bin? Each correct answer represents a complete solution.(Choose all that apply)A. RECYCLEBINB. DBA_RECYCLEBINC. USER_RECYCLEBIND. RECYCLE_BINAnswer: A C哪些数据字典视图将显示当...