Answer Posted / basanti

Synonym is an alias for a object of a database.
It can be created for TABLE or VIEW.
There are two type of synonym PRIVATE and PUBLIC.

public synonym is created by a keyword public.
public synonym is accessible to any schema in the database.
Syntax to create public synonym:
CREATE PUBLIC SYNONYM synonym_name FOR object_name;

If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?

2248

---

In the oracle version 9.3.0.5.0, what does each number shows?

1227

---

How to start a specific oracle instance?

991

---

What is Java Pool in Oracle?

1094

---

When do I need to use a semicolon vs a slash in oracle sql?

1028

---

What is analyze command used for?

1013

---

From the following identify the non schema object: packages, triggers, public synonyms, tables and indexes.

1012

---

Can we connect to ORACLE db using Windows Authentication?

1183

---

Typically, where is the conventional directory structure chosen for Oracle binaries to reside?

2065

---

What is a nvl function?

958

---

Explain the use of ignore option in imp command.

977

---

IS it possible to built the oracle database without setting the kernal parameters?

2272

---

What are the differences between number and binary_float in oracle?

1054

---

How to create a new oracle data file?

972

---

What is the usage of save points in oracle database?

909

---