单选题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 d

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

相似考题

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

2.You opened the encryption wallet and then issued the following command:Then you closed the wallet. Later, you issued the following command to create the EMPLOYEES table in the SECURESPACE tablespace and you use the NO SALT option for the EMPID column.What is the outcome?（）A. It creates the table and encrypts the data in it.B. It generates an error because the wallet is closed.C. It creates the table but does not encrypt the data in it.D. It generates an error because the NO SALT option cannot be used with the ENCRYPT option.

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

4.Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command:ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS;What would be the outcome of this command?（）A. It produces an error because data already exists in the table.B. It produces an error because compression can be enabled at table creation only.C. It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.D. It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.

更多“单选题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 d”相关问题

  • 第1题：

    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

    正确答案:D

  • 第2题：

    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

    正确答案:B

  • 第3题：

    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.

    正确答案:D

  • 第4题：

    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.

    正确答案:A

  • 第5题：

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


    正确答案： D
    解析： 暂无解析

  • 第6题：

    单选题
    Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command：   ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS；   What would be the outcome of this command？（）
    A

     It produces an error because data already exists in the table.

    B

     It produces an error because compression can be enabled at table creation only.

    C

     It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

    D

     It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.


    正确答案： C
    解析： 暂无解析

  • 第7题：

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


    正确答案： C
    解析： 暂无解析

  • 第8题：

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


    正确答案： C
    解析： 暂无解析

  • 第9题：

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


    正确答案： D
    解析： 暂无解析

  • 第10题：

    多选题
    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


    正确答案： A,D
    解析： 暂无解析

  • 第11题：

    单选题
    Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space, you issued the following command: ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS; What would be the outcome of this command?（）
    A

    It produces an error because data already exists in the table.

    B

    It produces an error because compression can be enabled at table creation only.

    C

    It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.

    D

    It immediately compresses all existing data as well as new data, resulting from either fresh additions or modifications to existing data.


    正确答案： B
    解析： 暂无解析

  • 第12题：

    单选题
    You issued the following command to mount the DATA disk group in restricted mode：   ALTER DISKGROUP data MOUNT RESTRICT；   What is the implication of this command？（）
    A

     The client RDBMS instance can access the file as a read-only file.

    B

     A new disk cannot be added to a disk group.

    C

     A disk in a disk group can be taken offline.

    D

     The client RDBMS instance cannot access the files in the disk group.


    正确答案： D
    解析： 暂无解析

  • 第13题：

    You issued the following command to drop the PRODUCTS table: SQL> DROP TABLE products; What is the implication of this command?（）

    • A、All data along with the table structure is deleted 
    • B、The pending transaction in the session is committed 
    • C、All indexes on the table will remain but they are invalidated 
    • D、All views and synonyms will remain but they are invalidated 
    • E、All data in the table are deleted but the table structure will remain

    正确答案:A,B,D

  • 第14题：

    Sales details are being stored on a daily basis in the SALES_2007 table. A large amount of data is added to the table daily. To save disk space，you issued the following command：   ALTER TABLE sales_2007 COMPRESS FOR ALL OPERATIONS；   What would be the outcome of this command？（）

    • A、 It produces an error because data already exists in the table.
    • B、 It produces an error because compression can be enabled at table creation only.
    • C、 It compresses all data added or modified henceforth but the existing data in the table is not compressed immediately.
    • D、 It immediately compresses all existing data as well as new data， resulting from either fresh additions or modifications to existing data.

    正确答案:C

  • 第15题：

    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. 

    正确答案:D

  • 第16题：

    You issued the following command to mount the DATA disk group in restricted mode：   ALTER DISKGROUP data MOUNT RESTRICT；   What is the implication of this command？（）

    • A、 The client RDBMS instance can access the file as a read-only file.
    • B、 A new disk cannot be added to a disk group.
    • C、 A disk in a disk group can be taken offline.
    • D、 The client RDBMS instance cannot access the files in the disk group.

    正确答案:D

  • 第17题：

    单选题
    Your multitenant container database (CDB) contains pluggable databases (PDBs), you are connected to the HR_PDB. You execute the following command: SQL > CREATE UNDO TABLESPACE undotb01 DATAFILE ‘u01/oracle/rddb1/undotbs01.dbf’ SIZE 60M AUTOEXTEND ON; What is the result?（）
    A

    It executes successfully and creates an UNDO tablespace in hr_pdb.

    B

    It falls and reports an error because there can be only one undo tablespace in a cdb.

    C

    It fails and reports an error because the CONTAINER=ALL clause is not specified in the command.

    D

    It fails and reports an error because the CONTAINER=CURRENT clause is not specified in the command.

    E

    It executes successfully but neither tablespace nor the data file is created.


    正确答案： E
    解析： 暂无解析

  • 第18题：

    单选题
    You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group ，you issued the following ASMCMD command：   ASMCMD> lsdsk -I -d DATA   Which statement is true regarding the outcome of this command？（）
    A

     The command succeeds but it retrieves only the disk names.

    B

     The command produces an error because the ASM instance is down.

    C

     The command succeeds but it shows only the status of the ASM instance.

    D

     The command succeeds and retrieves information by scanning the disk headers based on an  ASM_DISKSTRING  value.


    正确答案： B
    解析： 暂无解析

  • 第19题：

    单选题
    The INV_HISTORY table is created using the command: You would like to store the data belonging to the year 2006 in a single partition and issue the command: What would be the outcome of this command? （）
    A

    It executes successfully, and the transition point is set to '1-apr-2006'.

    B

    It executes successfully, and the transition point is set to '15-apr-2006'.

    C

    It produces an error because the partitions specified for merging are not adjacent.

    D

    It produces an error because the date values specified in the merge do not match the date values stored in the table.


    正确答案： D
    解析： 暂无解析

  • 第20题：

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


    正确答案： D
    解析： 暂无解析

  • 第21题：

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


    正确答案： B
    解析： 暂无解析

  • 第22题：

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


    正确答案： B
    解析： 暂无解析

  • 第23题：

    单选题
    You are managing an Oracle Database 11g instance with ASM storage. The ASM instance is down. To know the details of the disks in the DATA disk group , you issued the following ASMCMD command: ASMCMD> lsdsk -I -d DATA Which statement is true regarding the outcome of this command?（）
    A

    The command succeeds but it retrieves only the disk names.

    B

    The command produces an error because the ASM instance is down.

    C

    The command succeeds but it shows only the status of the ASM instance.

    D

    The command succeeds and retrieves information by scanning the disk headers based on an ASM_DISKSTRING value.


    正确答案： D
    解析： 暂无解析

  • 第24题：

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


    正确答案： B
    解析： 暂无解析

相关内容