Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / madhoosapre
An index cannot be defined on a view. Because view is
virtual table, which consists of a subset of columns from
one more tables.
The Restrictions imposed on views are as follows:
1. A view can be created only in the current database.
2. A view can be created only if there is a SELECT
permission on its base table
3. A Trigger or an Index cannot be defined on a view.
4. A view cannot be derive its data from temporary tables.
5. The CREATE VIEW statement cannot be combined with other
SQL statements in a single batch.
| Is This Answer Correct ? | 144 Yes | 67 No |
Post New Answer View All Answers
What is define in oracle?
Explain an index segment?
List out the difference between commit, rollback, and savepoint?
How can I convert single byte kana characters into multi byte kana characters and vice-versa.
Explain an integrity constrains?
What are the attributes of the cursor?
Explain what are the characteristics of data files?
What is the difference between 10g OEM and 11g OEM?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
How to define an external table with a text file?
How to use existing values in update statements using oracle?
What exactly do quotation marks around the table name do?
Why do we need integrity constraints in a database?
What to do if the binary spfile is wrong for the default instance?
What is the difference between primary key and unique key and foreign key in oracle?
