What is cold backup ? What are the elements of it ?
Answer / chaudhry
Cold backup is taking backup of all physical files after
normal shutdown of database. We need to take.
- All Data files.
- All Control files.
- All on-line redo log files.
- The init.ora file (Optional)
| Is This Answer Correct ? | 5 Yes | 1 No |
What are the steps involved in Database Shutdown ?
What are the different events in Triggers ?
What are dml and ddl statements?
what is difference between clustering and mirroring?
Difference between data and information, and how are they related in a database?
What is normalization in database with example?
You loss one datafile and DB is running in ARCHIVELOG mode. You have full database backup of 1 week old and partial backup of this datafile which is just 1 day old. From which backup should you restore this file?
Define ddl and dml.
Have you heard about sixth normal form?
What is Two-Phase Commit ?
What are the examples of database?
What is the difference between a catalog and a database?
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)