nerdexam
Oracle

1Z0-027 · Question #63

Consider the following sequence of CELLCLI commands and SQL statements: All CELLCLI commands and SQL statements are executed successfully without warnings. Which statement is true about the I/O…

The correct answer is A. The DATA01 diskgroups has better performance because the DATA01 griddisks were created first. Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer sectors of the underlying…

Managing Exadata Database Machine

Question

Consider the following sequence of CELLCLI commands and SQL statements:

All CELLCLI commands and SQL statements are executed successfully without warnings. Which statement is true about the I/O performance of the DATA01 ASM diskgroups?

Exhibit

1Z0-027 question #63 exhibit

Options

  • AThe DATA01 diskgroups has better performance because the DATA01 griddisks were created first.
  • BThe DATA02 ASM diskgroup has better performance because the DATA02 diskgroups was created first.
  • CThe DATA01 diskgroup has better performance because the DATA01 griddisks are created on inter
  • DThe performance of both diskgroups is balanced because they are created on interleaved griddisks.

How the community answered

(37 responses)
  • A
    76% (28)
  • B
    3% (1)
  • C
    16% (6)
  • D
    5% (2)

Explanation

Griddisks are the fourth layer of abstraction, and they will be the Candidate Disks to build your ASM diskgroups from. By default (interleaving=none on the Celldisk layer), the first Griddisk that is created upon a Celldisk is placed on the outer sectors of the underlying Harddisk. It will have the best performance therefore Not D: non-interleaved is the default.

Topics

#griddisk interleaving#ASM diskgroup performance#CellCLI#I/O layout

Community Discussion

No community discussion yet for this question.

Full 1Z0-027 Practice