Oracle认证 百分网手机站

OracleDBA回滚段管理试题

时间:2017-05-24 15:40:23 Oracle认证 我要投稿

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

【OracleDBA回滚段管理试题】相关文章:

1.Oracle DBA回滚段管理精选练习(附答案)

2.OracleDBA面试题汇总

3.盘点国外公司的OracleDBA试题

4.OracleDBA数据库性能进行优化

5.高尔夫果岭切滚挥杆技巧

6.企业危机管理六阶段

7.绩效管理四阶段分析

8.管理学基础试题