Answer Posted / 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)
);

What is a session in mysql?

1014

---

What are the differences between char and nchar?

1177

---

What are the different types of triggers in mysql?

1014

---

Can I copy mysql data directory?

969

---

How do I stop a query in mysql workbench?

1010

---

What is an index? How can an index be declared in mysql?

932

---

How you can create a trigger in mysql?

1056

---

How would you get the current date in mysql?

1156

---

What is a definer?

930

---

How can you make a database as your current database?

1121

---

What is blob and clob?

990

---

Can we store videos in mysql database?

996

---

What do you need to connect php to mysql?

1035

---

How to use mysqldump to create a copy of the database?

1131

---

What is the difference between is null & is not null?

1042

---