当前分类: 1z0-043
问题:单选题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...
查看答案
问题:单选题What effect should the loss of an index tablespace have on an Oracle instance that is running?()A instance hangsB instance gets abortedC instance continues runningD instance gets restarted automatically...
问题:You database operates in ARCHIVELOG mode and user-managed co...
问题:多选题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 are working on an Oracle Database 10g database. You enab...
问题:单选题You have an Automatic Storage Management (ASM) instance managing the database files of your production database. The database contains ASM files and non-ASM files. Using Recovery Manager (RMAN), you migrate the complete production database to use the A...
问题:In which scenario will you create a hash cluster?()...
问题:You have configured Automatic Shared Memory Management. Whic...
问题:多选题Identify four uses of the Oracle Scheduler.()Aenables Oracle database to schedule which processes execute on which processors in a multiple CPU environmentBenables Oracle database to do patches according to a DBA-defined scheduleCenables you to schedul...
问题:On Monday, you dropped the DEPT table from your schema and t...
问题:单选题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 Oracle Database 10g. The LOG_ARCHIVE_FORMAT pa...
问题:When performing a backup using Recovery Manager (RMAN), whic...
问题:单选题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 ...
问题:单选题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 are maintaining your Oracle10g database in the UNIX environment. An application requires one of the user sessions to exist in the operating system local time zone. You decide to set the time zone for a session using the operating system environment...
问题:单选题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 set the value of the NLS_TIMESTAMP_TZ_FORMAT parame...