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 all types of user defined functions? : Sql dba

1042

---

How is a process of pl/sql compiled?

1160

---

What are different types of sql commands?

1117

---

Mention what problem one might face while writing log information to a data-base table in pl/sql?

1232

---

explain the difference between delete , truncate and drop commands? : Sql dba

1093

---

Can sql function call stored procedure?

1021

---

what is the use of set statement in tsql? : Transact sql

1011

---

Is the primary key an index?

1026

---

how tsql statements can be written and submitted to the database engine? : Transact sql

995

---

What is dba in sql? : SQL DBA

1041

---

Does inner join return duplicate rows?

976

---

What are the different types of joins in sql?

1787

---

What are the differences between implicit and explicit cursors?

1067

---

Why do we use partitions in sql?

1048

---

How do I access sql anywhere database?

969

---