單項選擇題

A user issues a SELECT command against the Oracle database. Which of the following choices describes a step that Oracle will execute in support of this statement?（）

A.Acquire locks on table queried
B.Generate redo for statement
C.Fetch data from disk into memory
D.Write changes to disk

你可能感興趣的試題

單項選擇題

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