Answer Posted / dibya tara shakya
No we cannot create index in views. As view are virtual
table based on multiple or single static tables.
View are create and execute only if there is select
privilege in base table to create view .
Triggers are also create in views.
But we can treat a view a table which make ease to gather
the data from different tables. we can insert data from
views only if the view are created from single table.
| Is This Answer Correct ? | 23 Yes | 34 No |
Post New Answer View All Answers
Explain alias?
What is dynamic proxy?
How to shutdown your 10g xe server from command line?
Name the three major set of files on disk that compose a database in Oracle?
Give the various rollback segment states.
Difference between oracle's plus (+) notation and ansi join notation?
What is a dead lock in oracle?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
What is an oracle recycle bin?
Explain drop constraint oracle?
How to enter a new row into a table interactively?
How do I learn what codesets are available in oracle?
How can I see all tables in oracle?
How to define an anonymous block?
What are the different types of failures that occur in Oracle database?
