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 is Reduced List of Values?
How to convert characters to numbers in oracle?
Explain mutating triggers.
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
How to define an anonymous procedure without variables?
Which dictionary view(s) would you first look at to understand or get a high-level idea of a given Advanced Replication environment?
What are ddl statements in oracle?
what are actual and formal parameters?
Can we protect our pl/sql source code?
What is meant by raw datatype?
How a database is related to tablespaces?
List the various oracle database objects?
What is the maximum number of triggers that can be applied to a single table?
What is save point in oracle database?
Write a trigger example in oracle?