Answer Posted / gyana ranjan behera

Both primary key and unique enforce uniqueness of the
column on which they are defined. But by default primary
key creates a clustered index on the column, where are
unique creates a nonclustered index by default. Another
major difference is that, primary key doesn't allow NULLs,
but unique key allows one NULL only.

How to define a cusotmer as a supplier in ORACLE R12

2164

---

How to use attributes of the implicit cursor in oracle?

946

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1005

---

How to delete a column in an existing table in oracle?

1007

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1009

---

What is ordinary table in oracle?

1070

---

Please explain oracle data types with examples?

989

---

What is a system tablespace and when it is created?

915

---

What is the use of file param in imp command?

1109

---

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?

1980

---

Explain the use of file option in exp command.

1078

---

What is the Tune Query

2231

---

What is the dynamic sql in oracle?

1004

---

Can we convert a date to char in oracle and if so, what would be the syntax?

956

---

What is transport network substrate (tns) in oracle?

989

---