Oracle Database Administration from Zero to Hero - Introducing Automatic Storage Management (Part 2 of 3)

The video tutorial covers Oracle Restart and its role in enhancing database availability. It explains the installation of Oracle Grid Infrastructure and the configuration of ASM instances. The tutorial also discusses managing ASM disk groups, redundancy levels, and storage options. Key tools like ASMCA, SQL Plus, and ASM CMD are introduced for managing ASM components.

What is the primary advantage of Oracle Restart?

• It provides additional storage space.

• It increases the speed of data retrieval.

• It maintains the startup sequence of Oracle components.

• It reduces the database size.

Which utilities are used to manage grid resources and database instances in Oracle Restart?

• DBCA and RMAN

• ASMCA and ASM CMD

• CRSCTL and SRVCTL

• SQL Developer and SQL Plus

What is the first step in the general procedure for installing Oracle Grid Infrastructure?

• Prepare the OS for the installation.

• Configure the OS users and groups.

• Install Oracle Grid software.

• Configure the storage for Oracle Grid Infrastructure.

What file type does an ASM instance use that is similar to an Oracle database instance?

• SP file

• Data file

• Control file

• Log file

Which tool is a GUI wizard style tool for managing ASM instances?

• DBCA

• SRVCTL

• ASMCA

• SQL Plus

What is the purpose of the ASM disk string parameter?

• To specify the file type for ASM files

• To define the redundancy level of disk groups

• To limit the set of disks configured for discovery

• To set the size of the disk groups

What is the default redundancy level in ASM that uses two-way mirroring?

• Internal

• High

• External

• Normal

What is the smallest unit of allocation within an ASM disk group?

• Extent

• Allocation unit

• Data block

• Disk partition

Which of the following is NOT a source for an ASM disk?

• Network attached files (NFS)

• Logical volumes

• Physical disks

• Database tables

What does ASM use to ensure files are evenly spread across disks in a disk group?

• Mirroring

• Partitioning

• Fine-grained stripping

• Coarse stripping