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.
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)- A3% (1)
- B3% (1)
- C5% (2)
- D89% (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.
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.
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.
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.
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.
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
Community Discussion
No community discussion yet for this question.