- 相关推荐
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数据库性能进行优化06-11
企业危机管理六阶段10-31
管理学基础试题及答案03-07
健康管理师考试模拟试题02-26
企业战略管理期末试题及答案05-15
物流管理试题及参考答案02-26
薪酬管理考试题库12-17
《企业战略管理》期末试题及答案01-10
物业管理师《物业管理实务》章节试题12-28
2016专升本管理学模拟试题及答案03-10