Oracle认证

OracleDBA回滚段管理试题

时间:2024-08-16 19:24:46 Oracle认证 我要投稿
  • 相关推荐

OracleDBA回滚段管理试题

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

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回滚段管理试题】相关文章:

Oracle DBA回滚段管理精选练习(附答案)11-06

OracleDBA面试题汇总10-17

OracleDBA数据库性能进行优化08-03

管理沟通试题及答案09-04

《经营与管理》模拟试题07-01

管理学基础试题05-31

薪酬管理自考试题03-29

管理学基础试题及答案10-21

经营管理技术模拟试题10-26

《药事管理与法规》高频考点试题10-20