niusouti.com

多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in th

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

相似考题

1.Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()A. point-in-time recoveryB. execute the ROLLBACK command with transaction numberC. flashback the database to before the transaction was committedD. determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

2.Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ？（）A、 If you select a non-XA JDBC driver， you can use WebLogic AQ JMS in both local & global transactionsB、 Oracle WebLogic Server requires a JDBC driver to communicate with the Oracle AQ JMSC、 Oracle WebLogic AQ JMS stand-alone client automatically participate in global transactions managed by Oracle WebLogic ServerD、 If you select an XA JDBC driver， you can use WebLogic AQ JMS in both local and global transactions

3. You executed the following query：  SELECT operation， undo_sql， table_name FROM flashback_transaction_query； Which statement is correct regarding the query output？（）A、 It would return information regarding only the last committed transaction.B、 It would return only the active transactions in all the undo segments in the database.C、 It would return only the committed transactions in all the undo segments in the database.D、 It would return both active and committed transactions in all the undo segments in the database.E、 It would return information regarding the transactions that began and were committed in the last 30 minutes.

4.Which two statements are true regarding undo tablespaces（）A、The database can have more than one undo tablespace.B、The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.C、Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.D、An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.

更多“多选题Which two statements are true regarding transactions in an Oracle database（）AMultiple transactions can use the same undo segment.BA transaction is assigned an undo segment when it is started.CMore than one transaction cannot share the same extent in th”相关问题

  • 第1题：

    You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）

    • A、 VERSIONS_STARTSCN
    • B、 VERSIONS_STARTTIME
    • C、 VERSIONS_XID
    • D、 VERSIONS_OPERATION

    正确答案:C

  • 第2题：

    You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future（）

    • A、Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.
    • B、Use Database Resource Manager to automatically log out sessions that block others and are idle.
    • C、Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.
    • D、Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction

    正确答案:A,B

  • 第3题：

    What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）

    • A、It is NOT possible to switch unless no active transaction exist in UNDO1. 
    • B、It is possible to switch to UNDO2； but current active transactions will abort. 
    • C、It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. 
    • D、It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.

    正确答案:D

  • 第4题：

    Which two statements about Flashback Query are true？（）

    • A、It is generated by using the redo log files. 
    • B、It helps in row-level recovery from user errors.
    • C、It can be performed to recover ALTER TABLE statements 
    • D、It fails when undo data pertaining to the transaction is overwritten.
    • E、The database has to be opened with the resetlogs option after performing Flashback Query.

    正确答案:B,D

  • 第5题：

    You work as a database administrator at Certkiller .com. You are working in an online transaction processing （OLTP） environment. You realize that the salary for an employee， John， has been accidentally modified in the EMPLOYEEStable. Two days ago， the data was in the correct state. Flashback logs generated during last two days are available in the flash recovery area. Which option would you choose to bring the data to the correct state while ensuring that no other data in the same table is affected？（）

    • A、 perform point-in-time recovery
    • B、 perform a Flashback Table operation to restore the table to the state it was in two days ago
    • C、 perform a Flashback Database operation to restore the database to the state it was in two days ago
    • D、 perform Flashback Versions Query and Flashback Transaction Query to determine all the necessary undo SQL statements， and then use them for recovery

    正确答案:D

  • 第6题：

    Which three statements are true regarding the logical structure of the Oracle database？（）

    • A、Each segment contains one or more extents.
    • B、Multiple tablespaces can share single data file.
    • C、A data block is the smallest unit of I/O for data files.
    • D、It is possible to have tablespaces of different block sizes in a database.
    • E、Each data block in the database always corresponds to one OS block.

    正确答案:A,C,D

  • 第7题：

    多选题
    Which three statements are true regarding the logical structure of the Oracle database？（）
    A

    Each segment contains one or more extents.

    B

    Multiple tablespaces can share single data file.

    C

    A data block is the smallest unit of I/O for data files.

    D

    It is possible to have tablespaces of different block sizes in a database.

    E

    Each data block in the database always corresponds to one OS block.


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

  • 第8题：

    多选题
    Which two statements regarding the FLASHBACK_TRANSACTION_QUERY view are correct?（）
    A

    You can find information about only active transactions from the view

    B

    You can find information about read only transactions from the view

    C

    You require the SELECT ANY TRANSACTION system privilege to access the view

    D

    You can find information about both active and committed transactions from the view

    E

    You require the SELECT ON FLASHBACK_TRANSACTION_QUERY object privilege to access the view


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

  • 第9题：

    多选题
    Which two statements are true regarding undo tablespaces（）
    A

    The database can have more than one undo tablespace.

    B

    The UNDO_TABLESPACE parameter is valid in both automatic andmanualundo management.

    C

    Undo segments automatically grow and shrink as needed， acting as circular storage buffer for their assigned transactions.

    D

    An undotablespaceis automatically created if the UNDO_TABLESPACEparameter is not set and the UNDO_MANAGEMENT parameter is set to AUTO during the database instance start up.


    正确答案： C,B
    解析： A答案：可以有一个或多个undo表空间，A答案正确。 
    sys@TEST0924> select TABLESPACE_NAME，CONTENTS from dba_tablespaces； TABLESPACE_NAME CONTENTS ------------------------------ --------- SYSTEM PERMANENT SYSAUX PERMANENT UNDOTBS1 UNDO TEMP TEMPORARY USERS PERMANENT UNDOTBS2 UNDO 
    EXAMPLE PERMANENT LXTBS PERMANENT FLA_TBS1 PERMANENT FLA_TBS2 PERMANENT 10 rows selected. 
    B答案：UNDO_TABLESPACE只能用于自动undo段模式，B答案错误

  • 第10题：

    多选题
    Which two statements are TRUE regarding Coherence Indexes ？ （）
    A

    indexes are maintained by cache entry ownes

    B

    an application should not suggest an index that another aplication had suggested

    C

    indexes cannot be sorted

    D

    each application using Coherence may suggest the same set of indexes when it starts


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

  • 第11题：

    多选题
    Which two statements about Flashback Query are true？（）
    A

    It is generated by using the redo log files.

    B

    It helps in row-level recovery from user errors.

    C

    It can be performed to recover ALTER TABLE statements

    D

    It fails when undo data pertaining to the transaction is overwritten.

    E

    The database has to be opened with the resetlogs option after performing Flashback Query.


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

  • 第12题：

    多选题
    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）
    A

    The batch operation started by the user， SCOTT， terminates with an error.

    B

    The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.

    C

    The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.

    D

    The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.

    E

    The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.


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

  • 第13题：

    Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?（）

    • A、point-in-time recovery
    • B、execute the ROLLBACK command with transaction number
    • C、flashback the database to before the transaction was committed
    • D、determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery

    正确答案:D

  • 第14题：

    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

  • 第15题：

    You set the undo pool resource plan directive for the consumer group named DSS_USERS that is assigned to the DAY_SHIFT plan. The database users， SCOTT and BLAKE， belong to the DSS_USERS resource group. The user， SCOTT， initiates a database session and executes a batch operation that inserts millions of rows into the HISTORY table. Which two options are true if the total undo space allocated to the DSS_USERS group exceeds the value specified in the undo pool resource plan directive？（）

    • A、 The batch operation started by the user， SCOTT， terminates with an error.
    • B、 The batch operation started by the user， SCOTT， hangs and you are required to increase the undo pool resource plan directive.
    • C、 The batch operation started by the user， SCOTT， runs uninterrupted because the database uses the SYSTEM tablespace for the undo operation.
    • D、 The user， BLAKE， cannot start a transaction that uses any DML operations until you increase the value of the undo pool resource plan directive.
    • E、 The user BLAKE can start a transaction that uses any DML operations after the batch operation started by the user， SCOTT， terminates with an error.

    正确答案:A,D

  • 第16题：

    When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）

    • A、Size of typical transactions 
    • B、Concurrent transactions 
    • C、Size of rows in table most frequently changed 
    • D、Number of anticipated disk sorts

    正确答案:B

  • 第17题：

    Which three statements are true about database recovery operations？（）

    • A、Damaged or lost data files are restored from backups.
    • B、Redo log file entries are used to roll forward the database.
    • C、Undo segments are used to roll back any uncommitted transactions.
    • D、Transactions that were active when the failure occurred are restarted.
    • E、Transactions that were active when the failure occurred are automatically committed during the recover procedure.

    正确答案:A,B,C

  • 第18题：

    单选题
    You are maintaining your OLTP database in Oracle10g. You are performing the Flashback Transaction Query to find the undo SQL statements that can be used to undo the changes made to the database in the specific time period. Which pseudocolumn will you use to perform the Flashback Transaction Query？（）
    A

     VERSIONS_STARTSCN

    B

     VERSIONS_STARTTIME

    C

     VERSIONS_XID

    D

     VERSIONS_OPERATION


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

  • 第19题：

    多选题
    You receive complaints from users regarding the high waiting time for their transactions. Oninvestigation， you find that some users are not committing their transactions though they are  notperforming any activity for a long time. As a result， SQL statements need to wait for row-level locks.  Which two actions could you take to prevent this locking problem in the future（）
    A

    Decrease the IDLE_TIME resource limit in the profile assigned to the blocking users.

    B

    Use Database Resource Manager to automatically log out sessions that block others and are idle.

    C

    Set the limit in the profile of blocking users to control the number of blocks to be accessed in a session.

    D

    Decrease the maximum number of interested transaction list （ITL） slots for the segments on which the blocking user performs the transaction


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

  • 第20题：

    多选题
    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
    解析： 暂无解析

  • 第21题：

    单选题
    Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions？（）
    A

     point-in-time recovery

    B

     execute the ROLLBACK command with transaction number

    C

     flashback the database to before the transaction was committed

    D

     determine all the necessary undo SQL statements from FLASHBACK_TRANSACTION_QUERY and use them for recovery


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

  • 第22题：

    单选题
    You executed the following query： SELECT operation， undo_sql， table_name FROM flashback_transaction_query；  Which statement is correct regarding the query output？（）
    A

    It would return information regarding only the last committed transaction.

    B

    It would return only the active transactions in all the undo segments in the database.

    C

    It would return only the committed transactions in all the undo segments in the database.

    D

    It would return both active and committed transactions in all the undo segments in the database.

    E

    It would return information regarding the transactions that began and were committed in the last 30 minutes.


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

  • 第23题：

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


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

  • 第24题：

    单选题
    What is true if you want to switch undo tablespaces from the current one， called UNDO1， to a new one called UNDO2？（）
    A

    It is NOT possible to switch unless no active transaction exist in UNDO1. 

    B

    It is possible to switch to UNDO2； but current active transactions will abort. 

    C

    It is possible to switch to UNDO2； current active transactions will be automatically migrated to UNDO2. 

    D

    It is possible to switch to UNDO2； only current active transactions will continue to execute inside UNDO1.


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

相关内容