單項選擇題

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）

A. The database will not start.
B. The database will start but will not retain the undo data in the undo segment.
C. The database will start， and the undo segment will contain the undo data for at least one hour.
D. The database will start， and the undo segment will retain the undo data for at least 15 minutes.

你可能感興趣的試題

單項選擇題

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

A. The database must be in the ARCHIVELOG mode.
B. The automatic memory tuning must be enabled.
C. The change tracking feature must be enabled.
D. The automatic memory tuning must be disabled.

單項選擇題

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

A. Memory Advisor
B. Segment Advisor
C. Undo Advisor
D. SQL Tuning Advisor

99色精品-9色在线-99色在线-99色视频 国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）

你可能感興趣的試題

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）

99色精品-9色在线-99色在线-99色视频国产欧美日产一区二区三区_亚洲精品亚洲人成在线观看_四虎在线精品永久观看_免费一级a一片久久精

You are maintaining your database in Oracle10g. You set the value of the UNDO_RETENTION initialization parameter to zero in the initialization parameter file. What will be the impact of specifying this setting？（）

You use the Memory Advisor to tune the memory structures of your database. What is the prerequisite to use the Memory Advisor？（）

While running long running queries， you receive the Snapshot too old error. Which advisor can help you to avoid the Snapshot too old error？（）