OracleDBA回滚段管理试题

Oracle DBA也是一名管理人员，因此，也同样要求他在参与战略发展计划以及数据库设计上要有出色的.交际能力。下面是小编整理的关于OracleDBA回滚段管理试题，希望大家认真阅读!

　　Q. 1 : What system privilege is required to create a rollback segment ?

1. Create database

2. Create rollback segment

3. Alter database

4. Create segment

KEY:2

　　Q. 2 : Oracle recommends this number of minimum extents in a rollback segment

1. 0

2. 1

3. 2

4. 3

KEY:3

　　Q. 3 : Oracle recommends that the following segment size when creating a rollback segment

1. INITIAL > NEXT

2. INITIAL = NEXT

3. INITIAL < NEXT

4. NONE OF THE ABOVE

KEY:2

　　Q. 4 : The OPTIMAL parameter for a rollback segment should be set

1. large for long-frequently running transactions, small for short transactions.

2. small for long-frequently running transactions, large for small transactions.

3. small for all transactions

4. large for all transactions

KEY:1

　　Q. 5 : In case of system failure, This type of segment is used to undo the changes

1. Data Segment

2. Temp Segment

3. Redo Segment

4. Rollback Segment