Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Database with ASM (Part 3 of 4)

The video tutorial guides through setting up ASM disk groups for Oracle databases, installing Oracle Database Software, and creating a VM snapshot. It covers using the DBCA utility to create an ASM-based database, configuring database settings, and performing post-installation checks to verify database status and connection setup.

What is the first step in setting up the ASM Configuration Assistant?

• Select the disk file

• Give the disk group the name data

• Click on Disk Groups node

• Set its relevancy to external

Why is a snapshot created in Oracle VirtualBox during the installation process?

• To enhance the performance of the VM

• To restore the VM in case of installation failure

• To create a backup of the database

• To increase the storage capacity

What should be done when the software installer reaches 63%?

• Click on No button

• Cancel the installation

• Restart the installation

• Click on Yes button

Which option should be selected when running the DBCA utility to create the database?

• Typical database

• Standard database

• Custom database

• Express database

What is the recommended maximum size for the FRA disk group?

• 10000

• 5000

• 2000

• 1000

What should be done if the TNS names dot Ora file is not created?

• Add a connection descriptor manually

• Reinstall the database

• Ignore the issue

• Restart the server

What utility is used to check the status of the database after creation?

• ASMCA

• DBCA

• SRVCTL

• SQL*Plus