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.

Write a unique difference between a function and a stored procedure.

925

---

what is sp_pkeys? : Transact sql

1102

---

Are there any features that are decommissioned in 11g that are not present in 11g?

2066

---

How to process query result in pl/sql?

1060

---

What are operators available in sql?

979

---

Is sql similar to python?

917

---

How to find 3rd highest salary of an employee from the employee table in sql?

1035

---

Define commit?

940

---

What is the difference between instead of trigger and after trigger?

948

---

What are secondary keys?

921

---

Should I use mbr or gpt?

946

---

What is the difference between a subquery and a join?

1012

---

Does pl sql work in mysql?

919

---

What is a delimiter in sas?

978

---

What are the types of keys?

932

---