How are the index updates?
Answer / nishi
Indexes are automatically maintained and used by Oracle. Changes to table data are automatically incorporated into all relevant indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Difference between inner join vs where ?
what is the use of ondelete cascade?
According to oracle specification VIEW is a object. OBJECT that means anything stored in the oracle database that has the physical existence.why VIEW doesn't take memory in oracle database, but it is treated as a object ?Please explain ?
What are a query and state the different types of queries and their uses?
I need to get the values of the previous quarter.how to do this?eg: if my cuurent month is may i need to get the datas of the month jan,feb,march.Can it be done in oracle.I tried with date function q but for the month jan its not retriving the previous quarter(oct-dec).how to solve this.plpz anyone help me?
What is sharded cluster?
What is Public Database Link ?
What happens to the current transaction if the session is ended?
what is a Nested Loop join?
What is different bet native dynamic sql and Dbms_Sql?
What are the predefined tablespaces in a database?
How to use windows user to connect to the server?