Answer Posted / shreekumar nair

unique key will only allow unique values in that particular column ...but it allows multiple NULL values ...since null values are not equal to an another null value...

whereas in a primary key column we can't have that ...

How to convert raw data type into text in oracle? Explain

1046

---

How to add another datafile to a tablespace?

1086

---

You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1981

---

Give the various rollback segment states.

1085

---

What is object data modeling?

1015

---

Is primary key indexed by default in oracle?

1045

---

What is Library Cache in Oracle?

1184

---

What is the Tune Query

2345

---

What happens if recursive calls get out of control?

1136

---

types of indexes and the rationale behind choosing a particular index for a situation.

2559

---

What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?

2139

---

Explain a segment?

1126

---

Explain what are synonyms used for?

1091

---

What is the disadvantage of User defind function?

2340

---

How to drop a stored function?

1182

---