Answer Posted / yogesh babu

yes it can be updated ....but there are certain
restrictions in it.
For eg:
1.a view created from nonupdatable view cant be updated
2.when it is having having , groupby,orderby it cant be
updated.etc

Explain the use of rows option in imp command.

1056

---

Define oracle database

1010

---

What happens if variable names collide with table/column names?

1128

---

15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

2257

---

definition of cluster and non-clustered index?

2984

---

20. Using a set operator, display the client number of all clients who have never placed an order.

2156

---

Explain what are the uses of rollback segment?

975

---

How to turn on or off recycle bin for the session?

1056

---

what is normalisation?what are its uses?

2224

---

How to define an explicit cursor in oracle?

1002

---

What is the fastest query method to fetch data from the table?

1320

---

Explain the use of Merge statement in oracle 11g

990

---

How do I reset a sequence in oracle?

1068

---

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.

2061

---

How to use select statement to count the number of rows in oracle?

1006

---