You disabled the Flashback Database feature by using the following command：  SQL> ALTER DATABASE FLASHBACK OFF；  What would be the effect of this command on the existing flashback logs？（）

A . Click the Connect to a network link， right-click the appropriate network， and then click the Connect option. B . Click the View computers and devices link， right-click the wireless router， and then click the Enable option. C . Click the Set up a connection or network link， and then click the Set up a wireless Ad hoc network option. D . Click the Set up a connection or network link， and then click the Manually connect to a wireless network option.

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 .  Flashback logs are not archived. B .  Flashback logs are maintained in redo log files. C .  Flashback logs are maintained in the Flash Recovery Area. D .  Flashback logs are used to maintain Flashback Database related errors. E .  Flashback logs need to be cleared manually after you disable Flashback Database.

A .  The location used for control files. B .  The location used for redo log files. C .  The location set by using $ORACLE_BASE D .  The location set by using $ORACLE_HOME E .  The location set by using CORE_DUMP_DEST F .  The location set by using BACKGROUND_DUMP_DEST

A .   STARTUP MOUNT EXCLUSIVE  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN； B .   STARTUP MOUNT  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； C .   STARTUP MOUNT EXCLUSIVE  ATLER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN RESETLOGS； D .   STARTUP MOUNT  ALTER DATABASE ARCHIVELOG；  ALTER DATABASE FLASHBACK ON；  ALTER DATABASE OPEN；

A .  SYSDATE should not be used with TIMESTAMP. B .  The database must have multiplexed redo log files. C .  The database must be in the MOUNT state to execute the command. D .  The database must be opened with the RESETLOGS option after the flashback operation. E .  The entire database needs to be restored from the most recent backup before the flashback operation.

A .  to undo the changes made to the EMP table since the specified time B .  to restore the EMP table that was wrongly dropped from the database C .  to view the transactions that have modified the EMP table since the specified time D .  to view the changes made to the EMP table for one or more rows since the specified time

A . to undo the changes made to the EMP table since the specified time B . to restore the EMP table that was wrongly dropped from the database C . to view the transactions that have modified the EMP table since the specified time D . to view the changes made to the EMP table for one or more rows since the specified time E . to recover the EMP table to a point in time in the past by restoring the most recent backu

A . The Flashback Archive FLA1 is dropped only if it is empty. B . The tablespace having Flashback Archive is dropped. C . The Flashback Archive FLA1 is dropped after moving the existing data in it to the default Flashback Archive. D . The Flashback Data Archive and historical data are dropped.

A . The FLASHBACK TABLE statement will not be written to the alert log file. B . The changes made to the EMP table since the specified time will be undone. C . The EMP table that was dropped by mistake from the database will be restored. D . The FLASHBACK TABLE statement will be executed within a single transaction. E . The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table.  F . The list of transactions that have modified the EMP table since the specified time will be displayed.

A .  V$DATABASE B .  V$FLASHBACK_DATABASE_STAT C .  V$FLASHBACK_DATABASE_LOG D .  V$RECOVERY_FILE_DEST

A .  The database does not record flashback logs for MY_TABLESPACE B .  The tables residing in MY_TABLESPACE are not protected by the Recycle Bin. C .  All the tablespaces except MY_TABLESPACE can be recovered using Flashback Database feature. D .  None of the flashback technologies， such as Flashback Table， Flashback Transaction Query and Flashback Version Query can be used to recover individual rows within the objects from MY_TABLESPACE

A . the time when the last flashback operation in your database was performed B . the time when the first flashback operation in your database was performed C . a list of flashback operations performed in your database using SCN and time D . the approximate time and the lowest system change number （SCN） to which you can flash back your database

A . the location used for control files B . the location used for redo log files C . the location set by using $ORACLE_BASE D . the location set by using $ORACLE_HOME E . the location set by using CORE_DUMP_DEST F . the location set by using BACKGROUND_DUMP_DEST

A .  You must use automatic undo management in the database. B .  You must configure OMF in your database. C .  You must configure ASM for storing the datafiles. D .  You must multiplex the online redo log file.

A .  Drop the table. B .  Partition the table. C .  Truncate the table. D .  Add a column to the table. E .  Rename a column in the table.

A . PAP B . SPAP C . MSCHAP D . MSCHAP V2

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 . to undo the changes made to the EMP table since the specified time B . to restore the EMP table that was wrongly dropped from the database C . to view the transactions that have modified the EMP table since the specified time D . to view the changes made to the EMP table for one or more rows since the specified time E . to recover the EMP table to a point in time in the past by restoring the most recent backu

A . SYSDATE should not be used with TIMESTAMP. B . The database must have multiplexed redo log files. C . The database must be in the MOUNT state to execute the command. D . The database must be opened with the RESETLOGS option after the flashback operation. E . The entire database needs to be restored from the most recent backup before the flashback operation.

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 . to recover a dropped tablespace B . to recover data from a truncated table C . to recover a data file that has been shrunk D . to recover a database to the state that existed before the RESETLOGS operatio

A .  To recover a dropped table. B .  To recover a dropped schema. C .  To recover data from a truncated table. D .  To view changes made by all the transactions during a given period of time. E .  To view changes made by a single transaction during a given period of time.

A .  The FLASHBACK TABLE statement will not be written to the alert log file. B .  The EMP table that was dropped by mistake from the database will be restored. C .  The changes made to the EMP table since the specified time will be undone. D .  The FLASHBACK TABLE statement will not maintain the existing indexes on the EMP table. E .  The FLASHBACK TABLE statement will be executed within a single transaction. F .  The list of transactions that have modified the EMP table since the specified time will be displayed.