Question: QUESTION 19 Which of the following create table statement is not valid? create table department (dept name varchar(20) building varchar(15), budget numeric(12,2) primary key (dept_name))

QUESTION 19 Which of the following create table statement is not valid? create table department (dept name varchar(20) building varchar(15), budget numeric(12,2) primary key (dept_name)) create table department (dept_name varchar(20), building varchar(15), budget numeric(12,2) primary key (dept name) check (bulding in (Watson', Taylor)) O C.create table department (dept name varchar(20) building varchar(15) budget numeric (12,2), primary key (dept_name), check (tol-credit >= 120)) O D- create table department (dept_name varchar(20) building varchar(15), budget numeric (12,2) primary key (dept_name) check (budget>0))
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
