Answer / 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

What is merge statement used for?

0 Answers  

---

What is Oracle table?

1 Answers  

---

List the parts of a database trigger.

0 Answers  

---

What is a cursor in oracle?

0 Answers  

---

What does ROLLBACK do ?

1 Answers  

---

Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)

4 Answers   Thermotech,

---

What are the limitations of check constraint?

0 Answers  

---

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

---

what is the use of composite key constraint?

2 Answers  

---

In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

0 Answers  

---

Which database is better for os platform dependency?

1 Answers  

---

Give syntax for SQL and ORACLE joins.

0 Answers   TCS,

---