nerdexam
Oracle

1Z0-902 · Question #57

You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC…

The correct answer is A. 1 consisting of all 96 griddisks. This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system…

Storage Configuration

Question

You are in the process of upgrading your nonvirtualized X9M-2 Database Machine elastic configuration with 4 database servers and 7 HC storage servers with an additional 4 database servers and 7 HC storage servers. The new storage servers are called DM01CEL08 through dmoicel14. After creating 96 new griddisks, you issued this SQL statement:

How many failgroups if any, will be added to the DATE diskgroup by executing this SQL statement?

Exhibit

1Z0-902 question #57 exhibit

Options

  • A1 consisting of all 96 griddisks
  • B96 consisting of one griddisk each
  • C0 because the new griddisks will be added to the existing faiigroups
  • D12 consisting of seven griddisks each
  • E7 consisting of 12 griddisks each

How the community answered

(55 responses)
  • A
    65% (36)
  • B
    5% (3)
  • C
    9% (5)
  • D
    16% (9)
  • E
    4% (2)

Explanation

This SQL statement is adding the new griddisks to the existing diskgroup "DATA" and creating one new failgroup, consisting of all 96 griddisks. The "REBALANCE POWER 512" option tells the system to perform a rebalance operation with a power of 512. It means the system distributes the data evenly across all the disks in the diskgroup using a power of 512.

Topics

#failgroups#ASM diskgroup#grid disks#elastic expansion

Community Discussion

No community discussion yet for this question.

Full 1Z0-902 Practice