解析后的SQL语句在SGA中的哪一个组件中进行缓存( )。
A: DATABASE BUFFER
B: DATA DICTIONARY BUFFER
C: LIBRARY BUFFER
D: LARGE POOL
A: DATABASE BUFFER
B: DATA DICTIONARY BUFFER
C: LIBRARY BUFFER
D: LARGE POOL
A
举一反三
- SQL语句的编译和执行是在SGA的哪一部分中进行的（） A: ADatabase Buffer Cache B: BRedo Log Buffer C: CShared Pool D: DLarge Pool E: EJava Pool
- 下面哪部分内存区域在sga中还不能自动管理？（） A: data buffer B: shared pool C: java pool D: log buffer
- 下列（ ）语句可以实现取数据的个位。 A: buffer[0] = data/100 B: buffer[0] = data%100/10 C: buffer[0] = data%10 D: buffer[0] = data%1000
- 下列()语句可以实现取数据的个位 A: buffer[0]=data/100 B: buffer[0]=data%100/10 C: buffer[0]=data%10
- Which is the correct description of a pinned buffer in the database buffer cache（） A: The buffer is currently being accessed. B: The buffer is empty and has not been used. C: The contents of the buffer have changed and must be flushed to the disk by the DBWn process. D: The buffer is a candidate for immediate aging out and its contents are synchronized with the block contents on the disk.
内容
- 0
Regarding the determination of the effective buffer range of the buffer solution, which of the following is not the factor we should consider A: pH= pKa±1 B: The buffer ratio is between 0.1 and 10 C: Large buffer capacity D: High total concentration
- 1
假设累加器A=556789ABCDh，则指令STH A , -4 , BUFFER执行后BUFFER中的值为 ______ ，指令STL A , 4 , BUFFER执行后BUFFER中的值为______ 。
- 2
（） is typically not referred to as a buffer type in critical chain project management． A: Resource buffer B: Free buffer C: Feed buffer D: Project buffer
- 3
在执行“LEA BX,BUFFER”指令时,是把( )。 A: BUFFER的内容èBX B: BUFFER的偏移量èBX C: BUFFER的段基值èBX D: BUFFER的内容èEA
- 4
语句“buffer byte 12 dup(0)”为变量buffer预留了：