搜题

【单选题】

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

查看正确答案

更多“ 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?（）”相关的问题

第1题

[多选题] 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).

点击查看答案

第2题

[单选题] 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

点击查看答案

第3题

点击查看答案

第4题

[单选题] Examine the following commands and their output: View the exhibit and examine the Flashback Version Query that was executed after the preceding commands. What could be the possible cause for the query not displaying any row?（）

A、Flashback logging is not enabled for the database. B、The changes made to the table are not committed. C、Supplemental logging is not enabled for the database. D、The database is not configured in ARCHIVELOG mode.

点击查看答案

第5题

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

点击查看答案

第6题

[单选题] 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 reduced B、All historical data older than 3 years is purged from the flashback archive FLA1 C、All historical data is retained but the subsequent flashback data archives are maintained for only 3 years D、All historical data is transferred to flashback logs and the flashback archive is refreshed to set a new retention time

点击查看答案

第7题

[单选题] 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

点击查看答案

第8题

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

点击查看答案

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

[] 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？（） 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 EX

A、A. The table uses the default Flashback Data Archive. B、B. The Flashback Data Archive Is created In the SYSAUX tablespace. C、C. The Flashback Data Archive is created in the same tablespace where the tables are stored. D、D. The command generates an error because no flashback Data Archive name is specified and there is no default Flashback Data Achieve.

点击查看答案

账号：登录

答题记录

我的收藏

我的题库

客服

TOP

请使用微信扫码支付

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