gs gs115 SQL Constraints - SQL Check Constraint - Quiz No.1
gs gs115 Structured Query Language Quiz
This quiz belongs to book/course code gs gs115 Structured Query Language of gs organization. We have 79 quizzes available related to the book/course Structured Query Language. This quiz has a total of 8 multiple choice questions (MCQs) to prepare and belongs to topic SQL Constraints. NVAEducation wants its users to help them learn in an easy way. For that purpose, you are free to prepare online MCQs and quizzes.
NVAEducation also facilitates users to contribute in online competitions with other students to make a challenging situation to learn in a creative way. You can create one to one, and group competition on an topic of a book/course code. Also on NVAEducation you can get certifications by passing the online quiz test.
CREATE TABLE table_name CHECK ( column1 datatype (condition), column2 datatype (condition), ... columnn datatype (condition));CREATE TABLE table_name ( column1 datatype CHECK (condition), column2 datatype CHECK (condition), ... columnn datatype CHECK (condition));CREATE TABLE table_name ( column1 datatype, column2 datatype, ... columnn datatype, CHECK (column1, column2) (condition));CREATE TABLE table_name ( CHECK (column1 datatype condition), CHECK (column2 datatype condition), ... CHECK (columnn datatype condition));CREATE TABLE table_nameCHECK (condition1 AND condition2) ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint);CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, CONSTRAINT CHECK (condition1 AND condition2));CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, CHECK (condition1 AND condition2));CREATE TABLE table_name ( column1 datatype constraint, column2 datatype constraint, ... columnn datatype constraint, CONSTRAINT constraint_name CHECK (condition1 AND condition2));ALTER TABLE table_name ADD CONSTRAINT constraint_name CHECK (condition);ALTER TABLE table_name ADD CONSTRAINT CHECK (condition);ALTER TABLE table_name ADD CHECK (condition);ALTER TABLE table_name ADD constraint_name CHECK (condition);ALTER TABLE table_name DROP constraint_name;ALTER TABLE table_name DELETE CHECK constraint_name;ALTER TABLE table_name DROP CHECK constraint_name;ALTER TABLE table_name DELETE constraint_name;CREATE table employee ( Eid varchar(10) PRIMARY KEY, Age int CHECK (Age BETWEEN 21 AND 40));What is the range of age of the employees that can be entered in the table employee?
