ITPub博客

229.Which statements are true regarding SecureFile LOBs? (Choose all that apply.)A. The amount of undo retained is user controlled.B. SecureFile LOBs can be used only for nonpartitioned tables.C. Fragmentation is minimized by using variable-sized chunks dynamically.D. SecureFile encryption allow...

359.What view would you use to determine if a given tablespace is fully self-contained for the execution ofa tablespace point-in-time recovery?A. TS_CHECKB. TPITR_CHECKC. TS_PITR_CHECKD. CHECK_TSPITRE. PITR_TS_CHECKAnswer: C

618.You want to set the following initialization parameters for your database instance:LOG_ARCHIVE_DEST_1 = 'LOCATION=/disk1/arch' LOG_ARCHIVE_DEST_2 ='LOCATION=/disk2/arch' LOG_ARCHIVE_DEST_3 = 'LOACTION=/disk3/arch'LOG_ARCHIVE_DEST_4 = 'LOCATION=/disk4/archMANDATORY'Identify the statement tha...

656.The BACKUP_TAPE_IO_SLAVES parameter is set to FALSE for the database instance. Whichstatement is true while performing a tape backup in an RMAN session?A. The tape I/O performed is asynchronousB. The tape buffer is allocated from the System Global Area (SGA)C. The tape buffer is allocated fr...

517.Which of the following are true concerning block media recovery? (Choose all that apply.)A. Any gap in archive logs ends the recovery.B. If a gap in archive logs is encountered, RMAN will search forward for newer versions of the blocks that are not corrupt.C. Uncorrupted blocks from the ...

10.Consider the following scenario for your database:-Backup optimization is enabled in RMAN. The recovery window is set to 7 days in RMAN. The mostrecent backup to disk for the TOOLS tablespace was taken on November 3, 2007.The TOOLS tablespace is read-only since November 4, 2007.On November 23...

704. View the Exhibit and examine the data manipulation language (DML) operations that you performedon the NEWEMP table. Note that the first two updated are not listed by the Flashback Versions Query.What could be the reason?A.The first two updated were not explicitly committed.B.ALTER TABLE ca...

600.Which of the following statements are true about the BACKUP command? (Choose all that apply.)A. The BACKUP command can not be used to make image copies of a datafile.B. The BACKUP command can improve performance by multiplexing backup files.C. The BACKUP can take advantage of the block-change...

423.Which of the following describes how a distributed resumable transaction behaves?A. The resumable setting on the initiating session determines the resumable conditions for the entiredistributed transaction.B. The resumable setting for the initiating instance determines the resumable condition...

523.The NLS_TERRITORY parameter specifies the default conventions to be used for which of thefollowing globalization elements? (Choose all that apply.)A. Date formatB. Decimal characterC. Group separatorD. First day of the monthE. None of the aboveF. All of the aboveAnswer: ABC

292.You decided to use Direct NFS configuration in a non-RAC Oracle installation and created theoranfstab file in /etc. Which two statements are true regarding this oranfstab file? (Choose two.)A. Its entries are specific to a single database.B. It contains file systems that have been mounted by ...

390.Which of these are valid Flashback Database recovery point parameters? (Choose all that apply.)A. SCNB. TimestampC. Named recovery pointD. Transaction IDE. Session IDAnswer: ABCnamed recovery point：链接：http://docs.oracle.com/cd/B19306_01/backup.102/b14192/rpfbdb002.htm#CEGGEFBGCREAT...

49.Which statement about recovering from the loss of a redo log group is true?A. If the lost redo log group is ACTIVE, you should first attempt to clear the log file.B. If the lost redo log group is CURRENT, you must clear the log file.C. If the lost redo log group is ACTIVE, you must restore, pe...

264.Using the LIST command in Recovery Manager (RMAN), which two pieces of information in theRMAN repository can be listed? (Choose two.)A. stored scripts in the recovery catalogB. backups that can be deleted from diskC. backup sets and image copies are obsoleteD. backups that do not have the A...

209.You executed the following commands:SQL> ALTER SESSION SET OPTIMIZER_USE_PENDING_STATISTICS = false; SQL> EXECUTEDBMS_STATS.SET_TABLE_PREFS('SH', 'CUSTOMERS', 'PUBLISH','false'); SQL> EXECUTEDBMS_STATS.GATHER_TABLE_STATS('SH', 'CUSTOMERS');Which statement is correct regarding the above stati...

21.You are managing an Oracle Database 11g instance. You want to create a duplicate database fortesting purpose.What are the prerequisites for performing the active database duplication? (Choose all that apply.)A. The source database backup must be copied over the net for test database.B. The ...

65.An online tablespace, TEST_TBS, is full and you realize that no server-managed tablespace thresholdalerts were generated for the TEST_TBS tablespace. What could be the reason, if the TEST_TBStablespace does not include autoextensible data files?A. TEST_TBS is a small file tablespace.B. TEST_T...

525.What components are present in an ASM instance? (Choose three.)A. SGAB. Database processesC. Database datafilesD. Control filesE. Database parameter file or spfileAnswer: ABE参考：http://blog.csdn.net/rlhua/article/details/12972983http://oraclerac-rips.blogspot.jp/2014/03/asm-componen...

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

472.Which is not a valid locale definition file type?A. LanguageB. Linguistic sortC. CalendarD. TerritoryE. Character setAnswer: C