多选题Which of the following Oracle features utilize the undo tablespace？（）AFlashback QueryBFlashback DropCFlashback TableDFlashback DatabaseETransaction ProcessingFRecycle Bin

题目
多选题
Which of the following Oracle features utilize the undo tablespace？（）
A

Flashback Query

B

Flashback Drop

C

Flashback Table

D

Flashback Database

E

Transaction Processing

F

Recycle Bin

相似考题

1.You executed the following commands in a database session:What could have caused the recycle bin to clean up?()A. There is demand for space from the new table从B. The undo tablespace does not have sufficient free spaceC. The new table name is the same as the table name in the recycle binD. The temporary tablespace that is assigned to you does not have sufficient free space

2.When an UNDO segment is created manually by you, its availability status is set to which of the following automatically by Oracle?（）A、Online B、Pending online C、Offline D、Stale

3.In which situation may the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A、when the data file of the undo tablespace is autoextensibleB、when there are more than one undo tablespaces available in the databaseC、when the undo tablespace is of a fixed size and retention guarantee is not enabledD、when the undo tablespace is autoextensible and retention guarantee is not enabled

4.In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）A、When the data file of the undo tablespace is autoextensibleB、When there are more than one undo tablespaces available in the databaseC、When the undo tablespace is of a fixed size and retention guarantee is not enabledD、When the undo tablespace is autoextensible and retention guarantee is not enabled

更多“多选题Which of the following Oracle features utilize the undo tablespace？（）AFlashback QueryBFlashback DropCFlashback TableDFlashback DatabaseETransaction ProcessingFRecycle Bin”相关问题

  • 第1题：

    Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）

    • A、The extents in undo tablespace retain data until the next full database backup.
    • B、The extents containing committed data in the undo tablespace are never overwritten.
    • C、The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.
    • D、The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.

    正确答案:C

  • 第2题：

    Which two statements are true regarding transactions in an Oracle database（）

    • A、Multiple transactions can use the same undo segment.
    • B、A transaction is assigned an undo segment when it is started.
    • C、More than one transaction cannot share the same extent in the undo tablespace.
    • D、The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.

    正确答案:A,B

  • 第3题：

    Which of the following statements are true regarding the Recycle Bin？（）

    • A、 The Recycle Bin is a physical storage area for dropped objects.
    • B、 The Recycle Bin is a logical container for dropped objects.
    • C、 The Recycle Bin stores the results of a Flashback Drop operation.
    • D、 The objects in the Recycle Bin are stored in the tablespace in which they were created.

    正确答案:B,D

  • 第4题：

    Which of the following Oracle features utilize the undo tablespace？（） 

    • A、 Flashback Query
    • B、 Flashback Drop
    • C、 Flashback Table
    • D、 Flashback Database
    • E、 Transaction Processing
    • F、 Recycle Bin

    正确答案:A,C,E

  • 第5题：

    Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）

    • A、The extents in the undo tablespace retain data until the next full database backup.
    • B、The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.
    • C、The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.
    • D、The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.

    正确答案:B

  • 第6题：

    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

  • 第7题：

    单选题
    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）
    A

     An SCN is never used to perform a Flashback Table recovery.

    B

     If a significant number of changes have been made to the table， row movement must be enabled.

    C

     The tablespace must be offline before performing a Flashback Table recovery.

    D

     Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.


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

  • 第8题：

    多选题
    Identify three situations in which you would NOT be able to drop a tablespace. （）
    A

    when the tablespace is online

    B

    when the tablespace has segments with data in it

    C

    when the tablespace is a default permanent tablespace for the database

    D

    when the tablespace contains a table that is currently being used by transactions

    E

    when the tablespace contains undo data that is needed to rollback an uncommitted transaction


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

  • 第9题：

    多选题
    Which of the following Oracle features utilize the undo tablespace？（）
    A

    Flashback Query

    B

    Flashback Drop

    C

    Flashback Table

    D

    Flashback Database

    E

    Transaction Processing

    F

    Recycle Bin


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

  • 第10题：

    多选题
    Which of the following statements are true regarding the Recycle Bin？（）
    A

    The Recycle Bin is a physical storage area for dropped objects.

    B

    The Recycle Bin is a logical container for dropped objects.

    C

    The Recycle Bin stores the results of a Flashback Drop operation.

    D

    The objects in the Recycle Bin are stored in the tablespace in which they were created.


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

  • 第11题：

    多选题
    Which of the following protocols utilize UDP as the layer 4 transport mechanism?（）
    A

    TACACS

    B

    Telnet

    C

    SMTP

    D

    SNMP

    E

    HTTP

    F

    TFTP


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

  • 第12题：

    多选题
    Which of the following protocols utilize TCP?（）
    A

    NTP

    B

    NNTP

    C

    SMTP

    D

    SNMP

    E

    HTTPS

    F

    TFTP


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

  • 第13题：

    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）

    • A、 undo tablespace
    • B、 index tablespace
    • C、 read-only tablespace
    • D、 temporary tablespace

    正确答案:D

  • 第14题：

    Which tablespaces are mandatory in an Oracle database for it to be operational（）

    • A、Undo tablespace
    • B、USERS tablespace
    • C、SYSAUX tablespace
    • D、SYSTEM tablespace
    • E、Temporary tablespace

    正确答案:C,D

  • 第15题：

    Connection Manager features cannot be used with which of the following naming method？ （）

    • A、Oracle names
    • B、Local Naming
    • C、Host Naming
    • D、Names Server

    正确答案:C

  • 第16题：

    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）

    • A、Set the UNDO_RETENTION parameter to 900 or more.
    • B、Create an initial undo segment in the undo tablespace.
    • C、Enable the retention guarantee for the undo tablespace.
    • D、Set the UNDO_TABLESPACE parameter to UNDO_TBS1.
    • E、Set the UNDO_MANAGEMENT initialization parameter to AUTO.

    正确答案:D,E

  • 第17题：

    Which of the following operations does not require Oracle to store information in an UNDO segments as part of the transaction?（）

    • A、INSERT 
    • B、SELECT 
    • C、UPDATE 
    • D、DELETE

    正确答案:B

  • 第18题：

    Which of the following statements is true regarding implementing a Flashback Table recovery？  （）

    • A、 An SCN is never used to perform a Flashback Table recovery.
    • B、 If a significant number of changes have been made to the table， row movement must be enabled.
    • C、 The tablespace must be offline before performing a Flashback Table recovery.
    • D、 Flashback Table recovery is completely dependent on the availability of undo data in the undo  tablespace.

    正确答案:D

  • 第19题：

    单选题
    AUM has been retaining about 15 minutes worth of undo. You want to double the retentionperiod， but not at the expense of new transactions failing. You decide to alter the system to set the parameter UNDO_RETENTION=18000. However， AUM still retains only about 15 minutes worth of undo.  What is the problem？ （）
    A

     You need to alter the undo tablespace to add the RETENTION GUARANTEE setting.

    B

     You need to increase the size of the undo tablespace.

    C

     The undo tablespace is not set to auto-extend.

    D

     You need to alter the Recycle Bin to add the RETENTION GUARANTEE setting.


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

  • 第20题：

    单选题
    Your database instance is configured with automatic undo management and the UNDO_RETENTION parameter is set to 900 seconds. You executed the following command to enable retention guarantee： SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE； What effect would this command have on the database（）
    A

    The extents in the undo tablespace retain data until the next full database backup.

    B

    The extents containing committed undo in the undo tablespace are not overwritten for at least 15minutes.

    C

    The extents containing committed data in the undo tablespace are not overwritten until the instance isshut down.

    D

    The extents containing committed undo in the undo tablespace are transferred to Flash Recovery Areabefore being overwritten.


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

  • 第21题：

    单选题
    Your database contains a temporary tablespace， index tablespace， undo tablespace， and a read-only tablespace apart from the SYSTEM and SYSAUX tablespaces. If a media failure occurs resulting in the loss of any of these tablespaces， which tablespace is NOT required for the database to start？（）
    A

     undo tablespace

    B

     index tablespace

    C

     read-only tablespace

    D

     temporary tablespace


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

  • 第22题：

    多选题
    Which two statements are true regarding transactions in an Oracle database（）
    A

    Multiple transactions can use the same undo segment.

    B

    A transaction is assigned an undo segment when it is started.

    C

    More than one transaction cannot share the same extent in the undo tablespace.

    D

    The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.


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

  • 第23题：

    单选题
    Your database is running under automatic undo management and the UNDO_RETENTION parameter is set to 900 sec. You executed the following command to enable retention guarantee：  SQL> ALTER TABLESPACE undotbs1 RETENTION GUARANTEE;  What effect would this statement have on the database？（）
    A

    The extents in undo tablespace retain data until the next full database backup.

    B

    The extents containing committed data in the undo tablespace are never overwritten.

    C

    The extents which no longer contain uncommitted data in the undo tablespace are not overwritten for at least15 minutes.

    D

    The extents containing committed data in the undo tablespace are not overwritten until the instance  is shut down.


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

  • 第24题：

    多选题
    You require the Oracle server to manage the undo segments and space among various active sessions automatically. You created an undo tablespace， UNDO_TBS1， in your database. Which two additional steps would you perform to achieve this？（）
    A

    Set the UNDO_RETENTION parameter to 900 or more.

    B

    Create an initial undo segment in the undo tablespace.

    C

    Enable the retention guarantee for the undo tablespace.

    D

    Set the UNDO_TABLESPACE parameter to UNDO_TBS1.

    E

    Set the UNDO_MANAGEMENT initialization parameter to AUTO.


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

相关内容