DDL SQL Question

10. (DDL) Solve following four questions (15 points). A. Create the vendor table based on the following specification? COLUMN NAME Data TYPE Lenth CONSTRAINT TYPE IS NULLABLE Vendorld VendorName number7,0 Varchar2 PRIMARY KEY NO YES 25 NULL B. Vendor Table, add AccountNumber column of varchar2 (50) data type. vendor Table, Change vendorname column to allow forlonger vendor names varchar2 (150 Create a sequence that can be used with the primary key column of the vendor table. The sequence should start at 20 and have a maximum value of 6000. have your sequence increment by 1, name the sequence VENDORID SEQ c. D. E. Using VENDORID_SEQ, Insert one record into the Vendor table. F. Drop the vendor table and VENDORID_SEQ sequence