Answer Posted / naresh

View: - it is logical table,it doesn't contain any data,it's contain only select statement.
if you modify the data in view,it's immediately effect to the Base table.
it gets rowids same as the base table.
Materialized view: - M.V are mostly use in Data Marts.

What are the rules to be applied to nulls whilst doing comparisons?

1366

---

What is set transaction?

1088

---

What is difference between sql and oracle?

1190

---

The select into statement is most often used to create backup copies of tables or for archiving records?

1115

---

What are tables and fields in the database?

1184

---

What is difference between stored procedure and trigger?

1246

---

What is the requirement of self-join?

1206

---

how to rename an existing table in mysql? : Sql dba

1114

---

Is the primary key an index?

1077

---

What is trigger in sql and its types?

1108

---

What are the advantages of pl sql over sql?

1071

---

Can you selectively load only those records that you need? : aql loader

1092

---

What is where clause in sql?

1086

---

What is varchar example?

1080

---

Does sql profiler affect performance?

1045

---