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

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

What are roles in oracle?

0 Answers  


How can you determine if the sqlnet process is running for sqlnet v1? How about v2?

0 Answers  


If you see statistics that deal with "undo" what are they really talking about?

0 Answers  


When should you increase copy latches? What parameters control copy latches?

0 Answers  


What happens if a primary key constraint is disabled and then enabled without fully specifying the index clause?

0 Answers  






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?

0 Answers  


Tell me about standby database? What are some of the configurations of it? What should we watch out for?

0 Answers  


What does a dba stand for?

0 Answers  


What is the difference between a database and instance?

0 Answers  


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?)

0 Answers  


What file will give you oracle instance status information? Where is it located?

0 Answers  


What is the use of the drop option in the alter table command?

0 Answers  


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)