当前分类： 1z0-043
问题：单选题You decided to change the location of the flash recovery area. You executed the following command： ALTER SYSTEM SET DB_RECOVERY_FILE_DEST=’+disk1’ SCOPE=BOTH SID=’*’； Which statement is true？（）A The location can be changed only if the flash recove...
查看答案
问题：多选题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...
问题：单选题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 ...
问题：单选题You observe that the senior database administrator always uses the following command when connecting to Recovery Manager （RMAN）， and then starts executing commands to backup the database files： % rman target / What would be the effect of this command？（...
问题：单选题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 ...
问题：单选题One of the tablespaces is read-only in your database. The loss of all control files forced you to re-create the control file. Which operation do you need to perform after re-creating the control file and opening the database？（）A drop and re-create the...
问题：单选题You are maintaining your database in Oracle10g. You find that the INDEXES index tablespace should be recovered. How will you recover the index tablespace？（）A by using the Flashback Database featureB by using RMAN incomplete recoveryC by performing a...
问题：You have configured Automatic Shared Memory Management. Whic...
问题：You are working as a DBA on Oracle Database 9i. You plan to ...
问题：You have a disk group， DGROUP1， with three disks and NORMAL ...
问题：You noticed that the index tablespace in your database requi...
问题：On Monday， you dropped the DEPT table from your schema and t...
问题：单选题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， ...
问题：单选题There was media failure and you need to check the data files for any block corruption. Which option would you use to create a report on any corruptions found within the database？（）A the DBNEWID utilityB the DBVERIFY utilityC the ANALYZE commandD the RM...
问题：You have specified the warning and critical threshold values...
问题：You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题：单选题You executed the following query in your database： SELECT oldest_flashback_scn， oldest_flashback_time FROM V$FLASHBACK_DATABASE_LOG； What would you determine from the output？（）A The time when the last flashback operation in your database was performed...
问题：You want an ASM instance to manage the files of your databas...
问题：单选题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...
问题：单选题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...
