In which scenario will you perform an incomplete recovery？（）

相似题目

• Examine the following command：   ALTER DISKGROUP data MOUNT FORCE；   In which scenario can you use the above command to mount the disk group？（）  

  A .  when ASM disk goes offline B .  when one or more ASM files are dropped C .  when some disks in a disk group are offline D .  when some disks in a failure group for a disk group are rebalancing

  查看最佳答案

• In which scenarios would you rebuild an index？（）

  A .  when you need to disable the index usage B .  when you need to change storage options C .  when you need to enable index monitoring D .  when you need to move the index to another tablespace

  查看最佳答案

• In which scenario do you use the Flashback Database feature？（）

  A .  when a table is dropped and you restore it from the Recycle Bin B .  when a user’s schema is dropped and you recover the user’s schema C .  when some incorrect data is inserted in the table and you retrieve the table to a state that was at a certain timestamp D .  when a row of a table is updated frequently and committed， and you view all the versions of the row within a specific duratio

  查看最佳答案

• You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

  A . The EMPLOYEES table will be changed to read-only mode during the shrink operation. B . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over. C . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation. D . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operation.

  查看最佳答案

• You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode.   Which two statements are correct in this scenario？（）

  A . The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B . The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C . Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA  memory management. D . The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA  memory management mode.

  查看最佳答案

• You are working in a dedicated server environment. Your database is running in the automatic Program Global Area （PGA） memory management mode. Which two statements are correct in this scenario？ （）

  A .  The WORK_AREASIZE_POLICY initialization parameter cannot be set to AUTO. B .  The Oracle database automatically controls the amount of PGA memory allotted to SQL work areas. C .  Setting the value of the SGA_TARGET initialization parameter to 0 will disable the automatic PGA memory management. D .  The SORT_AREA_SIZE parameter is ignored by all the sessions running in the automatic PGA memory management mode.

  查看最佳答案

• 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？（）

  A .  You must ensure that the SALES database is mounted or open. B .  You must restore a backup control file to perform a block media recovery. C .  You must take the tools01.dbf data file offline before you start a block media recovery. D .  You must put the database in NOARCHIVELOG mode to perform a block media recovery. E .  You can perform only a complete media recovery of individual blocks， point-in-time recovery of individual data blocks is not supported.

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact.  In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  A . loss of a tempfile B . loss of a system data file C . loss of one of the control files D . loss of one of the tablespaces E . loss of a member from each redo log group F . loss of the only member of an unarchived redo log grou

  查看最佳答案

• Examine the following command: ALTER DISKGROUP data MOUNT FORCE; In which scenario can you use the above command to mount the disk group? （）

  A . when ASM disk goes offline B . when one or more ASM files are dropped C . when some disks in a disk group are offline D . when some disks in a failure group for a disk group are rebalancing

  查看最佳答案

• You are working on Oracle Database 10g， which is in ARCHIVELOG mode. All the archived log files are intact. In which scenario would performing a recovery require the opening of the database with the RESETLOGS option？（）

  A .  loss of one of the tablespaces B .  loss of a system data file C .  loss of one of the control files D .  loss of a tempfile E .  loss of the only member of an unarchived redo log group F .  loss of a member from each redo log grou

  查看最佳答案

• In which situations will the ASM metadata backup help you recover the ASM disk in a disk group？（）

  A .  when one or more file directory paths are accidentally deleted from an ASM disk group B .  when one of the disks in a disk group is accidentaly unplugged C .  when the data file on an ASM disk group gets corrupted D .  when one or more disks in an ASM disk group are lost

  查看最佳答案

• In which scenario will you perform a cancel-based recovery？（）

  A .  when a tablespace is dropped and you have only RMAN-based backup of the database B .  when a table is dropped and stored in the Recycle Bin C .  when you are required to recover an existing table to its previous state D .  when a tablespace is dropped and you have only a user-managed full backup of the database

  查看最佳答案

• Which of the following scenarios will ensure that the value of the NEXT_STEPNO column in a given row of table TABLEX exists as a value of column STEPNO (usually in another row) in the same table?（）

  A . Define a UNIQUE constraint on the columns NEXT_STEPNO and STEPNO. B . Define a CHECK constraint on the NEXT_STEPNO column (NEXT_STEPNO = STEPNO). C . Define column STEPNO as the primary key of TABLEX and column NEXT_STEPNO as a foreign key referencing column STEPNO of the same table. D . Define column NEXT_STEPNO as the primary key of TABLEX and column STEPNO as a foreign key referencing column NEXT_STEPNO in the same table.

  查看最佳答案

• In which two scenarios should you issue the following command？（） FLASHBACK TABLE SCOTT.EMP TO TIMESTAMP SYSTIMESTAP- INTERVAL ’15’ MINUTE；

  A .  when the schema of the user， SCOTT， was deleted by mistake 15 minutes ago B .  when the table EMP of the SCOTT schema was dropped by mistake 15 minutes ago C .  when some rows of the table， EMP， in the SCOTT schema were deleted by mistake 15 minutes ago D .  when some incorrect values were inserted in the EMP table in the user Scott’s schema during the last 15 minutes E .  never， because FLASHBACK TABLE is not a valid command in Oracle 10g.

  查看最佳答案

• In which scenario will you use the Flashback Transaction Query feature？（）

  A .  when you want to restore an important table that is dropped from the Recycle Bin B .  when you want to obtain the SQL statements to undo the deletion of some important records from a table by a transaction C . when you want to restore a dropped user’s schema D .  when a row of a table is updated many times within a specific time period and you want all the versions of the row in the specified time period

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run in ARCHIVELOGmode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案

• In which scenario will you issue the following command？（）      SQL> RECOVER DATABASE UNTIL TIME ’2005-10-04 ： 12：09：08’ USING        BACKUP CONTROLFILE；

  A .  when all the control files are missing and only a binary backup of the current control file exists B .  when a multiplexed copy of the current control file is missing C . when all the control files are missing and only a script containing the CREATE CONTROLFILE statement exists D .  when the SPFILE is missing

  查看最佳答案

• You are performing a block media recovery on the tools01.dbf data file in the SALES database by using RMAN.   Which two statements are correct in this scenario？（）

  A . You must ensure that the SALES database is mounted or open. B . You must restore a backup control file to perform a block media recovery. C . You must take the tools01.dbf data file offline before you start a block media recovery. D . You must put the database in NOARCHIVELOG mode to perform a block media recovery. E . You can perform only a complete media recovery of individual blocks； point-in-time recovery of  individual data blocks is not supported.

  查看最佳答案

• You executed the following SQL statement to shrink the EMPLOYEES table segment stored in the EXAMPLE tablespace: ALTER TABLE employees SHRINK SPACE CASCADE; Which statement is correct in this scenario?（）

  A . The data in the segment will be compacted but the high water mark will not be adjusted  B . The EMPLOYEES table will be changed to read-only mode during the shrink operation  C . The indexes created on the EMPLOYEES table will need to be rebuilt after the shrink operation is over D . The shrink behavior will be cascaded to all dependent segments of the table that support a shrink operation  E . Data manipulation language (DML) operations will not be possible on the EMPLOYEES table during the COMPACTION phase of the shrink operatio

  查看最佳答案

• In which scenario， will you issue the following command？（） RMAN> REPORT NEED BACKUP DAYS 7；

  A .  to configure RMAN to maintain backup information in the RMAN repository for seven days B .  to configure RMAN to maintain backup information in the control file for at least seven days C .  to display the list of files that have not been backed up for the last seven days D .  to display the list of files that must be backed up within seven day

  查看最佳答案

• In which scenario will you use the Flashback Version Query feature？（）

  A .  when you want to restore a table that has been dropped from the Recycle Bin B .  when you want to identify the transaction ID of the transaction that deleted some important records from a table C .  when you want to recover the schema of a dropped user D . when you want to restore a dropped tablespace

  查看最佳答案

• In which of the scenarios will the DBA perform recovery（）

  A . The alert log file is corrupted. B . A tablespace is accidentally dropped. C . One of the redo log members is corrupted. D . A database user terminates the session abnormally. E . The hard disk on which the data file is stored is corrupted.

  查看最佳答案

• Identify three scenarios in which you would recommend the use of SQL Performance Analyzer to analyzeimpact on the performance of SQL statements.（）

  A . Change in the Oracle Database version B . Change in your network infrastructure C . Change in the hardware configuration of the database server D . Migration of database storage from non-ASM to ASM storage E . Database and operating system upgrade

  查看最佳答案

• You are managing an Oracle Database 11g database. You configured the database to run inARCHIVELOG mode.  Which two statements are true in this scenario（）

  A . You must shut down the database instance to perform the backups. B . You must configure the Flash Recovery Area （FRA） for the database. C . You can perform complete database backups without closing the database. D . All the previous closed database backups including control files become invalid after you configure thedatabase to ARCHIVELOG mode.

  查看最佳答案