Explain the essential format of the CREATE TABLE statement. ...

[washai]

Explain the essential format of the CREATE TABLE statement.
 
  What will be an ideal response?

Question 2

A stored program that is stored within the database and compiled when used is called a trigger.
 
  Indicate whether the statement is true or false

[kishoreddi]

Answer to Question 1

The essential format for the CREATE TABLE statement is:
CREATE TABLE tablename (
column-description,
column-description,
column-description,
. . .
optional table constraints
);
Tablename is the name that will be given to the newly created table. Column-description is a three-part description of each column to appear in the table. This description includes the name of the column, the column's data type, and an optional column constraint (either Primary Key, Null, or Not Null), in that order. The CONSTRAINT phrase can be used to set optional primary key, foreign key and referential integrity constraints for the table. All SQL statements must end with a semi-colon (.

Answer to Question 2

FALSE