单项选择题

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.

<上一题目录下一题>

热门试题

单项选择题YouusetheMemoryAdvisortotunethememorystructuresofyourdatabase.WhatistheprerequisitetousetheMemoryAdvisor？（）

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.

单项选择题Whilerunninglongrunningqueries，youreceivetheSnapshottooolderror.WhichadvisorcanhelpyoutoavoidtheSnapshottooolderror？（）

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

单项选择题WhichcomponentdoestheSQLTuningAdvisorNOTanalyzefortheSQLstatements？（）

A.ADDM
B.AWR
C.Cursor Cache
D.SQL Tuning Sets
E.Flash Recovery Area

单项选择题Youfindthatsomequeriesonatablearetakingalongtimetoexecutebecausetherearenoindexescreatedonthetable.YoudecidetoinvoketheSQLAccessAdvisortodeterminetheappropriateindextobecreated.WhichpackagewillyouusetoinvoketheSQLAccessAdvisor？（）

A.DBMS_SERVER_ALERT
B.DBMS_ADVISOR
C.DBMS_RESOURCE_MANAGER
D.DBMS_REPAIR

单项选择题YoufindpocketsofemptyspaceintheUSER_DATAtablespaceduetoalotofDMLoperationsontheobjectsintheUSER_DATAtablespace.Thepocketsofemptyspacesaretoosmalltobereusedindividually.Thisisleadingtowastageofspace.Youdecidetoperformtheshrinkoperationtoreclaimthewastedspace.WhichadvisorwillyouusetodeterminetheobjectsintheUSER_DATAtablespacethataregoodcandidatesfortheshrinkoperation？（）

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