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
What are roles in oracle?
How can you determine if the sqlnet process is running for sqlnet v1? How about v2?
If you see statistics that deal with "undo" what are they really talking about?
When should you increase copy latches? What parameters control copy latches?
What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?
You attempt to add a datafile and get: ora-01118: cannot add anymore datafiles: limit of 40 exceeded. What is the problem and how can you fix it?
Tell me about standby database? What are some of the configurations of it? What should we watch out for?
What does a dba stand for?
What is the difference between a database and instance?
Explain the process you follow to start looking into performance issue at database level(if the application is running very slow, at what points do you need to go about the database inorder to improve the performance?)
What file will give you oracle instance status information? Where is it located?
What is the use of the drop option in the alter table command?