Interested to Buy Any Domain ? << Click Here >> for more details...
How to recover a dropped index?
- 1 Answers
- 1574 Views
- I also Faced
- E-Mail Answers
Answer / rajmohan
The index would come back but the name doesn't get changed and keeps the system name.
You can see that the index is there but didn't recover its original name.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is an Index ? How it is implemented in Oracle Database ?
WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.
What is a trace file and how is it created in oracle?
What is the difference between sharding and replication?
Who i will insert 1 lacks record in a Database table
Will you be able to store pictures in the database?explain.
What are the attributes that are found in a cursor?
What is the order of defining local variables and sub procedures/functions?
How to assign query results to variables?
What is a dynamic performance view in oracle?
State the difference along with examples between Oracle 9i, Oracle 10g and Oracle 11i.
Hi this srilatha. I comlpeted my Oracle-hrms. can u provide me interview questions on Core hr, payroll,sshr,OLM etc..
Oracle General 
