Answer Posted / hafiz

Yes we can create index on a view becuase the view may be
creates on subquery also and then the retrival of records
may be complex and therefore there must be an index on that
perticular column.

Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.

1350

---

Can we protect our pl/sql source code?

1046

---

What is redo log?

1067

---

Does oracle partitioning improve performance?

995

---

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

2134

---

Can we convert a date to char in oracle and if so, what would be the syntax?

1016

---

ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process

2277

---

What is the usage of save points in oracle database?

964

---

What do you mean by merge in oracle?

996

---

How to create id with auto_increment on oracle?

990

---

What is an Oracle index?

1655

---

Explain the importance of .pll extension in oracle?

1012

---

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was  Missing To pay How to find That??

1730

---

Explain the difference between a procedure and a function? What do you understand by those terms?

1086

---

while i take backup using ibm tsm the following errors occurred: rman-03009 ora-19513 ora-27206 ora-19502 ora-27030 ora-ora19511

4366

---