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

What is rank dense_rank and partition in sql?

549

---

What are the conditions an underlying table must satisfy before a cursor can be used by a positioned update or delete statement? : Transact sql

549

---

How can you know that statistics should be updated?

621

---

Why do we need cursors in pl sql?

527

---

How do I restart sql?

538

---

---

What is an inconsistent dependency?

587

---

How do I copy a table in sql?

525

---

Is sql easier than java?

537

---

How can you save or place your msg in a table?

529

---

what is a record in a database ? : Sql dba

572

---

What is update query?

551

---

What are views in sql?

555

---

what are all the common sql function? : Sql dba

593

---

How do I run pl sql in sql developer?

639

---

List different type of expressions with the example.

557

---