Question: Among the following, choose the correct SQL statement to create a table named Employee with attributes EmployeeNo, Name, Address, Age, Job, Salary where EmployeeNo must

Among the following, choose the correct SQL statement to create a table named Employee with attributes EmployeeNo, Name, Address, Age, Job, Salary where EmployeeNo must be unique and not null and Age must be greater than 21. 

Answer Choices:

Employee(EmployeeNo INTEGER UNIQUE, INTEGER, Job 

a. CREATE TABLE VARCHAR2(30), Address VARCHAR2(30), Age VARCHAR2(30), Salary real, CHECK(Age21)); Name 

b. CREATE Employee(EmployeeNo INTEGER primary key, Name VARCHAR2(30), Address VARCHAR2(30), Age INTEGER, Job VARCHAR2(30), Salary real, CHECK(Age 21)); 

c. CREATE TABLE Employee(EmployeeNo INTEGER primary key, Name VARCHAR2(30), Address VARCHAR2(30), Age INTEGER, Job VARCHAR2(30), Salary real, CHECK(Age 21)); 

d. CREATE TABLE Employee(EmployeeNo INTEGER NOT NULL, Name VARCHAR2(30), Address VARCHAR2(30), Age INTEGER, Job VARCHAR2(30), Salary real, CHECK(Age 21)

Step by Step Solution

3.57 Rating (178 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

Answer c is correct statement ie c CREATE TABLE EmployeeEmployeeNo INTEGER primar... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!