Ways to create an Oracle Database - Oracle DBA

Q.  Which of the following ways can we use to create an Oracle Database?
- Published on 04 Aug 15

a. The Database Configuration Assistant
b. The CREATE DATABASE statement
c. Upgrade an existing database
d. All mentioned above

ANSWER: All mentioned above


  • Nirja Shah   -Posted on 25 Aug 15
    -You can create a database in three ways:

    -Use the Database Configuration Assistant (DBCA) - DBCA can be launched by the Oracle Universal Installer, depending upon the type of install that you select, and provides a graphical user interface (GUI) that guides you through the creation of a database.
    -You can also launch DBCA as a standalone tool at any time after Oracle Database installation to create or make a copy (clone) of a database

    -Use the CREATE DATABASE statement - You can use the CREATE DATABASE SQL statement to create a database.
    -If you do so, you must complete additional actions before you have an operational database.
    -These actions include creating users and temporary tablespaces, building views of the data dictionary tables, and installing Oracle built-in packages.
    -These actions can be performed by executing prepared scripts, many of which are supplied for you.

    -Upgrade an existing database - If you are already using a earlier release of Oracle Database, database creation is required only if you want an entirely new database.
    -You can upgrade your existing Oracle Database and use it with the new release of the database software.

Post your comment / Share knowledge

Enter the code shown above:
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)