OracleDBA存儲(chǔ)管理筆試題
q. 1 : oracle immediately re-uses the space assigned to row-directory portion of the data block once you delete the corresponding rows.
1. true
2. false
2
q. 2 : which of the following three portions of a data block are collectively called as overhead.
1. table directory, row directory and row data
2. data block header, table diretory and free space
3. table directory, row directory and data blcok header
4. data block header, row data and row header
3
q. 3 : which portion of the data block contains table or index data
1. table directory
2. row directory
3. overhead
4. row data
4
q. 4 : what are the two space management parameters for controling the use of free space in a data block
1. initial and next
2. pctfree and pctused
3. tablespace and storage
4. free space cannot be controlled at block level
2
q. 5 : the maximum number of transactions that a block can support is
1. 100
2. 255
3. 1000
4. unlimited
2
【OracleDBA存儲(chǔ)管理筆試題】相關(guān)文章：
OracleDBA回滾段管理試題08-12
OracleDBA面試題匯總10-12
盤點(diǎn)國(guó)外公司的OracleDBA試題08-12
Oracle DBA認(rèn)證考試存儲(chǔ)管理試題及答案09-23
華為2017筆試題08-16
360筆試題目07-11
華為2017筆試試題08-10
桂林銀行筆試題筆經(jīng)07-20
OracleDBA數(shù)據(jù)庫(kù)性能進(jìn)行優(yōu)化10-19
巧克力的存儲(chǔ)方法10-06