当前分类： 1z0-043
问题：多选题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 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 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 are maintaining the SALES database on Oracle 10g. You have added a new disk to a disk group. Automatic Storage Management performs the rebalancing activity. You want to speed up the rebalancing activity. Which parameter will you specify to control ...
问题：You issued the following command： ALTER TABLE SCOTT.EMP SH...
问题：In which scenario will you create a hash cluster？（）...
问题：多选题You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parameter in the parameter file to YYYY-MM-DD. The default format of which two data types would be affected by this setting？ （）ADATEBTIMESTAMPCINTERVAL YEAR TO MONTHDINTERVAL DAY TO SECONDETIMESTAMP...
问题：You have specified the warning and critical threshold values...
问题：You have configured Automatic Shared Memory Management. Whic...
问题：单选题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 execute the following command to enable a session in resumable mode： SQL ALTER SESSION ENABLE RESUMABLE TIMEOUT 60； What is the impact of a timeout on the statements being suspended？（）A The statements remain suspended for at least 60 seconds.B ...
问题：多选题Your database in running in the ARCHIVELOG mode. You issue the following command to back up datafile 2 in your database. RMAN COPY DATAFILE 2 TO ’D:///ORACLE/ORA90/MYNEWDB/DA2.DBF’； Which two statements are true regarding the backup created using t...
问题：Which background process sequentially writes Flashback Datab...
问题：In your production database you want to use an Automatic Sto...
问题：单选题In your production database you want to use an Automatic Storage Management （ASM） instance to manage the database files. Which option would you use to migrate the database files from a non-ASM instance to an ASM instance？（）A Oracle Migration AssistantB...
问题：单选题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 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， ...
问题：You executed the following command in Recovery Manager （RMAN...
问题：多选题Last night， a media failure caused the loss of a temporary file that belongs to your database. Which two things may happen this morning when you try to open your database？ （）AThe database opens normally.BThe database prompts for a database recovery.CTh...
