Question

Write command to create table named ‘BOOK ‘ with following fields:
BOOK ID Char(4)
Bname Varchar(15)
Author Varchar(20)
Price Decimal

Answer 1

Just refer to image to get to know all your doubt cleared

Answer 2

create table book(BookID char(4), Bname varchar(15), Author varchar(20), price decimal)