Answer Posted / abhishek.421

a sort of primary key..just it allows NULL values

What happens if you use a wrong connect identifier?

1066

---

Are truncate and delete commands same? If so why?

1156

---

Please explain compound trigger in oracle?

1058

---

How translate command is different from replace?

1089

---

definition of cluster and non-clustered index?

3035

---

Difference between oracle's plus (+) notation and ansi join notation?

1105

---

If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

2149

---

How do I manually create a database in oracle?

1019

---

What is the sql query to concatenate column values from multiple rows in oracle?

1057

---

What is merge in oracle?

1054

---

How to convert character types to numeric types?

1135

---

Explain the use of grant option in exp command.

1064

---

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?

1048

---

Explain about achiever in sql?

1040

---

How to rename an index?

1073

---