解析后的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
举一反三
- 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.