问题:单选题A junior level Database Administrator erroneously deleted the database alert log while users were accessing the database. Which action should you take to recover the alert log?()ADo nothing.BRestart the database.CPerform recovery on the database.DRestore the alert log from the last backup.
查看答案
问题:单选题Consider the following command to create a tablespace in your production database (which is using an Automatic Storage Management [ASM] instance to manage the database files): CREATE TABLESPACE user_tbsp DATAFILE ’+dgroup3(user_temp)/user_files/user_tbsp’ SIZE 200M; What would be the result of this command?()A It would result in an error because the template cannot be used along with the disk group.B It would result in an error because the path cannot be specified while creating a tablespace in a disk group.C It would create a tablespace with a data file that has an alias, and its attributes are set by the user-defined template.D It would create a tablespace with a data file that does not have an alias, and its attributes are set by the user-defined template.
问题:单选题You are maintaining your database in Oracle10g. You have set the value of the STATISTICS_LEVEL initialization parameter to TYPICAL and the value of the FAST_START_MTTR_TARGET parameter to 900 seconds. To increase the performance of the database, you want to determine the log file size that should equal the minimum size of all the online redo log files. Which column will enable you to perform the desired task?()Athe WRITES_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewBthe column of the V$INSTANCE_RECOVERY viewCthe OPTIMAL_LOGFILE_SIZE column of the V$INSTANCE_RECOVERY viewDthe LOG_FILE_SIZE_REDO_BLKS column of the V$INSTANCE_RECOVERY view
问题:多选题What are the two advantages of RMAN Block Media Recovery (BMR) over file/x7flevel recovery?()ABMR lowers the mean time to recover (MTTR).BBMR supports pointintime recovery of individual data blocks.CBMR enables you to use incremental backups for block recovery.DBMR enables recovery even when the database is not mounted or open.EBMR enables you to use proxy backups to perform block media recovery.FBMR enables increased availability of data during recovery because the data file that requires a recovery can remain online.
问题:单选题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. Which statement is true?()A The new setting would be applied but no alerts would be raised immediately.B The new setting would be applied and an alert would be raised immediately.C The new setting would be ignored because the tablespace space usage is more than the specified threshold value.D The new setting would cause an error because the tablespace space usage is more than the specified threshold value.
问题:多选题In your database, all the tablespaces are locally managed. You started Recovery Manager (RMAN) using recovery catalog and restored the control file by using the following command: RMAN> RESTORE CONTROLFILE; Which two operations do you need to perform after restoring the control file from backup?()Ashut down and restart the instanceBadd new tempfiles to the temporary tablespaces after recoveryCperform a media recovery and open the database with the RESETLOGS optionDperform a media recovery and bring the database to NOARCHIVELOG mode
问题:单选题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 variable. Which command will you issue?()Asetenv ORA_SDTZ ’DB_TZ’Bsetenv ORA_SDTZ ’+10:00’Csetenv ORA_SDTZ ’OS-TZ’Dsetenv ORA_SDTZ ’Europe/London’
问题:单选题You find that some queries on a table are taking a long time to execute because there are no indexes created on the table. You decide to invoke the SQL Access Advisor to determine the appropriate index to be created. Which package will you use to invoke the SQL Access Advisor?()A DBMS_SERVER_ALERTB DBMS_ADVISORC DBMS_RESOURCE_MANAGERD DBMS_REPAIR
问题:单选题In Recovery Manager (RMAN), you set the retention policy to NONE by executing the following command: CONFIGURE RETENTION POLICY TO NONE; What would be the impact of this setting?()A The retention policy is cleared.B RMAN does not consider any backup as obsolete.C The retention policy is set to its default setting of redundancy 1.D The retention policy is set to its default setting of recovery window 7.
问题:单选题You are creating a resource consumer group using the DBMS_RESOURCE_MANAGER.CREATE_CONSUMER_GROUP procedure. Which parameter will you use to define the resource scheduling method used between sessions within the resource group?()ACPU_MTHBNEW_CPU_MTHCCPU_P1DCPU_P2
问题:单选题You set the recovery window to seven days and the backup optimization to ON using the CONFIGURE command of Recovery Manager (RMAN). The most recent backup of the TOOLS tablespace to disk was taken on January 3. The TOOLS tablespace is read/x7fonly. On February 21, when you execute a command to back up all the tablespaces to disk, you find that RMAN backs up the TOOLS tablespace also, even though the contents of the tablespace have not changed after the backup on January 3. Because there are no changes made to the TOOLS tablespace, you decide that the tablespace should not be backed up by RMAN. What can you to do skip backing up the TOOLS tablespace without changing the current backup optimization setting?()A configure a default device for RMAN backupsB temporarily disable the retention policy for RMAN backupsC configure automatic channel allocation for RMAN backupsD use the CONFIGURE command to reconfigure the recovery window to 60 days
问题:单选题In which situation are you NOT required to perform an incomplete recovery?()Awhen all the control files are lostBwhen all the members of a redo log group are lostCwhen a table is dropped and purged from the Recycle BinDwhen a temporary file of the default temporary tablespace is lost
问题:单选题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 RMAN would use the current operating system location to place the backup.B RMAN would use the control file of the target database to maintain the backup.C RMAN would use the recovery catalog of the target database to maintain the backup.D RMAN would use the control file of the target database to maintain the backup metadata. E RMAN would use the recovery catalog of the target database to maintain the backup metadata.
问题:多选题You are performing a block media recovery on the tools01.dbf data file in the SALES database using RMAN. Which two statements are correct in this scenario?()AYou must ensure that the SALES database is mounted or open.BYou must restore a backup control file to perform a block media recovery.CYou must take the tools01.dbf data file offline before you start a block media recovery.DYou must put the database in NOARCHIVELOG mode to perform a block media recovery.EYou can perform only a complete media recovery of individual blocks, point-in-time recovery of individual data blocks is not supported.
问题:单选题You are maintaining the PROD database of NetFx Corporation. You set the value of the SQL_TRACE parameter to TRUE. What will be the impact of this setting?()AThe SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the USER_DUMP_DEST directory.BThe SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the USER_DUMP_DEST directory.CThe SQL trace facility will generate the performance statistics for all the SQL statements for an instance and write them in the BACKGROUND_DUMP_DEST directory.DThe SQL trace facility will generate the performance statistics for all the SQL statements for a session and write them in the BACKGROUND_DUMP_DEST directory.
问题:单选题You defined the Recovery Manager (RMAN) retention policy to recovery window of 7 days by executing the following command: RMAN> CONFIGURE RETENTION POLICY TO RECOVERY WINDOW OF 7 DAYS; When a backup is performed, what would be the status of this backup after seven days?()A The backup would be marked as invalid.B The backup would be marked as obsolete.C The backup would be removed from the media.D The backup would be removed from the RMAN repository.
问题:多选题For which two SQL statements can you use the Flashback Table feature to revert a table to its previous state?()AUPDATE TABLEBCREATE CLUSTERCTRUNCATE TABLEDALTER TABLE MOVEEINSERT INTO···VALUESFALTER TABLE···DROP COLUMNGALTER TABLE···DROP PARTITION
问题:单选题In which of the following scenarios is a tablespace recovery required?()Awhen recovering a lost read-only tablespace from a read-only tablespace backupBwhen recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in ARCHIVELOG modeCwhen recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in NOARCHIVELOG mode and the changes in the online redo log files have been overwrittenDwhen recovering a lost read-only tablespace from a read-only tablespace backup using the backup of the control file, the control file was created using the ALTER DATABASE BACKUP CONTROLFILE TO TRACE statement, and this statement was issued when the tablespace was read-only
问题:多选题You have created a job class, CUST_JOB_1, with two jobs, CUST_JOB_1_A and CUST_JOB_1_B. Which two statements are true? ()AThe member jobs would get dropped when the job class is dropped.BBoth the jobs would be executed concurrently.CThe member jobs would get disabled when the job class is dropped.DThe attributes defined at the class level would be applied to both the jobs.EJobs in the job class must have been assigned the same priority.
问题:多选题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 sources would you find the DBID? ()Athe alert log fileBthe server parameter fileCthe formatted name of a control file autobackupDan RMAN session log fileEthe trace file