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 ...

Can you have more than one content canvas view attached with a window ?

2260

---

What is different types of joins?

962

---

Why oracle is used?

994

---

How to create a stored function in oracle?

1036

---

Explain the use of record length option in exp command.

1019

---

What is the max number of columns in an oracle table?

928

---

What is the difference between 10g OEM and 11g OEM?

916

---

What are the various constraints used in oracle?

990

---

how to convert .db (extention) database file into .dmp (extention ) for oracle database ?

2503

---

What is the effect of setting the value "all_rows" for optimizer_goal parameter of the alter session command? What are the factors that affect optimizer in choosing an optimization approach?

971

---

Explain the use of grant option in imp command.

957

---

Explain the use of ignore option in imp command.

972

---

What is merge in oracle?

994

---

How will you identify oracle database software release?

941

---

What is Segment Advisor in Oracle?

1047

---