Tell me what is a CHECK constraint?
Submitted by: MuhammadA CHECK constraint is used to limit the value that is accepted by one or more columns.
E.g. ‘Age' field should contain only the value greater than 18.
CREATE TABLE EMP_DETAILS(EmpID int NOT NULL, NAME VARCHAR (30) NOT NULL, Age INT CHECK (AGE > 18), PRIMARY KEY (EmpID));
Submitted by: Muhammad
E.g. ‘Age' field should contain only the value greater than 18.
CREATE TABLE EMP_DETAILS(EmpID int NOT NULL, NAME VARCHAR (30) NOT NULL, Age INT CHECK (AGE > 18), PRIMARY KEY (EmpID));
Submitted by: Muhammad
Read Online Database Developer Job Interview Questions And Answers
Top Database Developer Questions
☺ | Please explain what is Database Testing? |
☺ | Explain me what are the different DDL commands in SQL? |
☺ | Tell us what is a temp table? |
☺ | Tell me what is a Composite PRIMARY KEY? |
☺ | Do you know SQL Data Types? |
Top Databases Programming Categories
☺ | RDBMS Interview Questions. |
☺ | SQL Interview Questions. |
☺ | SSRS Interview Questions. |
☺ | Database Administrator (DBA) Interview Questions. |
☺ | Sybase Interview Questions. |