nerdexam
Oracle

1Z0-054 · Question #116

View the Exhibit and examine the output for the query on V$IOSTAT_FUNCTION. Which two statements are true about the interpretation of the output? (Choose two.)

The correct answer is B. The I/O statistics are for single block or multi-block read and write operations. C. If there is a conflict of I/O functions, the I/O is placed in the bucket with the lower FUNCTION_ID. See the full explanation below for the reasoning.

Question

View the Exhibit and examine the output for the query on V$IOSTAT_FUNCTION. Which two statements are true about the interpretation of the output? (Choose two.)

Exhibit

1Z0-054 question #116 exhibit

Options

  • AThe I/O statistics are only for the single block read and write operations.
  • BThe I/O statistics are for single block or multi-block read and write operations.
  • CIf there is a conflict of I/O functions, the I/O is placed in the bucket with the lower FUNCTION_ID.
  • DIf there is a conflict of I/O functions, the I/O is placed in the bucket with the higher FUNCTION_ID.

How the community answered

(50 responses)
  • A
    18% (9)
  • B
    76% (38)
  • D
    6% (3)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice