• 2022-06-07
    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.
  • A

    内容

    • 0

      The more the total concentration of a buffer, the more its buffer capacity at 298K. A: 正确 B: 错误

    • 1

      In the bounded buffer problem ____________ A: there is only one buffer B: there are n buffers ( n being greater than one but finite) C: there are infinite buffers D: the buffer size is bounded

    • 2

      在执行“LEA BX,BUFFER”指令时,是把( )。 A: BUFFER的内容èBX B: BUFFER的偏移量èBX C: BUFFER的段基值èBX D: BUFFER的内容èEA

    • 3

      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

    • 4

      解析后的SQL语句在SGA中的哪一个组件中进行缓存( )。 A: DATABASE BUFFER B: DATA DICTIONARY BUFFER C: LIBRARY BUFFER D: LARGE POOL