Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


Differnce between view and index

Answers were Sorted based on User's Feedback



Differnce between view and index..

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

Differnce between view and index..

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
a table.
An index is created on multiple columns but on a single
table.
Index is maintained by Oracle Server itself.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More Oracle General Interview Questions

How do I manually uninstall oracle client?

0 Answers  


When do you get a .pll extension in oracle? Explain its importance

0 Answers  


what is the difference between simple view and complex view?

13 Answers  


What is a view and how is it different from a table?

0 Answers  


State all possible different index configurations a table can possibly have?

0 Answers  






What are the database administrators utilities available?

0 Answers  


what is the difference between oracle enterprise edition and oracle express edition?

2 Answers  


What is sharded cluster?

0 Answers  


Will the Optimizer always use COST-based approach if OPTIMIZER_MODE is set to "Cost"?

1 Answers  


What is an oracle user account?

0 Answers  


wirte the syntax of update query?

3 Answers   IBM,


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

0 Answers   Wipro,






Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (509)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)