ITPub博客

（77）You have three production databases,HRDB,FINDB,and ORGDB,that use the same ASM instance.At the end of the day,while all three production database instances are running,you execute the following command on the ASM instance:SQL>shutdown immediate;What is the result of executing this c...

（76）Identify three key features of ASM.(Choose three.)A. file stripingB. allocation unit mirroringC. automatic disk rebalancingD. automatic file size incrementE. automatic undo management答案：（A、B、C）

（75）View the Exhibit.As shown in the diagram,in-memory statistics are transferred to the disk at regular intervals.Which background process performs this activity?A. CKPTB. SMONC. MMOND. DBWR答案：（C）

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

（73）You are using Recovery Manager（RMAN）to perform backups.In which three situations would you perform a compressed backup?(Choose three.)A. You are backing up to tape and your tape device performs its own compression.B. You are making image copies,and you have not enabled tablespace ...

（72）You have 100 segments in the USERS tablespace.You realize that the USERS tablespace is running low on space.You can use Segment Advisor to_____.A. identify the segments that you should shrinkB. modify the storage parameters for the tablespaceC. automatically shrink the segments ...

（71）The Automatic Database Diagnostic Monitor（ADDM）analysis runs every 60 minutes on your database.Your database is facing a series of interrelated problems over a period of two hours.You need to ensure that the ADDM analysis is run over a time span of two hours in future.What would you d...

（70）You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace:ALTER TABLE employees SHRINK SPACE CASCADE;Which statement is correct in this scenario?A. The EMPLOYEES table will be changed to read-only mode during the shrink operation...

（69）The EMP table exists in your schema.You want to execute the following query:SELECT ename,sal FROM emp AS OF TIMESTAMP(SYSTIMESTAMP-INTERVAL'6'MINUTE) WHERE ename='ALLEN';What are the minimum requirements for the statement to execute successfully?(Choose all that apply)A. ARCHIVELOG ...

（68）You have three temporary tablespace groups named G1,G2,and G3 in your database.You are creating a new temporary tablespace as follows:CREATE TEMPORARY TABLESPACE TEMP1 TEMPFILE'/u1/data/temp1.dbf'SIZE 10M TABLESPACE GROUP '';Which statement regarding the above command is correct?...

（67）On which two database objects can the VERSIONS clause of the Flashback Versions Query be used?(Choose two.)A. fixed tablesB. heap tablesC. external tablesD. temporary tablesE. Index-Organized Tables(IOTs)答案：（B、E）解析：只有可以产生undo数据的表，才可能有不...

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

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

（64）You performed an incomplete recovery and opened the database with the RESETLOGS option.The LOG_ARCHIVE_FORMAT parameter is set to'ora_%t_%s_%r.log'.Which statement regarding the archived redo log files,created in an earlier incarnation of the database,is true?A. The archived redo lo...

（63）Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committed...

（62）You want to convert your existing non-ASM files to ASM files for the database PROD.Which method or command would you use to accomplish this task?A. Data Pump Export and ImportB. conventional export and importC. the CONVERT command of RMAND. the BACKUP AS COPY.command of RMAN...

（61）Which of the following advisors within the Oracle advisory framework will analyze a single SQL statement and make recommendations for performance improvement?A. SQL Repair AdvisorB. SQL OptimizerC. SQL Access AdvisorD. SQL Tuning Advisor答案：（D）重复：38, 44...

（60）For which two situations would you use functionality provided by the Resource Manager?(Choose two.)A. setting idle timeout limits on resource plansB. saving storage space by using compressed backup setsC. creating jobs that will run automatically at a scheduled timeD. assigning ...

（59）You have not configured Oracle Managed Files（OMF）in your database.You do not want to scan the entire datafile every time an incremental backup is performed.You decide to enable the block change tracking feature.Which statement should you use to enable the block change tracking fea...

（58）Which statement is true when Automatic Workload Repository（AWR）baselines are created using baseline templates?A. AWR baselines are always created as repeating baselines.B. AWR baselines can be created on the basis of two time values.C. AWR baselines are always created with infinit...