Multiple transactions can use the same undo segment.
A transaction is assigned an undo segment when it is started.
More than one transaction cannot share the same extent in the undo tablespace.
The transactions use system undo segment to store undo data if all the segments in the undo tablespaceare used.
第1题:
Which two statements are true about interoperating with Oracle AQ JMS with Oracle WebLogic server ?()
第2题:
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?()
第3题:
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
第4题:
What is true if you want to switch undo tablespaces from the current one, called UNDO1, to a new one called UNDO2?()
第5题:
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()
第6题:
You executed the following query: SELECT operation, undo_sql, table_name FROM flashback_transaction_query; Which statement is correct regarding the query output?()
第7题:
Which method would you use to undo the changes made by a particular transaction without affecting the changes made by other transactions?()
第8题:
Which two statements are true regarding undo tablespaces()
第9题:
Which two statements are true regarding transactions in an Oracle database()
第10题:
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?()