网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

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.

参考答案

更多 “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 tableC、Truncate the table.D、Add a column to the table.E、Rename a column in the table.” 相关考题
考题 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 databaseC. 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

考题 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 tableC. Truncate the table.D. Add a column to the table.E. Rename a column in the table.

考题 Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.) A. Flash recovery area must be definedB. 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).

考题 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

考题 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 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.

考题 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$DATABASEB、 V$FLASHBACK_DATABASE_STATC、 V$FLASHBACK_DATABASE_LOGD、 V$RECOVERY_FILE_DEST

考题 You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()A、Oracle Flashback uses undo information to construct consistent data. B、You can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session. C、You can only use Oracle Flashback view of the data if the required records are still in the online redo log files. D、Oracle Flashback lists the DML that was executed during the period you identify when initiating your session. 

考题 You are working as a DBA on the decision support system. There is a business requirement to track and store all transactions for at least three years for a few tables in the database. Automatic undo management is enabled in the database.  Which configuration should you use to accomplish this task?()A、 Enable Flashback Data Archive for the tables.B、 Specify undo retention guarantee for the database.C、 Enable supplemental logging for the database.D、 Query V$UNDOSTAT to determine the amount of undo that will be generated and create an undo tablespace for that size.E、 Create Flashback Data Archive on the tablespace on which the tables are stored.

考题 You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;   What is the implication of this command?()A、 The command produces an error because the retention time cannot be reduced.B、 All historical data is retained but the subsequent flashback data archives are maintained for only three years.C、 All historical data is purged and the new flashback data archives are maintained for three years.D、 All historical data older than three years is purged from the flashback archive FLA1.

考题 These are the details about V$FLASHBACK_DATABASE_STAT: SQL DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()A、 BEGIN_TIME is the time at which Flashback logging is enabled.B、 END_TIME is the time at which the query is executed on the view.C、 REDO_DATA is the number of bytes of redo data written during the interval.D、 This view contains information about flashback data pertaining to the last 24 hours.E、 FLASHBACK_DATA is the amount of flashback data generated since the database was opened.

考题 Note the output of the following query;   SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;   What is the outcome of this command?()  A、 The table uses the default Flashback Data Archive.B、 The Flashback Data Archive Is created In the SYSAUX tablespace.C、 The Flashback Data Archive is created in the same tablespace where the tables are stored.D、 The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

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

考题 Flashback Database is enabled in your Oracle 10g database. One of your database users erroneously purged an important table residing in his schema. The table was purged sometime between 10:00 P.M. and 10:30 P.M. The next day, you decide to flash back the database. Before you flash back the database, you want to ensure that you have all the necessary flashback data. Which dynamic performance view must you use to determine whether you have the required flashback data to recover the purged table?()A、 V$DATABASEB、 V$UNDOSTATC、 V$FLASHBACK_DATABASE_LOGD、 V$FLASHBACK_DATABASE_STAT

考题 单选题You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you were asked to change the retention from 5 years to 3 years. To accomplish this, you issued the following command:   ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEAR;   What is the implication of this command?()A  The command produces an error because the retention time cannot be reduced.B  All historical data is retained but the subsequent flashback data archives are maintained for only three years.C  All historical data is purged and the new flashback data archives are maintained for three years.D  All historical data older than three years is purged from the flashback archive FLA1.

考题 多选题You can use Oracle Flashback to look at past activity in your database. What are two other characteristics of Oracle Flashback?()AOracle Flashback uses undo information to construct consistent data.BYou can use a cursor opened while using an Oracle Flashback image to perform DML once you deactivate Oracle Flashback in your session.CYou can only use Oracle Flashback view of the data if the required records are still in the online redo log files.DOracle Flashback lists the DML that was executed during the period you identify when initiating your session.

考题 多选题Which two are the prerequisites to enable Flashback Data Archive?()ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

考题 单选题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$DATABASEB  V$FLASHBACK_DATABASE_STATC  V$FLASHBACK_DATABASE_LOGD  V$RECOVERY_FILE_DEST

考题 单选题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.

考题 单选题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 tableC Truncate the table.D Add a column to the table.E Rename a column in the table.

考题 单选题Note the output of the following query;   SQL SELECT flashback_archieve_name, status FROM dba_flashback_archieve; FLASHBACK_ARCHIEVE_NAME STATUS FLA1   You executed the following command to enable Flashback Data Archive on the EXCHANGB_PATE table:   ALTER TABLE exchange_rate FLASHBACK ARCHIEVE;   What is the outcome of this command?()A  The table uses the default Flashback Data Archive.B  The Flashback Data Archive Is created In the SYSAUX tablespace.C  The Flashback Data Archive is created in the same tablespace where the tables are stored.D  The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

考题 单选题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.

考题 多选题Which are the two prerequisites before setting up Flashback Data Archive? ()(Choose two.)AFlash recovery area must be definedBUndo retention guarantee must be enabled.CDatabase must be running in archivelog mode.DAutomatic undo management must be enabled.EThe tablespace in which the Flashback Data Archive is created must have automatic segment space Management (ASSM).

考题 多选题Which two are the prerequisites to enable Flashback Data Archive?() (Choose two.)ADatabase must be running in archivelog mode.BAutomatic undo management must be enabled.CUndo retention guarantee must be enabled.DThe tablespace on which the Flashback Data Archive is created must be managed with Automatic Segment Space Management (ASSM).

考题 多选题These are the details about V$FLASHBACK_DATABASE_STAT: SQL DESC v$FLASHBACK_DATABASE_STAT  Name                    Null?              Type  ------------- -------- --------------  BEGIN_TIME                               DATE  END_TIME                                 DATE  FLASHBACK_DATA                        NUMBER  DB_DATA                                  NUMBER  REDO_DATA                               NUMBER  ESTIMATED_FLASHBACK_SIZE             NUMBER  Which two statements regarding the V$FLASHBACK_DATABASE_STATview aretrue? ()ABEGIN_TIME is the time at which Flashback logging is enabled.BEND_TIME is the time at which the query is executed on the view.CREDO_DATA is the number of bytes of redo data written during the interval.DThis view contains information about flashback data pertaining to the last 24 hours.EFLASHBACK_DATA is the amount of flashback data generated since the database was opened.

考题 单选题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 databaseC 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

考题 单选题You want to track and store all transactional changes to a table over its lifetime. To accomplish this task, you enabled Flashback Data Archive with the retention of 5 years. After some time, the business requirement changed and you are asked to change the retention period from 5 years to 3 years. To accomplish this, you issued the following command: ALTER FLASHBACK ARCHIVE fla1 MODIFY RETENTION 3 YEARS; What is the outcome of this command?()A The command produces an error because the retention period cannot be reducedB All historical data older than 3 years is purged from the flashback archive FLA1C All historical data is retained but the subsequent flashback data archives are maintained for only 3 yearsD All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time