What is a logical backup ?
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
What are the factors causing the reparsing of SQL statements in SGA?
What is tabular form?
What do you understand by b-trees?
Explain the different types of database keys?
How can we check whether A S M instance is up or down?
What is rdbms with example?
Is there an example how to configure udfaccess setting in firebird.conf?
Explain data dictionary.
Which database is faster?
What is the use of FILE option in IMP command ?
What do you mean by dml compiler?
how can we store space between two strings in database i.e oracle