You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

相似题目

• What two are the prerequisites for enabling Flashback Database？（） 

  A .  The database must be in ARCHIVELOG mode B .  The database must be in MOUNT EXCLUSIVE mode C .  The database must be opened in RESTRICTED mode D .  The database instance must be started in the NOMOUNT state E .  The database instance must have the keep buffer pool defined

  查看最佳答案

• Before a Flashback Table operation, you execute the following command: ALTER TABLE employees ENABLE ROW MOVEMENT; Why would you need this to be executed?（）

  A . Because row IDs may change during the flashback operation B . Because the object number changes after the flashback operation C . Because the rows are retrieved from the recycle bin during the flashback operation D . Because the table is moved forward and back to a temporary during the flashback opertio

  查看最佳答案

• Which two are the prerequisites to enable Flashback Data Archive?（） (Choose two.)

  A . Database must be running in archivelog mode. B . Automatic undo management must be enabled. C . Undo retention guarantee must be enabled. D . The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

  查看最佳答案

• To clean up old records that are in a Flashback Data Archive and are past the retention period， what must the DBA do？（）  

  A .  TRUNCATE the archive table. B .  DROP the Flashback Data Archive. C .  Nothing；expired rows are automatically removed. D .  Nothing；expired rows are moved to an archive table. E .  Delete entries from the archive where the metadata date retained is greater than the retention period.

  查看最佳答案

• You are working on an Oracle Database 10g database. You enabled the Flashback Database feature. Which two statements regarding flashback logs are true？ （）

  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.

  查看最佳答案

• You enabled the flashback logging feature， but you have not specified the location of the flash recovery area. Which location would be used as the default location for the flash recovery area？（）

  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

  查看最佳答案

• You are managing a single instance Oracle 10g database that utilizes the following parameters：  Which of the following set of commands must you execute to enable Flashback Database？（）

  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；

  查看最佳答案

• Which of the following SQL*Loader parameters enables you to load a specified number of records stored in the data file？（）

  A . ROWS B . SKIP C . LOAD D . BINDSIZE

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE ？5/24）； Which two statements are true？ （）

  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.

  查看最佳答案

• What two are the prerequisites for enabling Flashback Database?（） (Choose two)

  A . The database must be in ARCHIVELOG mode B . The database must be in MOUNT EXCLUSIVE mode C . The database must be opened in RESTRICTED mode D . The database instance must be started in the NOMOUNT state E . The database instance must have the keep buffer pool defined

  查看最佳答案

• You are working on the APPDB database as a DBA. The database has a default Flashback Data Archive DFLA1 created on it. You issued the following command to drop the Flashback Archive FLA1: DROP FLASHBACK ARCHIVE fla1,What is the effect of this command?（）

  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.

  查看最佳答案

• Which background process sequentially writes Flashback Database data from the flashback buffer to the Flashback Database logs？（）

  A .  DBWn B .  RECO C .  RVWR D .  LGWR

  查看最佳答案

• You are maintaining the SALES database for an organization. You have enabled the Flashback Database feature and want to estimate the flashback space required for future operations.  Which view would you query to estimate the flashback space required？（）

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

  查看最佳答案

• What are the prerequisites for enabling Flashback Database？ （）

  A .  The database must be started in the MOUNT EXCLUSIVE state. B .  The database must have multiplexed control files. C .  The database must be opened by using a text-based parameter file instead of a server parameter file （SPFILE）. D .  The database must be in ARCHIVELOG mode. E .  The database must be in the NOMOUNT state. F .  The database must be opened in RESTRICTED mode.

  查看最佳答案

• Which of the following specification will allow you to： associate VLAN groups to STP instances so  you can provide multiple forwarding paths for data traffic and enable load balancing？ （）

  A .  IEEE 802.1d （STP） B .  IEEE 802.1s （MST） C .  IEEE 802.1Q （CST） D .  IEEE 802.1w （RSTP）

  查看最佳答案

• Your Oracle Database 10g is online when you execute the following statement：        SQL>ALTER TABLESPACE MY_TABLESPACE FLASHBACK OFF；   What is the result of executing this statement if the Flashback Database feature is already enabled in the database？（）

  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

  查看最佳答案

• You enabled the flashback logging feature， but you have not specified the location of the flash recovery area.  Which location would be used as the default location for the flash recovery area？（）

  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

  查看最佳答案

• You are working on an Oracle Database 10g database. Because of data loss， you decided to perform a Flashback Database operation using the following command：  SQL> FLASHBACK DATABASE TO TIMESTAMP（SYSDATE 5/24）;  Which two statements are true？ （）

  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.

  查看最佳答案

• When setting up the Flashback Data Archive， which of these key parameters are required？（）

  A .  Tablespace name B .  Storage quota C .  Retention D .  Table name E .  Create a default archive

  查看最佳答案

• Which two are the prerequisites to enable Flashback Data Archive？（）

  A .  Database must be running in archivelog mode. B .  Automatic undo management must be enabled. C .  Undo retention guarantee must be enabled. D .  The tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management （ASSM）.

  查看最佳答案

• Before a Flashback Table operation，you execute the following command：   ALTER TABLE employees ENABLE ROW MOVEMENT；   Why would you need this to be executed？（）  

  A .  Because row IDs may change during the flashback operation B .  Because the object number changes after the flashback operation C .  Because the rows are retrieved from the recycle bin during the flashback operation D .  Because the table is moved forward and back to a temporary during the flashback opertio

  查看最佳答案

• Which are the two prerequisites before setting up Flashback Data Archive? （）(Choose two.)

  A . Flash recovery area must be defined B . Undo retention guarantee must be enabled. C . Database must be running in archivelog mode. D . Automatic undo management must be enabled. E . The tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

  查看最佳答案

• Flashback is enabled for your multitenant container database （CDB), which contains two plu

  Flashback is enabled for your multitenant container database (CDB), which contains two pluggable database (PDBs). A local user was accidently dropped from one of the PDBs.You want to flash back the PDB to the time before the local user was dropped. You connect to the CDB and execute the following commands:SQL ＞ SHUTDOWN IMMEDIATE SQL ＞ STARTUP MOUNT SQL ＞ FLASHBACK DATABASE to TIME TO_DATE (‘08/20/12’ , ‘MM/DD/YY’)”;Examine following commands:1. ALTER PLUGGABLE DATABASE ALL OPEN;2. ALTER DATABASE OPEN;3. ALTER DATABASE OPEN RESETLOGS;Which command or commands should you execute next to allow updates to the flashback back schema？（） A. Only 1 B. Only 2 C. Only 3 D. 3 and 1 E. 1 and 2

  查看最佳答案

• Before a Flashback Table operation, you execute the following command:ALTER TABLE employees ENABLE ROW MOVEMENT;Why would you need this to be executed？（）

  A. Because row IDs may change during the flashback operation B. Because the object number changes after the flashback operation C. Because the rows are retrieved from the recycle bin during the flashback operation D. Because the table is moved forward and back to a temporary during the flashback operation

  查看最佳答案