What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
No Answer is Posted For this Question
Be the First to Post Answer
How do you analyze table partition using oracle provided package?
How can you determine if an index needs to be dropped and rebuilt?
What is an artificial (derived) primary key? When should an artificial (or derived) primary key be used?
Tell me about standby database? What should we watch out for?
I have applied the following commands: now what will happen, will the database will give an error / it will work?
What is the finger command?
How do you put database is archivelog mode, explain procedure?
How to drop an oracle database?
What exactly does a dba do?
Where would you look to find out if a redo log was corrupted assuming you are using oracle mirrored redo logs?
What will you do if in any condition you do not know how to troubleshoot the error at all and there are no seniors or your co-workers around?
Explain the various modes of normalization?