Answer Posted / naveen
The means by which ACID is enforced in Oracle are :
Undo Segments - for Atomicity
Undo Segments - for Consistency
Undo Segments & Locks - for Isolation
Redo Logs - for Durability
| Is This Answer Correct ? | 19 Yes | 4 No |
Post New Answer View All Answers
1. What is Container? 2. Tell me about your project? 3. Which container you are used in your project? 4. What is Surrogate key? 5. How you are implemented it? 6. Difference between Server job and Parallel job? 7. What is your Target Database? 8. What is Source System? 9. Difference between Join and Lookup? 10. Are you maintaining historical data? What is the logic used to maintained to historical data? 11. Do you have documents for mapping?
Why are databases so important?
Are databases stored on servers?
What is the difference between multiload and fastload interms of performance?
What is db driver?
Explain issues for database performance.
What is the difference between shrink database and shrink file?
What do you understand by the view and mention the steps to create, update and drop a view?
How does distributed database work?
What is foreign key in database?
What is the 3-tier architecture?
What is 2nf in the dbms?
What are the different stages in 'data warehousing'?
What is the difference between hashed file stage and sequential file stage in relates to datastage server?
Define stored procedures.
