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

Is sql microsoft?

552

---

What are stuff and replace function?

578

---

what is 'mysqladmin' in mysql? : Sql dba

538

---

How can I delete duplicate rows?

569

---

Can we insert in sql function?

551

---

---

What is the difference between an inner join and an outer join?

518

---

Define commit, rollback and savepoint?

582

---

What is multiple partition?

541

---

What are the different ddl commands in sql?

582

---

Why cross join is used?

637

---

Is and as keyword in pl sql?

517

---

What is output spooling in sql*plus?

557

---

What is bind variable in pl sql?

535

---

How you improve the performance of sql*loader? : aql loader

584

---

Does pl/sql support create command?

578

---