单项选择题

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

点击查看答案

上一题目录下一题

相关考题

单项选择题

Which of the following choices correctly describes the difference between a data load via the conventional path and the direct path?（）

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

单项选择题

Records from the data dictionary information are stored in which of the following database memory areas?（）

A.Library cache
B.Row cache
C.Session UGA
D.Buffer cache

单项选择题

If you wanted to find the name and location of your control files, you could find that information in each of the following locations except one. Which is it?（）

A.V_CONTROLFILE_RECORD_SECTION
B.V_CONTROLFILE
C.V$PARAMETER
D.init.ora file