当前分类： 1z0-043
问题：On Monday， you dropped the DEPT table from your schema and t...
查看答案
问题：You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题：You executed the following query： SELECT operation， undo_sq...
问题：单选题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， ...
问题：While creating a scheduler window using the DBMS_SCHEDULER p...
问题：You have configured Automatic Shared Memory Management. Whic...
问题：单选题You create an Oracle 10g database and configure the SPFILE as follows： SGA_TARGET=2G DB_CACHE_SIZE=512M LOG_BUFFER=50M DB_KEEP_CACHE_SIZE=128M You modify the SGA_TARGET initialization parameter using the following statement： SQLALTER SYSTEM ...
问题：You enabled the flashback logging feature， but you have not ...
问题：单选题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 ...
问题：单选题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 specified the warning and critical threshold values...
问题：单选题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 are connected to Recovery Manager （RMAN） without a recovery catalog. There is no copy of the control file available. You want to restore the control file from an autobackup. To retrieve the autobackup，you need the database ID （DBID）. In which two ...
问题：单选题The warning and critical threshold values have been set to 85% and 97%， respectively， for one of the tablespaces. The current tablespace space usage is 54%. You modify the warning threshold to be 50% and critical threshold to be 53% in Database Control...
问题：You are employed as a DBA in an organization. You are inform...
问题：You are connected to Recovery Manager （RMAN） without a recov...
问题：单选题You executed the following procedure to collect statistics regarding an index： SQLANALYZE INDEX EMP_ID VALIDATE STRUCTURE； Which view will you use to determine whether you need to rebuild the index or not？（）A INDEX_STATSB DBA_INDEXESC DBA_IN...
问题：In your running instance， some of the initialization paramet...
问题：单选题In one of your online transaction processing （OLTP） applications， most users frequently modify the values， including the key values， of the application tables. Some users generate application reports by using multiple application tables. What is the b...
问题：You used the following command in Recovery Manager （RMAN） as...
