ITPub博客

175.You are peer reviewing a fellow DBAs backup plan for his NOARCHIVELOG mode database, asshown here:Put the tablespaces in backup mode.Back up the datafiles for all tablespaces.Take the tablespaces out of backup mode.Back up all archived redo logs.Your colleague asks for you to comment on hi...

74.Immediately after adding a new disk to or removing an existing disk from an ASM instance, you findthat the performance of the database goes down initially until the time the addition or removal process iscompleted, and then gradually becomes normal.Which two activities would you perform to mai...

709. A database has three online redo log groups with one member each. A redo log member with thestatus ACTICE is damages while the database is running.What is the first step you should take to solve this problem?A.Attempt to Issue a checkpoint.B.Restart the database using the RESETLOGS option....

401.Which of the following are correct about block media recovery? (Choose all that apply.)A. Physical and logical block corruption is recorded automatically in V$DATABASE_BLOCK_CORRUPTION.B. Logical corruptions are repairable by BMR.C. Physical corruptions are repairable by BMR.D. RMAN can use...

648.Note the following statements that use flashback technology:1. FLASHBACK TABLE <table> TO SCN <scn>;2. SELECT * FROM <table> AS OF SCN 123456;3. FLASHBACK TABLE <table> TO BEFORE DROP;4. FLASHBACK DATABASE TO TIMESTAMP <timestamp>;5. SELECT * FROM <table> VERSIONS AS OF SCN 123456 AND 12399...

45.What is the advantage of setting the ASM-preferred mirror read for the Stretch cluster configuration?A. It improves resync operations.B. This feature enables much faster file opens.C. It improves performance as fewer extent pointers are needed in the shared pool.D. It improves performance by ...

700. Which two statements are true about a duplicate database that is created by using the DUPLICATEcommand in RMAN? (Choose two.)A.It is a copy or a subset of the target database.B.It is opened in RESTRICT mode after a duplicating operation.C.It is created by using backups and archived redo log...

677.What are the prerequisites for performing flashback transactions? (Choose all that apply)A.Supplemental log must be enabledB.Supplemental log must be enabled for the primary keyC.Undo retention guarantee for the database must be configuredD.”EXECUTE “ permission on the DBMS_FLASHBACK packa...

416.To manually configure the SGA components using Oracle Enterprise Manager Memory Advisor, youcan set values for which of the following initialization parameters? (Choose all that apply.)A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF. SORT_AREA_SIZEA...

52.You have the following requirements in relation to the detection of block corruption for your databaseinstance:Check for logical self-consistency of data blocks when modified in memory.Checksums are calculated before and after the block change.Checks are performed for the lost writes to the p...

105.Which statements are true regarding table compression? (Choose all that apply.)A. It saves disk space and reduces memory usage.B. It saves disk space but has no effect on memory usage.C. It incurs extra CPU overhead during DML as well as direct loading operations.D. It incurs extra CPU overh...

410.Which of these recommendations should be followed before capturing a workload? (Choose all thatapply.)A. Make sure your replay database has the same structure as the capture database, except without data.B. Make sure the replay and capture databases are similar in data content.C. Perform a c...

538.Which type of database file is spread across all disks in a disk group?A. All types of files are spread across all disks in the disk group.B. DatafilesC. Redo log filesD. Archived redo log filesE. Control filesAnswer: A参考：http://blog.itpub.net/17013648/viewspace-1312551/

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