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 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

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

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

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.

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.

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.

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.

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

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

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

A .  when a table is dropped and stored in the Recycle Bin B .  when all the control files are deleted C .  when a member of a multiplexed redo log group is dropped D .  when you are required to recover a table to its previous state

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

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

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.

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.

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

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.

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.

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

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

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

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.

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

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.