Answer / Nupur Tandon

Synonyms in Oracle serve several purposes: 1) They provide a means to hide the complexity of the underlying object by providing an easier-to-remember name. 2) They allow users with different privileges to access the same data through their own synonym instead of directly accessing the original object. 3) They enable schema consolidation, as multiple schemas can reference the same underlying object using their respective synonyms.

How to count duplicated values in a column in oracle?

1 Answers  

---

What is a Data File ?

1 Answers  

---

What is an external table?

1 Answers  

---

What are the different oracle database objects?

1 Answers  

---

what is the exact diiference between DBMS and RDBMS

4 Answers   Tesco,

---

What are the Referential actions supported by FOREIGN KEY integrity constraint ?

1 Answers  

---

Explain self joins in oracle?

1 Answers  

---

What is Java Pool in Oracle?

1 Answers   MCN Solutions,

---

Explain coalesce function?

1 Answers  

---

select trunc(round(156.00,-1),-1) from dual;

2 Answers  

---

Explain the use of Merge statement in oracle 11g

1 Answers   Infosys,

---

WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?

1 Answers   ESS,

---