Answer Posted / suri

alter table tablename add(colname datatype,colname1
datatype...);
alter table tablename modify(colname datatype,colname1
datatype..);

Explain self joins in oracle?

1013

---

What is the difference between substr and instr?

1034

---

What do you mean by a deadlock?

1057

---

In which language oracle has been developed?

1069

---

What do you mean by a tablespace?

1035

---

What are data pump export and import modes?

1060

---

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?

2062

---

Can select statements be used on views in oracle?

1022

---

What are the execution control statements in oracle?

1088

---

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?

1040

---

What is transport network substrate (tns) in oracle?

1041

---

How to drop a stored function?

1135

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1075

---

What is index-organized table in Oracle?

1067

---

Explain user account with reference to oracle.

973

---