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 is the basic form of sql query?

0 Answers  

What are the different tcl commands in sql?

0 Answers  

What is insert command in sql?

0 Answers  

When you have to use a default "rollback to" savepoint of plvlog?

0 Answers  

define data blocks ? : Sql dba

0 Answers  

Inline the values in PL/SQL, what does it mean.?

0 Answers   MCN Solutions,

how do you control the max size of a heap table? : Sql dba

0 Answers  

How can I make sql query run faster?

0 Answers  

Is oracel sql developer written in java?

0 Answers  

Is it possible to use LONG columns in WHERE clause or ORDER BY?

3 Answers  

What is bulk compiling in pl/sql.?

0 Answers   MCN Solutions,

Where do we use pl sql?

0 Answers