Answered step by step
Verified Expert Solution
Question
1 Approved Answer
ALTER TABLE STUDENT ADD CONSTRAINT C CHECK ( Major IN ( ' CS ' , ' IS ' , ' IT ' ) ) ;
ALTER TABLE STUDENT ADD CONSTRAINT C CHECKMajor INCSISIT;
c ALTER TABLE STUDENT ADD Major CHAR INCSISIT;
d None of the above.
Consider the following relation schema:
STUDENT
Which of the following statements creates the above relation?
a CREATE TABLE STUDENT
Name CHAR
StudentNumber INT CHECKStudentNumber BETWEEN AND
Class INT CHECKClass IN NOT NULL ;
b CREATE TABLE STUDENT
Name VARCHAR
StudentNumber INT CHECKStudentNumber BETWEEN AND
Class INT NOT NULL CHECK Class OR Class OR Class OR Class OR Class ;
c CREATE TABLE STUDENT
Name VARCHAR
StudentNumber INT CHECKStudentNumber AND StudentNumber
Class INT CHECKClass IN;
d None of the above
Consider the following relation schema:
BOOK
Maximum The maximum number of characters is
Which of the following statements creates the above relation?
a CREATE TABLE BOOK
BookID DECIMAL PRIMARY KEY,
Title VARCHAR NOT NULL,
PublisherName VARCHAR UNIQUE,
CHECKBookID AND BookID ;
b CREATE TABLE BOOK
BookID INT PRIMARY KEY CHECKBookID AND BookID
Title VARCHAR
PublisherName CHAR UNIQUE;
c CREATE TABLE BOOK
BookID INT PRIMARY KEY CHECKBookID BETWEEN AND
UNIQUE PublisherName
Title VARCHAR NOT NULL,
PublisherName VARCHAR;
d None of the above.
Consider the following relation schema:
BOOK
Which of the following statements creates the above relation?
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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