单项选择题

When determining the number of UNDO segments in a database, which of the following choices identifies a factor to consider? （）

A.Size of typical transactions
B.Concurrent transactions
C.Size of rows in table most frequently changed
D.Number of anticipated disk sorts

点击查看答案

上一题目录下一题

相关考题

单项选择题

You are trying to determine how many disk sorts are happening on the database right now. Which of the following dictionary tables would you use to find that information?（）

A.V$SESSION
B.V$SYSSTAT
C.DBA_SEGMENTS
D.V$SORT_USAGE

单项选择题

To determine the space allocated for temporary segments, the DBA can access which of the following views? （）

A.DBA_TABLESPACES
B.DBA_TABLES
C.DBA_SEGMENTS
D.DBA_FREE_SPACE

单项选择题

By default, checkpoints happen at least as often as（）.

A.Redo log switches.
B.UPDATE statements are issued against the database.
C.The SYSTEM tablespace is accessed.
D.SMON coalesces free space in a tablespase.