- 相关推荐
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回滚段管理试题】相关文章:
OracleDBA面试题汇总10-17
OracleDBA数据库性能进行优化08-03
管理沟通试题及答案09-04
《经营与管理》模拟试题07-01
管理学基础试题05-31
薪酬管理自考试题03-29
管理学基础试题及答案10-21
经营管理技术模拟试题10-26
《药事管理与法规》高频考点试题10-20