Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / itishree chhotray
View should be Schema binding,before creating index on view.
We can create Unique Clustered index on view after that we
can create non clustered index but we should have at least
one unique clustered index on view.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
In which language oracle has been developed?
Why is oracle database so popular?
How to get execution statistics reports on query statements?
Explain how are indexes update?
How to run create database statement again?
What happens if the update subquery returns multiple rows?
What privilege is needed for a user to connect to oracle server?
What is Segment Advisor in Oracle?
Can objects of the same schema reside in different tablespace?
Why do we use coalesce function in oracle?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.
How to drop a tablespace?
Who developed oracle & when?
How to use subqueries with the in operator using oracle?
How to manage transaction isolation level?
