單項(xiàng)選擇題

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 autoextensible
B.When there are more than one undo tablespaces available in the database
C.When the undo tablespace is of a fixed size and retention guarantee is not enabled
D.When the undo tablespace is autoextensible and retention guarantee is not enabled

你可能感興趣的試題

多項(xiàng)選擇題

The user HR receives the following error while inserting data into the TTK table：ERROR at line 1：
ORA-01653： unable to extend table HR.TTK by 128 in tablespace SMD Upon investigation， you find that SMDis a small file tablespace.
Which three action would allow the user to insert data（）

A.Add a data file to the SMD tablespace.
B.Add a data file to the temporary tablespace associated with the user HR.
C.Resize the data file associated with the SMD tablespace to make it larger.
D.Alter the data file associated with the SMD tablespace to grow automatically.
E.Change the segment space management for the SMD tablespace to automatic

單項(xiàng)選擇題

View the Exhibit and examine the attributes of an undo tablespace. In an OLTP system, the user SCOTT hasstarted a query on a large table in the peak transactional hour that performs bulk inserts. The query runs formore than 15 minutes and then SCOTT receives the following error:ORA-01555: snapshot too old
What could be the reason for this error（）

A.The query is unable to get a read-consistent image.
B.There is not enough space in Flash Recovery Area.
C.There is not enough free space in the flashback archive.
D.The query is unable to place data blocks in undo tablespace

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）

你可能感興趣的試題

In which situation is the UNDO_RETENTION parameter be ignored， even if it is set to a value（）