Answer Posted / allin

5 Different integrity constraints are given

1- Primarykey- creating the index and better performance
2- Unique - should not accept the repeated value
3- NotNull - Should enter any value
4- ForeignKey - can accept values which the values should
existed in primarykey column.Should accept
null values.
5- Check - between the two boundaries.

Thanks & Regards,
RatnaRao
9833847339

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

3869

---

Explain what are synonyms used for?

607

---

What is difference between sid and service name in oracle?

519

---

How to insert multiple rows with one insert statement in oracle?

570

---

How can I introduce multiple conditions in like operator?

553

---

---

Explain about the analyze command in oracle?

586

---

What happens if you set the sga too low in oracle?

554

---

Calculate difference between 2 date / times in oracle sql?

571

---

How to use "out" parameter properly?

628

---

How to create tables for odbc connection testing?

491

---

What is the purpose of tables, private synonyms and public synonyms in Oracle?

587

---

State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.

605

---

Is oracle a relational database?

520

---

What is a nested table?

628

---

How can I get column names from a table in oracle?

534

---