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 This Answer Correct ? | 16 Yes | 17 No |
Post New Answer View All Answers
What is bulk copy or bcp in oracle?
What is a proxy object?
what are archived logs?
How to execute the package in oracle?
Whether any commands are used for months calculation? If so, what are they?
Give the various exception types.
How can we view last record added to a table?
What is clustered table in Oracle?
What are dml statements in oracle?
what is the use of triggers in Java program? I mean where do we use triggers in Java programming?
What are group functions in oracle?
List out the types of joins.
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??
What is oracle update statement with inner join ?
Explain what are synonyms used for?