Answer Posted / rajini

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

What are group functions in oracle?

583

---

What is hot backup and logical backup?

606

---

Explain a private synonyms?

632

---

What is Java Pool in Oracle?

602

---

What is a proxy object?

579

---

---

Explain the use of consistent option in exp command.

546

---

Give the constructs of a package, function or a procedure.

537

---

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?

521

---

Explain the difference between replace() and translate() functions in oracle?

576

---

Please explain joins in oracle?

547

---

Can you drop an index associated with a unique or primary key constraint?

582

---

How to use an explicit cursor without open statements?

612

---

How to define a sub function?

662

---

How do we represent comments in oracle?

627

---

What are the attributes that are found in a cursor?

647

---