Question

What query command would you use to create a table called Products with the following columns? Unique ProductID, Description - up to 100characters, Instock and ModifiedDate

Answer 1

create table Products(ProductID varchar2[10] unique, Description varchar2[100], Instock varchar2[10], ModifiedDate Date);

Answer 2

I might only add that Instock is probably one of two possibilities, right? Like ('in','out')? You might use an enum for that that instead, if your database supports it. Like ENUM('in','out').