单项选择题

A.ALTER DATABASE B.SET TRANSACTION C.ALTER ROLLBACK SEG……

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

单项选择题InordertoenableremoteadministrationofusersandtablespacesonanOracledatabase,whichofthefollowingtypesoffilesmustexistinthedatabase?（）

A.Password file
B.Initialization file
C.Datafile
D.Control file
E.Nothing - SYSDBA privileges are not required for these actions

单项选择题Youaretryingtoaltertheinitialsegmentsizegiventoatableinadictionary-managedtablespace.Whichofthefollowingkeywordswouldbeusedaspartofthisprocess?（）

A.DROP TABLE
B.ALTER TABLE
C.RESIZE
D.COALESCE