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?
Command Center
Control Center
Journal
Task Center
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