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 built in subprogram is used to manipulate images in image items ?
Define dbms.
What is a Federated Query ?
Is a server a database?
What do you understand by the view and mention the steps to create, update and drop a view?
What is index hunting?
If you need to refresh a website page every time a record is updated in database, how would you do it?
How do you open .db files?
What is hot backup and how it can be taken ?
What are the restrictions applicable while creating views?
What do you understand by ‘database’?
What is correlated subquery in dbms?
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)