Q1. You want to create a database called NEWBRO using the CREATE DATABASE command.
Which command statement will create this database providing the minimum of information?
CREATE DATABASE ;
CREATE DATABASE NEWBRO;
CREATE DATABASE NEWBRO ON E:;
CREATE DATABASE NEWBRO CATALOG TABLESPACE MANAGED BY SYSTEM;
Q2. From where can you launch the Create Database Wizard?
Q3. What does the following command do?
CREATE DATABASE STOCK CATALOG TABLESPACE MANAGED BY DATABASE EXTENTSIZE 16 PREFETCHSIZE 16
Creates a new table called STOCK
Creates a new DMS database called STOCK
Creates a new SMS database called STOCK
Q4. What can you do with the Create Database Wizard?
Adjust the performance of the database
Rename a database that already exists
Review the command that will be executed by the wizard
Specify where to store catalog tables