nerdexam
Oracle

1Z0-060 · Question #200

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

The correct answer is D. The Oracle database can be created using storage managed by ASM. E. The Oracle database will be automatically registered as a resource in Oracle Restart. Installing Oracle Grid Infrastructure first enables ASM storage for the new database and causes Oracle Restart to automatically register the database as a managed resource.

New Features for Database Infrastructure and Architecture

Question

What are two of the benefits of installing Oracle Grid Infrastructure for a stand-alone server before installing and creating an Oracle database on the same server? (Choose two.)

Options

  • AIt is the only way to have "automatic restart in place" after instance failure.
  • BThe Oracle database will be easier to upgrade in the future.
  • CThe Oracle database can be created using Oracle Managed Files.
  • DThe Oracle database can be created using storage managed by ASM.
  • EThe Oracle database will be automatically registered as a resource in Oracle Restart.

How the community answered

(37 responses)
  • A
    3% (1)
  • B
    3% (1)
  • C
    5% (2)
  • D
    89% (33)

Why each option

Installing Oracle Grid Infrastructure first enables ASM storage for the new database and causes Oracle Restart to automatically register the database as a managed resource.

AIt is the only way to have "automatic restart in place" after instance failure.

Oracle Restart provides automatic restart after instance failure, but it is not the only mechanism - RAC Clusterware and OS-level startup scripts can also restart failed instances, so this is not exclusively a Grid Infrastructure benefit.

BThe Oracle database will be easier to upgrade in the future.

The installation order of Grid Infrastructure relative to the database has no direct impact on the complexity or ease of future Oracle Database software upgrades.

CThe Oracle database can be created using Oracle Managed Files.

Oracle Managed Files is controlled by the DB_CREATE_FILE_DEST parameter and is available regardless of whether Grid Infrastructure is installed; it does not require Grid Infrastructure as a prerequisite.

DThe Oracle database can be created using storage managed by ASM.Correct

Oracle Grid Infrastructure includes the ASM instance and disk group infrastructure that must be running before a database is created if that database is to store its files on ASM-managed disk groups; the ASM instance cannot be started after the fact to retroactively manage existing database files.

EThe Oracle database will be automatically registered as a resource in Oracle Restart.Correct

The Oracle Restart component of Grid Infrastructure monitors and automatically registers every Oracle database created on the same server as a resource, so the database will be automatically restarted after a crash or OS reboot without any manual registration steps.

Concept tested: Oracle Grid Infrastructure benefits - ASM storage and Oracle Restart registration

Source: https://docs.oracle.com/en/database/oracle/oracle-database/19/cwlin/about-oracle-grid-infrastructure.html

Topics

#Oracle Grid Infrastructure#Oracle Restart#ASM#stand-alone server

Community Discussion

No community discussion yet for this question.

Full 1Z0-060 Practice