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 views in dbms?
What are the advantages of a database?
Discuss some of the techniques that can be used to tune operational performance.
What SYSTEM VARIABLE is used to refer DATABASE TIME ?
What are the 4 main objects of a database?
What is the use of NOARCHIEVELOG parameter in Database?
What is a string in database?
Enlist some commands of dml?
Where is data stored in a database?
What is a candidate key in a database?
Which two can be implemented as a centrally located logical architecture?
Describe and contrast sql and qbe.
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)