Answer Posted / mahesh kumar
we can never create index on view, becasue view doesn't
have physical memory. If we try to create index on view in
oracle, produce error: a view is not appropriate here
Is This Answer Correct ? | 1 Yes | 1 No |
Post New Answer View All Answers
How would you configure your networking files to connect to a database by the name of DSS which resides in domain icallinc.com?
How can you merge two tables in oracle?
What is bulk collect in oracle?
What is difference between cartesian join and cross join?
Can we commit inside a function in oracle?
How to get last row id?
What are the restrictions in a oracle read only transaction?
List out the components of logical database structure of oracle database.
How do I call oracle stored procedures that take no parameters?
What are the oracle built-in data types?
What is the minimum client footprint required to connect c# to an oracle database?
Explain the use of online redo log files in oracle.
How to sort the query output in oracle?
What are the most common interview questions on ETL Testing for experience?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?