What is a logical backup ?

Question Posted / guest

3 Answers
14338 Views
Wipro, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What is a logical backup ?..

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.

Is This Answer Correct ?

43 Yes

11 No

What is a logical 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.

Is This Answer Correct ?

39 Yes

11 No

What is a logical backup ?..

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).

Is This Answer Correct ?

18 Yes

2 No

Post New Answer

More Database Management Interview Questions

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,

What is the use of TABLES option in EXP command ?

1 Answers

What's the difference between clustered and non-clustered indexes?

0 Answers

What is data abstraction in dbms?

0 Answers

What is Full Backup ?

3 Answers

How do I add a file to a database?

0 Answers

How do you open .db files?