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

A . Event Viewer gives more details on the failure. B . The alert log file gives detailed information about the failure. C . PMON rolls back the transaction and releases the locks. D . SMON rolls back the transaction and releases the locks. E . The transaction is rolled back by the next session that refers to any of the blocks updates by the failed transaction. F . Data modified by the transaction up to the last commit before the abnormal termination is retained in the database.

A .  when recovering a lost read-only tablespace from a read-only tablespace backup B .  when recovering a lost read-only tablespace from a read-write tablespace backup when the database is running in  ARCHIVELOG mode C .  when 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 overwritten D .  when 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

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 . When using versions of Java technology earlier than 5.0. B . When sharing a StringBuffer among multiple threads. C . When using the java.io class StringBufferInputStream. D . When you plan to reuse the StringBuffer to build more than one string.

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 . The indexed column is declared as NOT NULL. B . The indexed columns are used in the FROM clause. C . The indexed columns are part of an expression. D . The indexed column contains a wide range of values.

A . You want to identify the most senior employee in the company. B . You want to find the manager supervising the largest number of employees. C . You want to identify the person who makes the highest salary for all employees. D . You want to rank the top three sales representatives who have sold the maximum number of products.

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 . IPCC Express communicating with the ICM via a standalone IPCC Gateway PG running on an expansion server   B . IPCC Express communicating with the ICM via a co-resident IPCC Gateway PG C . IPCC Express using the IPCC Enterprise Outbound option   D . IPCC Express using the IPCC Enterprise CTI-OS Toolkit   E . IP IVR integrating with IPCC Enterprise to function as queue point and self-service platform

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 . <title>${titleStr}</title> B . <title>${initParam.titleStr}</title> C . <title>${params[0].titleStr}</title> D . <title>${paramValues.titleStr}</title> E . <title>${initParam[’titleStr’]}</title&gt

A .  A maximum of 3 GB can be allocated to shared pool B .  The value for SGA_TARGET can be increased up to a maximum of 15 GB C .  A total of 14 GB memory will be allocated to the automatically tuned memory components. D .  Increasing the value for SGA_TARGET will automatically increase the memory allocated for STREAMS_POOL_SIZE E .  Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters F .  Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB

A . when they receive a special token B . when there is a carrier C . when they detect no other devices are sending D . when the medium is idle E . when the server grants acce

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 . When using versions of Java technology earlier than 5.0. B . When sharing a StringBuffer among multiple threads. C . When using the java.io class StringBufferInputStream. D . When you plan to reuse the StringBuffer to build more than one string.

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 optimizer adds the new plan to the plan history. B . The optimizer selects the new plan for the execution of the SQL statement. C . The optimizer adds the new plan to the SQL plan baseline as an accepted plan. D . The optimizer adds the new plan to the SQL plan baseline but not in the ENABLED state. E . The optimizer costs each of the accepted plans in the SQL plan baseline and picks the one with the lowest cost.

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 .  A total of 14 GB memory will be allocated to the automatically tuned memory components B .  Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory allocated to shared pool from 3 GB to 2 GB C .  The value for SGA_TARGET can be increased up to a maximum of 14 GB D .  A maximum of 3 GB can be allocated to shared pool E .  Increasing the value for SGA_TARGET to 12 GB will automatically increase the memory allocated to autotuned parameters F .  Increasing the value for SGA_TARGET will automatically increase the memory allocated for  STREAMS_POOL_SIZE

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.