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.

When a dml statement is executed, in which cursor attributes, the outcome of the statement is saved?

1090

---

What is identity column in sql server?

1034

---

ERROR:Insert or update on table"accnt" violates foreign key constraints "acct_to_curr_symbol" DETAILS:KEY(accnt_curr_id)(-2)is not present in the table "curr_symbol" ......solve The Problem..

2482

---

Which one is faster ienumerable or iqueryable?

915

---

explain commit and rollback in mysql : sql dba

993

---

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

1044

---

What is sql select statement?

1013

---

Can we use join in subquery?

1073

---

What is a join?

1046

---

What do you mean by table in sql?

974

---

Can a table contain multiple foreign key’s?

982

---

What are user defined functions?

992

---

What is pivot query?

1055

---

How can triggers be used for the table auditing?

1048

---

How many types of sql are there?

977

---