Answer Posted / pravin patil
Vies is logical representaion of parent table
& index is oralce object use to access table' column quickly
view can replace but index cannot replace u have to delect
existed index then create new index.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What are the differences between char and nchar in oracle?
what is the difference between data migration and production migration.
Explain a segment?
Explain the blob datatype?
Is it possible to split the print reviewer into more than one region ?
Whether any commands are used for months calculation? If so, what are they?
What is data type in oracle?
Explain oracle left join with an example?
What is a sub query and what are the different types of subqueries?
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
What happens to the data files if a tablespace is dropped?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to unlock the sample user account in oracle?
What are data pump export and import modes?
What query tells you how much space a tablespace named test is taking up, and how much space is remaining?