What is a logical backup ?

Question Posted / guest

3 Answers
15449 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

How do you delete a table from database?

0 Answers

What are the advantages of manual database?

0 Answers

I have one Excel file with 80,000 Records. Now I need to load that whole file into Oracle Database with same columns in Excel sheet . How can i do that?

3 Answers

Where the data file for system Tablespace is located? What is its name, initial size and maxsize?

1 Answers

What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?

0 Answers

What is a Data Warehouse and How is it Different from a Traditional Database?

1 Answers

Name two utilities that oracle provides, which are use for backup and recovery.

0 Answers

what is datapump? Difference between exp and expdp?

2 Answers Capital IQ, TCS, WNS,

What is cold backup (in case of oracle)?