RelationalDBDesign
SiteMap
Database Architecture
Database Admin
Managing Users
Managing DB Objects
Backup Recovery
Admin Tasks
Create Database
«Prev
Creation Architecture
SQL*Plus
Describe Command
Spool Command
Database Architecture
Cycles Redo Log Files
Redo Log Info
Extract TS Information
Instance Architecture
Difference instance Database
Instance Overview
Asynchronous Process Coordination
System Global Area
System Monitor Process
Oracle Process Monitor
dbw0 Database Writer
Database Writing Time period
Writing Dirty Buffers
Checkpoint Trigger Database
Limiting Dirty Buffers
lgwr Log Writer
Llog Writing Process
Oracle Archiver Process
Archive Log List
CKPT Checkpoint Process
Other Oracle Processes
Memory Architecture
Database Buffer Cache
Oracle Shared Pool
Large Pool
Program Global Area
PGA DBWR SGA
PGA Contents
SharedServer PGA
Sort Area
Shared Server Areas
Database Creation
Redo Log File Sizes
Config Files
DBCreate Commands
Create Database Command
Create Oracle Service
Running pupbld Script
Starting Oracle Instance
CREATE DATABASE Command - Exercise
Executing the CREATE DATABASE command
Steps to create Database
Objective:
Put the steps in the database creation process in the correct order.
Exercise Scoring
You will receive ten points for this exercise. The exercise is auto-scored; when you have completed the exercise, click the
Submit
button to receive full credit.
Instructions
Below are five steps required to create an Oracle database, but they are presented out of order. Place the steps into the correct order, with the first step at the top of the list.
Paste them into the textbox, when you think you have the steps in the correct order, click
Submit
. When you are ready for an explanation, click the
Submit
button.
Write the initialization file
Create a new service
Connect to the instance
Start the instance
Execute the CREATE DATABASE command
Submit