Answer / rajeev

The CHECK constraint is used to limit the value range that
can be placed in a column.

If you define a CHECK constraint on a single column it
allows only certain values for this column.

If you define a CHECK constraint on a table it can limit the
values in certain columns based on values in other columns
in the row.

Answer / arihant

example of check constraint

CREATE TABLE Customer_Details(
Cust_ID Number(5) CONSTRAINT Nnull1 NOT NULL
CONSTRAINT Ccheck1 CHECK( Cust_ID BETWEEN 101 AND 105),
Cust_Last_Name VarChar2(20) CONSTRAINT Nnull2 NOT NULL,
Cust_Mid_Name VarChar2(4),
Cust_First_Name VarChar2(20),
Account_No Number(5) CONSTRAINT Pkey1 PRIMARY KEY,
Account_Type VarChar2(10) CONSTRAINT Nnull3 NOT NULL,
Bank_Branch VarChar2(25) CONSTRAINT Nnull4 NOT NULL,
Cust_Email VarChar2(30)
);

Answer / shaik

Check Constraint defines a condition that each row must satisfy.

create table emp(empid number,ename varchar2(15),salary
number,deptid number constraint emp_salary_min
CHECK(sALARY>1000));

What is a storage engine? What are the differences between innodb and myisam engines?

0 Answers  

---

how to dump all databases for backup. Backup file is sql commands to recreate all db's.

0 Answers  

---

Consider you have the following three tables which have to be linked together.

0 Answers  

---

What are the advantages of stored procedures, triggers, indexes?

5 Answers  

---

What are the functions in mysql?

0 Answers  

---

What are the features of Stored Procedures in MYSQL?

1 Answers  

---

How do I clear a mysql database?

0 Answers  

---

What is unsigned in mysql?

0 Answers  

---

What is the difference between procedure and function in mysql?

0 Answers  

---

Write a query to display current date and time?

0 Answers  

---

How you can create a trigger in mysql?

0 Answers  

---

What is the limitation of mysql?

0 Answers  

---