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 actual parameters and formal parameters?

0 Answers  

what is rdbms? : Sql dba

0 Answers  

Which are the most commonly used sql joins?

1 Answers  

what is mean by forward declaration and where we'll use it.

4 Answers   TCS,

suppose u hav 1 book with set...page 1-100 n 101 -200 now print page from 2-100 n 102 -200... how we will do..?

6 Answers  

How can we avoid duplicating records in a query?

0 Answers  

What are tables and fields?

0 Answers  

Define overloaded procedure?

0 Answers  

how to get the third quarter of employee details from emp?

2 Answers   CompuTech,

What is pl sql in oracle?

0 Answers  

What are the advantages of pl sql over sql?

0 Answers  

package specification-3 procedures package body-2 procedures will is execute

2 Answers   PWC,