Can we create index on views?

Answer Posted / tanuj

NO in ORACLE, but YES in SQL. :-)

Is This Answer Correct ?    2 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the types of exception?

660


what is the use of triggers in Java program? I mean where do we use triggers in Java programming?

1701


What is Undo Management Advisor in Oracle?

618


How to drop an existing table in oracle?

602


What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1611






What is system global area (sga) in oracle?

580


Difference between oracle's plus (+) notation and ansi join notation?

582


What do you mean by a tablespace?

568


What is the relationship among database, tablespace and data file?

550


What are the arithmetic operations?

594


How to create a temporary table in oracle?

694


How to retrieve values from data fields in record variables?

579


What are the uses of Database Trigger ?

1114


Can we convert a date to char in oracle and if so, what would be the syntax?

554


Can we store images in oracle database?

555