[oracle]Oracle DBA 存储管理试题选
【shitiku.jxxyjl.com--Oracle试题集锦】
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
q. 6 : what is pctfree
1. a space management parameter which sets aside that much percentage of memory in the data block for future update of existing rows.
2. a space management parameter which determines the minimum percentage of a block that can be used for row data plus overhead.
3. a space management parameter which tells oracle that the block is available for inserts after the percentage of used memory falls below certain percentage.
4. all of them
1
q. 7 : what is the default value of next parameter
1. 1 block
2. 2 blocks
3. 5 blocks
4. 100 blocks
3
q. 8 : which parameter reserves the more space for future updates
1. high pctincrease
2. high pctfree
3. high initial
4. high pctused
2
q. 9 : pctfree and pctused together should not exceed
1. 100
2. 50
3. 25
4. 10
1
q. 10 : row migration is a result of
1. not enough space in a block for new rows.
2. not enough memory for sorts
3. not enough space for updates in the current block
4. all of them
3
q. 11 : frequent deallocation of extents result in
1. truncated segments
2. block fragmentation
3. truncated tablespaces
4. tablespace fragmentation
4
q. 13 : row migration is a result of
1. high pctfree
2. low pctfree
3. high pctused
4. low pctused
2
q. 12 : which background process coalesce the fragmented space
1. smon
2. pmon
3. dbwr
4. lgwr
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
q. 6 : what is pctfree
1. a space management parameter which sets aside that much percentage of memory in the data block for future update of existing rows.
2. a space management parameter which determines the minimum percentage of a block that can be used for row data plus overhead.
3. a space management parameter which tells oracle that the block is available for inserts after the percentage of used memory falls below certain percentage.
4. all of them
1
q. 7 : what is the default value of next parameter
1. 1 block
2. 2 blocks
3. 5 blocks
4. 100 blocks
3
q. 8 : which parameter reserves the more space for future updates
1. high pctincrease
2. high pctfree
3. high initial
4. high pctused
2
q. 9 : pctfree and pctused together should not exceed
1. 100
2. 50
3. 25
4. 10
1
q. 10 : row migration is a result of
相关试题
- 【oracledba面试题及答案】OracleDBA启动和关闭例程试选题
- oracledba面试题及答案_OracleDBA数据库结构题选2
- [oracledba面试题及答案]OracleDBA数据库结构试题选
- oracledba面试题及答案|OracleDBA数据库结构试题精选
- oracledba面试题及答案|OracleDBA回滚段管理试选题
- [oracledba面试题及答案]OracleDBA面试题及参考答案
- 【国外公司的财务报表怎么查】国外公司的Oracle DBA试题
- [oracle]Oracle DBA 用户管理试题选
- 【oracle】Oracle DBA 逻辑备份试题选
- 国外某公司的营业部经理是一位年轻的女士_国外某公司的Oracle DBA试题
-
国外某公司的营业部经理是一位年轻的女士_国外某公司的Oracle DBA试题详细阅读
oracle dba interview questions by b g 1 how many memory layers are in the shared pool? 2 how do you find out from the rman catalog if a particular a...
-
【oracledba面试题及答案】OracleDBA创建数据库试题精选详细阅读
q 1 : this symbol, when you put infront of a line in the parameter file, 1 $ 2 @ 3 4 ! q 2 : when you change a parameter value...
-
oracle_Oracle DBA 审计数据库试题选详细阅读
q 1 : what feature in oracle allows you to monitor suspicious activity on the datbase 1 replication 2 auditing 3 monitoring 4 tuning...
-
[oracledba面试题及答案]OracleDBA数据库结构题选1详细阅读
q 1 : physical disk resources in an oracle database are 1 control files 2 redo log files 3 data files 4 all of the above 4 q 2 : wha...