When setting up the Flashback Data Archive， which of these key parameters are required？（）A、 Tablespace nameB、 Storage quotaC、 RetentionD、 Table nameE、 Create a default archive

第1题：

第2题：

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

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

第3题：

第4题：

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

第5题：

You need to maintain a record of all transactions on some tables for at least three years. Automatic undo management is enabled for the database. What must you do accomplish this task？（）

• A、 Enable supplemental logging for the database.
• B、 Specify undo retention guarantee for the database
• C、 Create Flashback Data Archive in the tablespace where the tables are stored.
• D、 Create Flashback Data Archive and enable Flashback Data Archive for specific tables

第6题：

You are working on the APPDB database as a DB A. 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.

第7题：

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

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

第8题：

第9题：

You must track all transactions that modify certain tables in the sales schema for at least three years. Automatic undo management is enabled for the database with a retention of one day. Which two must you do to track the transactions?（）

• A、Enable supplemental logging for the database.
• B、Specify undo retention guarantee for the database.
• C、Create a Flashback Data Archive in the tablespace where the tables are stored.
• D、Create a Flashback Data Archive in any suitable tablespace.
• E、Enable Flashback Data Archiving for the tables that require tracking

第10题：

You create a table with the PERIOD FOR clause to enable the use of the Temporal Validity feature of Oracle Database 12c. Examine the table definition: Which three statements are true concerning the use of the Valid Time Temporal feature for the EMPLOYEES table?（）

• A、The valid time columns employee_time_start and employee_time_end are automatically created.
• B、The same statement may filter on both transaction time and valid temporal time by using the AS OF TIMESTAMP and PERIOD FOR clauses.
• C、The valid time columns are not populated by the Oracle Server automatically.
• D、The valid time columns are visible by default when the table is described.
• E、Setting the session valid time using DBMS_FLASHBACK_ARCHIVE.ENABLE_AT_VALID_TIME sets the visibility for data manipulatio