ITPub博客

114.Which tasks can be accomplished using the Enterprise Manager Support Workbench in OracleDatabase 11g? (Choose all that apply.)A. Generate reports on data failure such as data file failures.B. You can track the Service Request (SR) and implement repairs.C. You can package and upload diagnosti...

638.Which three statements are true about persistent configuration? (Choose three.)A. A user cannot set privileges on the persistent lightweight jobsB. Persistent lightweight jobs generate a large amount of metadataC. It is possible to create fully self-contained persistent lightweight jobsD. Th...

685. In your test database:-You are using Recovery Manager (RMAN) to perform incremental backups of your test database-The test database is running in NOARCHIVELOG mode-One of the data files is corrupted-All online redo log files are lost because of a media failureWhich option must you consider...

453.What is the danger associated with stopping a running job by using the STOP_JOB procedure?A. The job will need to be reenabled before it will execute again.B. The job may hold locks on objects referenced within it.C. All jobs within the job group will also be stopped.D. The job may leave dat...

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