In which scenario would index be most useful? （）

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 . 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 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 . 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 .  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 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 . The data entered into the called form is logically independent of the data entered in the calling form.  B . The called form requires different privileges than the calling form.  C . The called form must execute as a different user than the calling form.  D . The calling form must be able to query data in the called form before it is saved.

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 .  when all the online redo log groups are multiplexed and one of the members of a group is missing B .  when all the online redo log groups are not multiplexed and one log group is missing C .  when all the control files are missing D .  when some important tables are deleted from the database and purged from the Recycle Bi

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

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 .  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 . Two switches are connected via a trunk. Both switches have been assigned an IP address, subnet mask, and default gateway. A ping is successful between the two switches. However, VLAN information is not passed from one switch to the other switch. B . A router and a switch have been assigned an IP address, a subnet mask, and a default gateway. They are directly connected, but a ping between the two devices fails. C . A router connects to another router through a serial interface. Both routers have been assigned an IP address, subnet mask, and default gateway. The routers are running RIP and the networks directly connected to the first router do not pass to the second router. However, a ping from one router to the serial interface of the directly connected neighboring router is successful. D . A router connects to another router via a switch. Both routers and the switch have been assigned an IP address, subnet mask, and default gateway. Neither the routers nor the switch are able to ping one of the hosts that is directly to the switch.

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