Answer Posted / swapnareddy

A View can be updated/deleted/inserted if it has only one
base table if the view is based on columns from one or
more tables then insert, update and delete is possible with
thehelp of instead of trigger.

Can we create table in function?

907

---

What is input buffer in sql*plus?

1123

---

How does cross join work?

875

---

How are sql commands classified?

1035

---

Are sql connections encrypted?

955

---

What are different types of keys?

1015

---

how to fetch common records from two tables? : Sql dba

1105

---

What is out parameter used for eventhough return statement can also be used in pl/sql?

1014

---

How do you add a column to a table?

995

---

What is normalization? How many normalization forms are there?

1010

---

Is sqlite good enough for production?

948

---

What is inner join in sql?

1001

---

explain mysql aggregate functions. : Sql dba

939

---

Is a secondary key the same as a foreign key?

953

---

What is pl/sql language case sensitive?

1059

---