Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 521 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
A dba had to remove some archivelogs to free up space in filesystem. Nowwhen the rman job starts to backup archivelogs, it complains about missing archivelogs thatwere deleted by dba. To resolve the issue and continue backing up remainder of archivelogs,which rman command can be used so it wo not complain about missing archivelogs.
What are the various ingredients of sga?
Explain force logging feature in 9i.
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?
What are the possible ways to gain information regarding the control file?
How many redo logs should you have and how should they be configured for maximum recoverability?
Discuss row chaining, how does it happen? How can you reduce it? How do you correct it?
What happens if a tablespace clause is left off of a primary key constraint clause?
What parameters control copy latches?
Do you need a commit after ddl statements?
How many dba can you have?
How to uncatalog backup?
Oracle General 
