星期三, 9月 01, 2010

Creating DB2 databases using wizard and command options

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