OracleDBA回滚段管理试题

发布时间:2018-08-15 编辑: 手机版

  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

最新推荐
热门推荐