单项选择题
You have a long-running process you want to assign to a specific UNDO segment brought online for that express purpose. You are not using automatic UNDO management. What statement can be used for this task? ()
A.ALTER DATABASE
B.SET TRANSACTION
C.ALTER ROLLBACK SEGMENT
D.ALTER TABLE
点击查看答案
相关考题
-
单项选择题
Whichofthefollowingchoicescorrectlydescribesthedifferencebetweenadataloadviatheconventionalpathandthedirectpath?()
A.One runs faster than the other
B.A conventional path data load bypasses most of the Oracle RDBMS, whereas a direct path load is a high-speed version of the SQL INSERT
C.A direct path data load bypasses most of the Oracle RDBMS, whereas a conventional path load is a high-speed version of the SQL INSERT
D.The conventional path runs when the CONVENTIONAL command-line parameter is set to TRUE -
单项选择题
Recordsfromthedatadictionaryinformationarestoredinwhichofthefollowingdatabasememoryareas?()
A.Library cache
B.Row cache
C.Session UGA
D.Buffer cache -
单项选择题
Ifyouwantedtofindthenameandlocationofyourcontrolfiles,youcouldfindthatinformationineachofthefollowinglocationsexceptone.Whichisit?()
A.V_CONTROLFILE_RECORD_SECTION
B.V_CONTROLFILE
C.V$PARAMETER
D.init.ora file
