搜题
用户您好， 请在下方输入框内搜索其它题目：
搜题
题目内容 （请给出正确答案）
提问人：网友 发布时间：
【单选题】

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$DATABASE

B、 V$UNDOSTAT

C、 V$FLASHBACK_DATABASE_LOG

D、 V$FLASHBACK_DATABASE_STAT

查看正确答案
更多“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？（）”相关的问题
第1题
[单选题] 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.  

点击查看答案
第2题
[单选题] 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  

点击查看答案
第3题
[单选题] Flashback Database relies on which technologies to recover to a point in time？（）  

A、 Flashback Data Archive  B、 Flashback logs in the flash recovery area  C、 FlashbUndo tablespace  D、 RMAN command line  E、 None of the above  

点击查看答案
第4题
[单选题] 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  

点击查看答案
第5题
[] You are required to flashback your database. You want to find the amount of flashback data generated since the database was opened. Which task will you perform to obtain the required information？（）

A、A. Query the V$FLASHBACK_DATABASE_LOG view.  B、B. Query the V$FLASHBACK_DATABASE_STAT view.  C、C. Check the value of the DB_FLASHBACK_RETENTION_TARGET initialization parameter.  D、D. Query the V$RECOVERY_FILE_DEST view.  

点击查看答案
第6题
[多选题] 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.   

点击查看答案
第7题
[多选题] Which two statements regarding the Flashback Table feature are correct？（）

A、 Flashback Table can be performed on system tables.  B、 Flashback Table operation does not shrink the segments.  C、 Flashback Table uses log mining to extract SQL_REDO and SQL_UNDO statements.  D、 Flashback Table operation acquires exclusive data manipulation language （DML） locks.  

点击查看答案
第8题
[单选题] 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.   

点击查看答案
第9题
[] You enabled Flashback Data Archive on the INVENTORY table. Which DDL operation is supported on the table after enabling Flashback Data Archive？（）  

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

点击查看答案
账号：
答题记录 我的收藏 我的题库
客服
TOP

请使用微信扫码支付

订单号：
遇到问题请联系在线客服