When should an artificial (or derived) primary key be used?
No Answer is Posted For this Question
Be the First to Post Answer
Explain the wait events in statspack report 'db sequential real'?
How can you determine if an oracle instance is up from the operating system level?
How do you prevent output from coming to the screen?
How do you install statspack?
What is pct free/pct used/pct increase parameter in segment? What is growth factor?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
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?
What are the data management skills?
What does the no logging option do? Why would we use it? Why would we be careful of using it?
What are the important tasks of common oracle dba?
What kinds of responsibilities does a dba have in a database environment?
What does an oracle dba do?