When should an artificial (or derived) primary key be used?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Oracle DBA (Database Administration) Interview Questions

Explain the wait events in statspack report 'db sequential real'?

0 Answers  


How can you determine if an oracle instance is up from the operating system level?

0 Answers  


How do you prevent output from coming to the screen?

0 Answers  


How do you install statspack?

0 Answers  


What is pct free/pct used/pct increase parameter in segment? What is growth factor?

0 Answers  






What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?

0 Answers  


Explain dual table. Is any data internally stored in dual table. Lot of users is accessing select sysdate from dual and they getting some millisecond differences. If we execute select sysdate from emp; what error will we get. Why?

0 Answers  


What are the data management skills?

0 Answers  


What does the no logging option do? Why would we use it? Why would we be careful of using it?

0 Answers  


What are the important tasks of common oracle dba?

0 Answers  


What kinds of responsibilities does a dba have in a database environment?

0 Answers  


What does an oracle dba do?

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)