How should a many-to-many relationship be handled?
No Answer is Posted For this Question
Be the First to Post Answer
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?
If a tablespace has a default pctincrease of zero what will this cause (in relationship to the smon process)?
Explain force logging feature in 9i.
What is dump destination? What are bdump, cdump and udump?
What do you mean by oracle database?
what does the no logging option do? Why would we use it?
What is the difference between a materialized view (snapshot) fast refresh versus complete refresh? When is one better, and when the other?
How can you find your id on a system?
What is oracle full backup?
What do you mean by oracle dba and what is its role?
Where can you get a list of all initialization parameters for your instance? How about an indication if they are default settings or have been changed?
Is oracle dba in demand?