Oracle DBA认证考试存储管理试题及答案
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. 12 : Which background process coalesce the fragmented space
1. SMON
2. PMON
3. DBWR
4. LGWR
1
Q. 13 : Row migration is a result of
1. high PCTFREE
2. low PCTFREE
3. high PCTUSED
4. low PCTUSED
2
-
Oracle归档模式的切换
我们大家都知道在Oracle数据库的实际的测试环境与相关的开发环境中,Oracle数据库的实际应用日志模式与自动Oracle归档模式在一般的情况下是不设置的,其主要目的是利于系统应用的调整,也免的生成大量的归档日志文件将磁盘空间大量的消耗。但在系统上线,成为生产环境...
-
关于Oracle数据库替代加密算法
替代密码算法的原理是使用替代法进行加密,就是将明文中的字符用其它字符替代后形成密文。例如:明文字母a、b、c、d,用D、E、F、G做对应替换后形成密文。这里在Oracle的存储过程,通过替换加密算法来实现密码存入数据库时的加密。1.--------------------------------...
-
Oracle认证:Freebufferwaits等待事件总结
Freebufferwaits1.简述:当数据库要在buffercache中寻找空闲空间来放置数据,但发现空间不足时,就会产生这个等待;2.详述:a)在用户请求块的DBA上应用HASH函数,获得适当的hashbucket;b)检索bucket对应的chain,确认块头是否存在,若存在就使用;c)若不存在,用户进程在LRU链...
-
oracle reports实现报表定长与定宽输出
oraclereports是oracle的数据统计及图形化报表工具,它提供了六种风格的报表格式,而我们通常使用的只有其中的两种,即tabular和matrix,无论用哪种风格生成的报表,打印出的表格数都是动态变化的。其中tabular风格的报表,列数固定,而行数不定;matrix风格的报表,行数和列数...