问题:单选题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 want to migrate your existing non-ASM files to ASM files for the database PROD. Which method or command would you use to accomplish this task?()Athe CONVERT command of RMANBData Pump Export and Import into the same databaseCconventional export and...
问题:多选题Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management (ASM) instance, you find that the performance of the database decreases initially, until the addition or removal process is completed. Performance ...
问题:You executed the following command in Recovery Manager (RMAN...
问题:单选题In which scenario will you create a sorted hash cluster? ()A if the application uses queries joining tables only occasionallyB if the full table scan is executed often on only one table of the clustered tablesC if the data for all the rows of a clus...
问题:单选题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 ...
问题:On Monday, you dropped the DEPT table from your schema and t...
问题:You have specified the warning and critical threshold values...
问题:You are maintaining your database in Oracle10g. You want to ...
问题:You used the following command in Recovery Manager (RMAN) as...
问题:A redo log file is corrupted while the database is open; as ...
问题:单选题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 have included the following parameter settings in your S...
问题:You have set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...
问题:单选题You are maintaining your database in Oracle10g. You are performing the backup by using the BACKUP AS BACKUPSET command at the RMAN prompt. Which file cannot be backed up by using the BACKUP AS BACKUPSET command?()A DatafilesB Current control fileC Se...
问题:单选题From the V$SESSION_LONGOPS view, you find that some of the database users have long-running queries that consume a lot of CPU time. This causes performance problems for other users in the database, who have much shorter queries. You would like to make ...
问题:多选题These are the details about V$FLASHBACK_DATABASE_STAT: SQL DESC v$FLASHBACK_DATABASE_STAT Name Null? Type ------------- -------- -------------- BEGIN_TIME DATE END_TIME ...
问题:单选题You received the following error: ORA-01578: ORACLE data block corrupted (file # %s, block # %s) Which file will you check to view additional information regarding the cause of this error?()A the alert log file and the trace filesB the redo log ...
问题:You have configured Automatic Shared Memory Management. Whic...