What happens to the new DML operations in this scenario?

View the Exhibit and examine the undo tablespace attributes. Your database instance is
experiencing a large volume of transactions from non-DBA users in the last one hour. The
undo tablespace NDOTBS1 is full with transactions and no transaction was committed more
than one hour ago. The database has two more undo tablespaces. What happens to the
new DML operations in this scenario? What happens to the new DML operations in this
scenario?

View the Exhibit and examine the undo tablespace attributes. Your database instance is
experiencing a large volume of transactions from non-DBA users in the last one hour. The
undo tablespace NDOTBS1 is full with transactions and no transaction was committed more
than one hour ago. The database has two more undo tablespaces. What happens to the
new DML operations in this scenario? What happens to the new DML operations in this
scenario?

A.
The DML commands will fail

B.
The undo data generated by the DML is stored in one of the two other undo tablespace

C.
The undo data generated by the DML will overwrite the extents that contain committed
undo data

D.
The undo data generated by the DML is stored in the SYSTEM undo segment of the
SYSTEM tablespace



Leave a Reply 0

Your email address will not be published. Required fields are marked *