Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pravin patil
Vies is logical representaion of parent table
& index is oralce object use to access table' column quickly
view can replace but index cannot replace u have to delect
existed index then create new index.
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What operating systems are supported by oracle database 10g xe?
Can we store images in oracle database?
An automatic job running via DBMS_JOB has failedKnowing only that its failed, how do you approach troubleshooting this issue?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
what is the need of indexing topic in oracle? where do we use in a Java project? any other option other than using this to get the same result where we use indexing ?
How to pass a cursor variable to a procedure?
What is system global area (sga) in oracle?
What is the Tune Query
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
How many objectname will be created for a single table drop function? Why 'flashback' query giving error "ORA-38312: original name is used by an existing object" while getting the table?
How to turn on or off recycle bin for the instance?
Differentiate between function and procedure in oracle.
Does oracle database need java?
What are the different types of failures that occur in Oracle database?
How do I find the database name in oracle?
