Answer Posted / manoj

This is a virtual table do not have physical existence
only at run time it retrive valves from one or more than
one tables.

opertion: insert , update , delete

case 1:- If view created on only one table than DML
can perform on that TABLE

case 2:- If view Made on more than one then DML cant
possiple

How many types of segments in Oracle?

1014

---

 What are the oracle DML commands possible through an update strategy?

1006

---

What operating systems are supported by oracle database 10g xe?

985

---

How to retrieve data from an explicit cursor?

1009

---

How do I find the database name in oracle?

981

---

What is memory advisor in Oracle?

1027

---

What is key preserved table?

960

---

What are the extensions used by oracle reports?

998

---

How to drop a tablespace?

984

---

Briefly explain what is literal? Give an example where it can be used?

975

---

What is oracle instant client?

973

---

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1811

---

How to name query output columns in oracle?

1133

---

What are temporal data types in oracle?

1066

---

21. Using a set operator, display the client number of all clients who have ever placed an order and whose whose name does not contain the string Sm.

2046

---