Answer Posted / mkjmkumar

And we can create Index on View.

Please explain oracle data types with examples?

1132

---

What is the quickest way to fetch the data from a table?

1100

---

How to write a query with a right outer join in oracle?

1222

---

What is the implicit cursor in oracle?

1170

---

What is an oracle user role?

1040

---

What is archive log in Oracle?

1182

---

What happens if the update subquery returns multiple rows?

1170

---

How to define an external table with a text file?

1125

---

Explain the difference between sap and oracle?

1086

---

What are data pump export and import modes?

1110

---

What is the use of file param in imp command?

1215

---

Explain the use of show option in imp command.

1148

---

How to change program global area (pga) in oracle?

1146

---

How to create id with auto_increment on oracle?

1040

---

How data locks are respected in oracle?

1110

---