当前分类： 1z0-043
问题：You create a table in your database that contains 50，000 row...
查看答案
问题：单选题You want an ASM instance to manage the files of your database. To achieve this objective， you specify the following parameters in the parameter file of the database： INSTANCE_TYPE = RDBMS DB_NAME = PROD LARGE_POOL_SIZE = 8MB DB_BLOCK_SIZE = 4K LOG_...
问题：单选题You have specified the warning and critical threshold values of an application tablespace to be 60% and 70%， respectively. From the tablespace space usage metrics， you find that the actual space usage has reached the specified warning threshold value， ...
问题：Your database block size is 4 KB. In this database， you are ...
问题：单选题You moved the index EMP_NO_INDX from one tablespace to another and then issued the following command to rebuild the index EMP_NO_INDX： SQL ALTER INDEX EMP_NO_INDX REBUILD ONLINE； Which table allows the users to access the EMP_NO_INDX index while pe...
问题：单选题You are creating the simple resource plan using the DBMS_RESOURCE_MANAGER.CREATE_SIMPLE_PLAN procedure. Which resource allocation policy will be used for the resource plan？（）A RATIOB EMPHASISC ACTIVE_SESS_POOL_MTHD RESOURCE_DEGREE_LIMIT_ABSOLUTE...
问题：单选题Consider the following command to add a new disk group called "tdgroupA" with two failover groups： CREATE DISKGROUP tdgroupA NORMAL REDUNDANCY FAILOVERGROUP control01 DISK ’/devices/A1’， ’/devices/A2’， ’/devices/A3’ FAILOVERGROUP control02 DISK ’/de...
问题：You have configured Automatic Shared Memory Management. Whic...
问题：What are the two advantages of RMAN Block Media Recovery （BM...
问题：You have specified the warning and critical threshold values...
问题：You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题：单选题You want to estimate the size of a table by using the Oracle Enterprise Manager. On which data is the size of the table NOT based？（）A column sizesB column data typesC PCTFREED projected number of rowE PCTUSED...
问题：多选题You used the following command in Recovery Manager （RMAN） as part of the recovery process： RESTORE CONTROLFILE FROM AUTOBACKUP； How does RMAN find the control file autobackup？（）ABy using the trace file.BBy using the alert log file.CBy using the datab...
问题：On Monday， you dropped the DEPT table from your schema and t...
问题：You are managing an Oracle Database 10g database that uses O...
问题：单选题You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）A the location used for control filesB the location used ...
问题：In your production database， you have observed that the data...
问题：单选题A redo log file is corrupted while the database is open； as a consequence， database operations are stopped because archiving cannot continue. What would you do to solve the problem？（）A clear the redo log groupB perform redo log file importC perform ...
问题：单选题You are using an Automatic Storage Management （ASM） instance to manage the files of your production database. You have two disk groups， DG1 and DG2， with one device each. In the parameter file of the production database， the following parameters have b...
问题：单选题You have many users complaining about slow inserts into a large table. While investigating the reason， you find that the number of indexes on the table is high. You want to find out which indexes are not being used. Which method would you follow to ac...
