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
How to use in conditions in oracle?
Is rowid unique in oracle?
What happens if the imported table already exists?
Give the various rollback segment states.
Can we use bind variables in oracle stored procedure?
What is oracle instant client?
Explain parameter file in oracle.
Explain the characteristics of oracle dba?
What is merge statement used for?
How to create tables for odbc connection testing?
How to define a variable to match a table column data type?
What is the difference between primary key and unique key and foreign key in oracle?
What is max rowid in oracle?
How to assign a tablespace to a users in oracle?
Give the constructs of a package, function or a procedure.
