What is cold backup ? What are the elements of it ?
Answer Posted / chaudhry
Cold backup is taking backup of all physical files after
normal shutdown of database. We need to take.
- All Data files.
- All Control files.
- All on-line redo log files.
- The init.ora file (Optional)
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
What is a functional dependency in the dbms?
What do you understand by ‘atomicity’ and ‘aggregation’?
What is database definition (dbd)?
What is tuple in dbms?
What is raid controller technology?
What is data management process?
What is the difference between internal and external schema?
Define truncate and delete commands?
Explain the terms ‘record’, ‘field’ and ‘table’ in terms of database.
1. How many nodes you are using project? 2. What is configuration file? 3. What is modules partition? How it is work in project? 4. What is Environment Variable? How it is use? 5. What is sequence? 6. How do you execute parallel jobs in projects? 7. If you run a job in job sequencer individually without any comments? 8. How many jobs did in your project? 9. How to schedule the job in Data stage 7.5 X2? 10. If you have 10 jobs in PX2, shall you run all jobs at a time? 11. I have 5 jobs (1-5), I connect with each other, but I want to run from 3-5 only how? 12. What is same partition? 13. If you have 40GB hard disk in I have 30GB data how I configure the nodes for partition? 14. Did you write any code for Data stage project? 15. Did you write any code for parallel job execution in your project? 16. Will you schedule all jobs at a time?
Define denormalization.
Explain 3nf?
What is the relationship?
What is metadata and why should I use it?
How to extract metadata for the entire database?