Answer Posted / salim

there are two type of sysnonyms
1.public
2.private

Why do you create or replace procedures rather that drop and recreate.

543

---

How to start instance with a minimal initialization parameter file?

533

---

What is Undo Management Advisor in Oracle?

608

---

What is translate in oracle?

615

---

How can I combine multiple rows into a comma-delimited list in oracle?

577

---

---

What is the data type of dual table?

521

---

How to delete all rows a table in oracle?

619

---

How to define a specific record type?

615

---

What is a procedure in oracle?

616

---

What are the advantages of oracle?

545

---

What is a initialization parameter file in oracle?

579

---

how can db_files > maxdatafiles since db_files is for instance and the later is for database

2173

---

What is a directory object?

587

---

What are the various constraints used in oracle?

550

---

How many types of segments in Oracle?

527

---