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 |
How do you handle your own transaction?
How to specify transaction or query timeout?
There are 100 datafiles, numbered from 1 to 100. File number 10 is deleted and it has 500 MB of data. The database is working in archive log mode. How can be the database recovered ? While doing recovery the archive logs applied are from nos 1 to 100, but 50 gets corrupted. What do we do? Can we proceed further? If so how?
What is the main difference between union and union all?
PL/SQL supports which datatypes?
What are 4 types of models?
what Kind of COMMENT statements placed within SQL statements ?
Can the User set Archive file name formats ?
Define sub-query.
How do you start a database?
Describe the difference between homogeneous and heterogeneous distributed database.
how can i get company email id's can anybody answer to this question. bcz it is very important for me, looking for the best answer.
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)