Answer / sohail

Constraint is a restriction on table.There are two types of
constraints 1.ananymous constraint and 2.named
constraint.under named and ananymous constraints there are
1.primary key constraint
2.foreign key constraint
3. not null constraint
4. check constraint
5. unique constraint.

Answer / pavani

Constraint means it is rule which you want to apply on the
table. There are two types of constraints.
1. Column Constraints: Applicable for that column only.
2. Table Constraints: Applicable for more than one column.

Column Constraints:
a. unique b. not null c. primary key d. foreign key
e.default f. check

Table constraints:
a. unique b. primary key c. foreign key d. check

Answer / sujit.1551

constraint are nothing but a conditions,in other words
enforcing the business rules into the database.
types of constraits:
1)check constraint
2)unique constraint
3)primary key
4)foreign key
5)Not null
6)Default

Answer / samuvel

Constraint is a restriction on table

Types:

1)Column Constraints:applicable for column level
i)unique ii) not null

2)Table constraints:applicable for table level
1)primary key ii) foreign key d. check

Answer / ravi

constraints are two types
1.Rule based constraint
2.cost based constraint

What are some emotional triggers?

0 Answers  

---

difference between SQL and C

1 Answers   Indus Software Technologies,

---

Explain raise_application_error.

0 Answers  

---

What is difference between rank () row_number () and dense_rank () in sql?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---

---

What are the different types of joins and explain them briefly.

3 Answers  

---

List the differences between plsql - function & procedures

2 Answers   TCS, Verizon,

---

What is the maximum database size for sql express?

0 Answers  

---

How can we implement rollback or commit statement in a trigger?

0 Answers  

---

What is indexing oracle sql?

0 Answers  

---

I have 2 Databases. How can create a table in particular database? How can i know the list of tables presented each database?( in oracle 10g)

5 Answers   Relq,

---

How do I create a sql database?

0 Answers  

---