OracleDBA回滾段管理試題
Oracle DBA也是一名管理人員，因此，也同樣要求他在參與戰(zhàn)略發(fā)展計(jì)劃以及數(shù)據(jù)庫(kù)設(shè)計(jì)上要有出色的交際能力。下面是小編整理的關(guān)于OracleDBA回滾段管理試題，希望大家認(rèn)真閱讀!
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回滾段管理試題】相關(guān)文章：
企業(yè)危機(jī)管理六階段10-31
管理學(xué)基礎(chǔ)試題及答案03-07
網(wǎng)絡(luò)管理員試題10-24
管理學(xué)基礎(chǔ)試題及答案03-03
經(jīng)營(yíng)管理技術(shù)模擬試題03-08
藥品經(jīng)營(yíng)質(zhì)量管理規(guī)范試題03-12
薪酬管理考試題庫(kù)12-17