ALTER TABLE
The most important part which should be covered in detail in the OCP exam
are the alter table statements.

The fundamental question OCP focuses on are the column constraints and table constraints and their syntax.

A general alter table syntax is :

ALTER Table table_name add my_new_col char my_existing_tbl_nm;

We never specify COLUMN in alter table statements.

A statement such as this is invalid:

Alter table my_existing_tbl add COLUMN my_new_col char ;

The word COLUMN makes the sql command to fail in the above case.