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
Step: 1
Answer c is correct statement ie c CREATE TABLE EmployeeEmployeeNo INTEGER primar...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started