Answer Posted / gautam choudhury

It's important to note that init.ora parameters
query_rewrite_integrity and query_rewrite_enabled are
required to use materialized views and function-based
indexes. if these two parameters are declared then hint is
not required to access a materialized view.

QUERY_REWRITE_INTEGRITY =ENFORCED
QUERY_REWRITE_ENABLED = TRUE

There are three acceptable values for
query_rewrite_integrity:

enforced (default) - Presents materialized view with fresh
data

trusted - Assumes that the materialized view is current

stale_tolerated - Presents materialized view with both
stale and fresh data

Why do we use coalesce function in oracle?

1050

---

How to start a new transaction in oracle?

1015

---

Why packages are used in oracle?

1000

---

What is the difference between a user and a schema in oracle?

981

---

How to convert a string to a date in oracle database?

999

---

What is Virtual Private Database in Oracle?

1014

---

How many categories of data types?

936

---

What is oracle instant client?

969

---

Where is the export dump file located?

1079

---

Explain the use of log option in exp command.

1045

---

What is a nested table?

1004

---

how to clone 9i Database on to 10g Database.

2284

---

What is an oracle?

955

---

Difference between oracle's plus (+) notation and ansi join notation?

1031

---

What is the difference between alert log file and tarce file ?

2096

---