ITPub博客

420.Automatic PGA Memory Management eliminates the need to manually configure which of thefollowing initialization parameters? (Choose all that apply.)A. SORT_AREA_SIZEB. HASH_AREA_SIZEC. BITMAP_MERGE_AREA_SIZED. CREATE_BITMAP_AREA_SIZEE. PGA_AGGREGATE_TARGETAnswer: ABCDABCD四者都是PGA的组...

420.Automatic PGA Memory Management eliminates the need to manually configure which of thefollowing initialization parameters? (Choose all that apply.)A. SORT_AREA_SIZEB. HASH_AREA_SIZEC. BITMAP_MERGE_AREA_SIZED. CREATE_BITMAP_AREA_SIZEE. PGA_AGGREGATE_TARGETAnswer: ABCDABCD四者都是PGA的组...

564.Your database has experienced a loss of datafile users_01.dbf, which is associated with a ablespacecalled USERS. The database is still running. Which answer properly describes the rder of the steps thatyou would use to recover from this error?1. Shut down the database.2. Take the users_01.db...

23.Which tasks can be accomplished using the DBMS_LOB. SETOPTIONS procedure?A. only encryption and compression settings for all SecureFile LOBsB. only encryption and deduplication settings for only SecureFile CLOBsC. deduplication, encryption, and compression settings for all SecureFile LOBsD. d...

403.To view the results of the most recent Automatic SQL Tuning Advisor task, which sequence shouldyou follow?A. EM Database home page, Software and Support, SQL Advisors, Automatic SQL Tuning AdvisorB. EM Database home page, Software and Support, Advisor Central, SQL Advisors, Automatic SQLTuni...

246.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates aplan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario? (Choose two.)A. The optimizer adds the new plan to the ...

246.The OPTIMIZER_USE_PLAN_BASELINES parameter is set to TRUE. The optimizer generates aplan for a SQL statement but does not find a matching plan in the SQL plan baseline.Which two operations are performed by the optimizer in this scenario? (Choose two.)A. The optimizer adds the new plan to the ...

348.What does the minimize load database parameter mean when backing up a database?A. RMAN will attempt to make the backup run as fast as possible without any IO limitations.B. RMAN will automatically restrict the number of channels in use to one.C. RMAN will spread the backup IO over the total d...

118.Which is the source used by Automatic SQL Tuning that runs as part of the AUTOTASK 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) onlyD. SQL state...

465.NLS parameters can be set using the five methods listed. Put the methods in order from highest tolowest according to Oracles order of precedence:a. Default settingb. Client environment variablec. Explicit ALTER SESSION statementd. Inside SQL functione. Server initialization parameterA. b,...

399.Which of the following is not an advantage of block media recovery (BMR)?A. Reduced MTTR.B. Datafiles remain offline while corrupt blocks are repaired.C. Datafiles remain online while corrupt blocks are repaired.D. A and CAnswer: BLowers the mean time to recover (MTTR) because only blocks...

66.Which two initialization parameters would you set to enable Automatic Shared Memory Management?(Choose two.)A. set SHARED_POOL_SIZE to zeroB. set STATISTICS_LEVEL to BASICC. set SGA_TARGET to a non-zero valueD. set DB_CACHE_SIZE to a non-zero valueE. set STATISTICS_LEVEL to TYPICAL or ALLA...

154.A database is running in ARCHIVELOG mode and regular backups are performed. A user receivesthe following error message:Which is the recommended sequence of operations you need to perform for the query successfully?A. Drop the affected tablespace, re-create the tablespace, restore the datafile...

1. Redolog file是CURRENT的时候被删除, 清除日志时报错：ORA-01624：    SQL> startup mountORA-32004: obsolete or deprecated parameter(s) specified for RDBMS instanceORACLE instance started.Total System Global Area  354914304 bytesFixed Size           ...

418.Using Oracle Enterprise Manager to set SGA pool values manually, for which of the following poolsdoes Oracle EM offer advice to set the value appropriately? (Choose all that apply.)A. DB_CACHE_SIZEB. SHARED_POOL_SIZEC. LARGE_POOL_SIZED. JAVA_POOL_SIZEE. SGA_MAX_SIZEF. SORT_AREA_SIZEAnswe...

409.Which of the following represents the correct sequence of events for Database Replay?A. Capture, analyze, preprocess, replayB. Capture, preprocess, analyze, replayC. Capture, preprocess, replay, analyzeD. Analyze, capture, preprocess, replayE. None of the aboveAnswer: CCapture Preproces...

301.Which command is used to configure RMAN to perform a compressed backup for every backupexecuted?A. BACKUP AS COMPRESSED BACKUPSET DATABASEB. BACKUP AS COMPRESSED COPY OF DATABASEC. CONFIGURE DEVICE TYPE DISK BACKUP TYPE TO COMPRESSED BACKUPSETD. CONFIGURE DEVICE TYPE DISK BACKUP TYPE COMPRE...

583.During recovery, you need to know if log sequence 11 is in the online redo logs, and if so, you need toknow the names of the online redo logs so you can apply them during recovery.Which view or views would you use to determine this information? (Choose all that apply.)A. V$LOGFILEB. V$RECOVE...

521.You notice that a job in a chain has not completed on a nonconstrained RAC database. Which ofthese are valid reasons why that might occur?A. The job priority is 1 and the resource consumer group CPU emphasis allocation is a low percentage.B. The job affinity is to a service and one node in th...

17.The INV_HISTORY table is created using the command: SQL>CREATE TABLE INV_HISTORY (inv_no NUMBER(3), inv_date DATE, inv_amt NUMBER(10,2)) partition by range (inv_date) interval (numtoyminterval(1,'month')) (partition p0 values less than (to_date('01-01-2005','dd-mm-yyyy')),...