Oracle Database Administration from Zero to Hero - Practice - Creating Oracle Databases (Part 2 of 2)

This video tutorial guides you through creating an Oracle 19C non CDB database on a Windows server. It covers setting up the environment, configuring the listener, and using the DBCA utility for database creation. Advanced configuration options, such as memory settings and schema management, are discussed. The tutorial also explains post-creation tasks, including service management and schema activation. Finally, it highlights the differences between silent and interactive modes in DBCA.

What is the first step in creating an Oracle 19C non-CDB database on a Windows platform?

• Open the Services window

• Increase the font size of the command prompt

• Invoke the Netca utility

• Verify that no listener is running

Which utility is used to configure the database after verifying the listener status?

• Oracle VSS Writer

• Oracle SVC

• DBCA

• Netca

What should be done after selecting the custom database option in the DBCA utility?

• Enter the database name

• Select the first radio button

• Set the listener password

• Enable the FRA

What is the recommended size for the FRA when configuring the database?

• 15 gigabytes

• 20 gigabytes

• 5 gigabytes

• 10 gigabytes

Which memory option should be used for the database configuration?

• Manual Memory Management

• Automatic Shared Memory Management

• Static Memory Management

• Dynamic Memory Management

What should be done if you see a message about EM express during database configuration?

• Enable the checkbox

• Unmark the checkbox

• Ignore the message

• Restart the configuration

What is the purpose of the password management step after database creation?

• To disable unnecessary schemas

• To configure the listener

• To enable the Oracle VSS Writer service

• To set passwords for administrative users

Why is it recommended to keep certain schemas disabled in the Oracle database?

• To ensure only required schemas are active

• To prevent unauthorized access

• To save memory

• To avoid unnecessary resource usage

What is the role of the Oracle VSS Writer service?

• To integrate with VSS-based backup systems

• To manage database connections

• To configure the listener

• To start the database automatically

What mode is used in DBCA to create a non-CDB database on a Linux machine?

• Interactive mode

• Silent mode

• Manual mode

• Automated mode