Answer Posted / vishal

for simplicity, Instance is the name of the Database.
Schema is the owner of your objects(tables, indexes, views,
synonyms,etc).

In you example, you have a Database Instance named
CONTRACT.

In your Contract database, you have 2 Schemas named LEGAL &
RI

What are the different editions of oracle?

1058

---

Is primary key indexed by default in oracle?

937

---

How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?

2214

---

How to build data dictionary view an new database?

968

---

Can group functions be mixed with non-group selection fields?

969

---

How to use subqueries with the in operator using oracle?

1039

---

What are oracle functions?

984

---

What is max rowid in oracle?

973

---

How to write date and time interval literals in oracle?

982

---

How view is different from a table?

977

---

What do you know about normalization? Explain in detail?

888

---

How to pass parameters to procedures in oracle?

1001

---

How to rename a tablespace in oracle?

1038

---

How do you get nicely formatted results from an oracle procedure that returns a reference cursor?

1012

---

What is set verify off in oracle?

1037

---