How are Indexes Update ?
Answer / orawhiz
Indexes are automatically maintained and used by ORACLE.
Changes to table data are automatically incorporated into
all relevant indexes.
| Is This Answer Correct ? | 4 Yes | 2 No |
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
where do i find oracle interview questions.
How to define a data field as not null?
What is a Garbage Collection? and what is full recursive Garbage collection?
Why oracle is used?
What are advantages fo Stored Procedures?
What is Hash Index?
WHAT IS ecc 6.0
How to define a specific record type?
can a table has a column that has only view data and in other columns we can change data?
What is an Oracle sequence?
What is a tns service name?