Answer Posted / 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.

What is partition in sql query?

509

---

What is the difference between function and procedure in pl/sql?

531

---

what is index? : Sql dba

554

---

What is the purpose of the partition table?

539

---

How is pl sql different from sql?

536

---

---

what is a materialized view? : Sql dba

569

---

What are records give examples?

558

---

what is a table called, if it has neither cluster nor non-cluster index? What is it used for? : Sql dba

518

---

what is 'mysqldump'? : Sql dba

562

---

What is #table in sql?

516

---

What are the possible values for the boolean data field?

514

---

What is rank function in sql?

524

---

what is the difference between ereg_replace() and eregi_replace()? : Sql dba

549

---

give the syntax of grant and revoke commands? : Sql dba

609

---

How do you create a db file?

514

---