QUESTION 19 Which of the following create table statement is not valid? create t

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)) 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))

Explanation / Answer

C.

create table department (dept_name varchar(20), building varchar(15), budget numeric(12,2), primary key (dept_name), check(tol_credit>=120))

Error: near line 1: no such column: tol_credit

There is no column names 'tol_credit' defined, which is used in the check condition.

Hence, this create statement is invalid.

Related Questions

Navigate

• Browse (All)
• Browse Q
• Subjects

---