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
Answer c is correct statement ie c CREATE TABLE EmployeeEmployeeNo INTEGER primar... View full answer
Get step-by-step solutions from verified subject matter experts
