Answer / chaudhry

Logical backup involves reading a set of databse records
and writing them into a file. Export utility is used for
taking backup and Import utility is used to recover from backup.

Answer / vivek

Logical backup is a process of extracting data in the form
of SQL statements,where it is useful to recover in case the
objects ate lost.The main drawback of this backup is that MEAN
TIME TO RECOVER is high.

Answer / brajendra arzare

Logical backups are backups in which the export utility
(for example exp) uses SQL to read database data and then
export it into a binary file at the operating system level.
We can then import the data back into a database using the
import utility (imp).

what is difference between 1.append to media 2.overright the existing media when we take back up in sql server2000

0 Answers   Indian Web Technology,

---

what the REPLACE('JACK AND JUE','J','BL') will return ?

1 Answers   HCL, IBM, Wipro,

---

What are partitions in database?

0 Answers  

---

What do you understand by b-trees?

0 Answers  

---

What is database management system(dbms) and why it is used?

0 Answers  

---

What is " group by " clause?

0 Answers  

---

What is the difference between a delete command and truncate command?

0 Answers  

---

What are the 3 types of relationships in a database?

0 Answers  

---

Explain what are the types of transparencies?

0 Answers  

---

Enlist the various transaction phases.

0 Answers  

---

What do you understand by query optimization?

0 Answers  

---

8. Sort, Lookup What kind of technique (partition) is used? 9. How can you handle exceptions in job sequencer? 10. How do you apply custom conditions an exceptions (How do you trigger exceptions in job sequence?) 11. I have a job with 3 possibilities? Finish with ok…..Abort…….Warning} How do you handle these in Job sequencer 12. How do you connect both OK and Warning can we? 13. How to find which process is running currently? 14. How do you find the disk usage in UNIX? 15. How do you combine 2 sequential files having same metadata of same file names? 16. How do you implement SCD in Ds? 17. Explain the situation where you have applied? 18. How do you apply new changes to? 19. Difference between change capture and Change apply? 20. Explain Compare Stage? 21. What is Surrogate key? 22. How to solve the problem of null values?

0 Answers   IBM,

---