ITPub博客

QUESTIONNO: 87RMAN provides more granular catalog security through which feature?A. Virtual private databaseB. Virtual private catalogC. RMAN virtual databaseD. RMAN secure catalogE. Oracle Database VaultAnswer: BExplanation:About VirtualPrivate CatalogsBy default, all ofthe users...

QUESTION NO: 86What is the purpose of the RMAN recovery catalog? (Choose all that apply.)A. Make backups fasterB. Store RMAN metadataC. Store RMAN scriptsD. Provide the ability to do centralized backup reporting.E. Make recovery fasterAnswer: B,C,DExplanation:Purposeof the Recovery Catal...

QUESTIONNO: 78If a log file becomes corrupted, it may cause the database to stall. How wouldyou correct such a situation?A. Recover the online redo log from backup.B. Delete and re-create the log file.C. Use the alter database clear logfile command to clear the log file.D. Shut down the dat...

QUESTIONNO: 75You are peer reviewing a fellow DBA’s backup plan for his NOARCHIVELOG modedatabase, asshown here:1. Put the tablespaces in backup mode.2. Back up the datafiles for all tablespaces.3. Take the tablespaces out of backup mode.4. Back up all archived redo logs.Your colleague a...

QUESTIONNO: 57The DB_BLOCK_CHECKING initialization parameter is set to OFF.Which block checking would be performed?A. The Oracle database will perform block checking for the index blocks onlyB. The Oracle database will not perform block checking for any of the datablocksC. The Oracle databa...

QUESTION NO: 56What is the effect of increasing the value of the ASM_POWER_LIMIT parameter?A. The number of DBWR processes increasesB. The number of ASMB processes increasesC. The number of DBWR_TO_SLAVES increasesD. The rebalancing operation in an ASM instance completes more quickly, but ...

QUESTIONNO: 53You are managing an ASM instance. You previously issued the followingstatements:ALTER DISKGROUP dg1 DROP DISK disk2;ALTER DISKGROUP dg1 DROP DISK disk3;ALTER DISKGROUP dg1 DROP DISK disk5;You want to cancel the disk drops that are pending for the DG1 disk group.Which statemen...

QUESTIONNO: 44In your database, the RESULT_CACHE_MODE parameter has been set to MANUAL in theinitialization parameter file. You issued the following command:SQL>SELECT /*+ RESULT_CACHE */ sale_category, sum(sale_amt) FROM sales GROUPBY sale_category;Where would the result of this query be st...

QUESTIONNO: 43Which two are the prerequisites to enable Flashback Data Archive? (Choose two.)A. Database must be running in archivelog mode.B. Automatic undo management must be enabled.C. Undo retention guarantee must be enabled.D. The tablespace on which the Flashback Data Archive is create...

QUESTIONNO: 42In which situations will the ASM metadata backup help you recover the ASM diskin a disk group?(Choose all that apply.)A. when one or more file directory paths are accidentally deleted from an ASMdisk groupB. when one of the disks in a disk group is accidentaly unpluggedC. whe...

QUESTIONNO: 40Which two statements are true regarding Health Monitor checks in OracleDatabase 11g? (Choose two.)A. Health Monitor checks can be used to scan the contents of the redo log andarchive logs foraccessibility and corruption.B. Health Monitor checks can be used to verify the integr...

QUESTIONNO: 39Which two prerequisites are needed for performing workload capture and replay?(Choose two.)A. Close all sessions performing queries using database links.B. running the database in shared server modeC. The database on which the workload is replayed has to be a restore of theori...

QUESTIONNO: 36You issued the following command to mount the DATA disk group in restrictedmode:ALTER DISKGROUP data MOUNT RESTRICT;What is the implication of this command?A. The client RDBMS instance can access the file as a read-only file.B. A new disk cannot be added to a disk group.C. A ...

QUESTIONNO: 30Which are the prerequisites for performing flashback transactions on yourdatabase? (Choose all that apply.)A. Undo retention guarantee for the database must be configured.B. Supplemental log must be enabled for the primary key.C. Supplemental log must be enabled.D. Execute per...

QUESTIONNO: 27The application tables owned by the user TEST in a test database need to beexported to the APPS schema in the production database by using Data Pump. Which option of DataPumpImport would you use to accomplish this?A. ownerB. touserC. attachD. remap_schemaAnswer: DExpl...

QUESTIONNO: 25Which statement describes the significance of the CHANGE FAILURE command inRMAN?(Choose all that apply.)A. It is used to change failure priority only for HIGH or LOW priorities.B. It is used to execute the advised repair script.C. It is used to change failure priority only for ...

QUESTIONNO: 22Which statements are true regarding the concept of problems and incidents inthe fault diagnosability infrastructure for Oracle Database 11g? (Choose all that apply.)A. Only the incident metadata and dumps are stored in the Automatic DiagnosticRepository (ADR).B. The p...

QUESTIONNO: 20You are managing an Oracle Database 11g instance and an Oracle Database 10ginstance on the same machine. Both instances use the ASM instance as storage. Which statementregarding the ASM disk group compatibility attributes are true in this scenario? (Choose allthat appl...

QUESTIONNO: 18Which is the source used by Automatic SQL Tuning that runs as part of theAUTOTASK framework?A. SQL statements that are part of the AWR baseline onlyB. SQL statements based on the AWR top SQL identificationC. SQL statements that are part of the available SQL Tuning Set (STS) onl...

QUESTIONNO: 15What are the advantages of variable extent size support for large ASM files?(Choose two.)A. It improves resync operations when the disk comes online after being takenoffline for maintenance purposes.B. It improves performance in the extended cluster configuration by readingfro...