Answers were Sorted based on User's Feedback
Answer / 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|
Answer / sahaja mallarapu
A View is a data base object also called as virtual table
which is created on a select statement.
A view can be created using multiple tables.
A view is stored in a temporary memory.
An index is also a DB Object which is used to increase
query performance and index is created based on columns of
An index is created on multiple columns but on a single
Index is maintained by Oracle Server itself.
|Is This Answer Correct ?||3 Yes||0 No|
How do I manually uninstall oracle client?
When do you get a .pll extension in oracle? Explain its importance
what is the difference between simple view and complex view?
What is a view and how is it different from a table?
State all possible different index configurations a table can possibly have?
What are the database administrators utilities available?
what is the difference between oracle enterprise edition and oracle express edition?
What is sharded cluster?
Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?
What is an oracle user account?
wirte the syntax of update query?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.