Can we create index on views?

Answer Posted / khushin dhulla

yes

Is This Answer Correct ?    14 Yes 8 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

1800


Explain the use of tables option in exp command.

589


what are steps for interface? where is exchange rate defined in which table?

1493


How to bring a tablespace offline?

539


Define oracle database

594






Explain the use of constraints option in exp command.

558


What is meant by raw datatype?

565


What is execute immediate in oracle?

545


how to make an oracle object

1854


How to connect to a remote server?

553


Why does Oracle not permit the use of PCTUSED with indexes?

1947


What is the fastest query method to fetch data from the table?

860


Is oracle the best database?

518


How to delete a column in an existing table?

589


You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?

1453