Interested to Buy Any Domain ? << Click Here >> for more details...
Explain the difference between a hot backup and a cold
backup and the benefits associated with each?
- 7 Answers
- 21868 Views
- TCS, I also Faced
- E-Mail Answers
Answer Posted / vaishnav
when the database is closed then this backup is called cold
backup. while, when the database is running/opened then
this backup is called hot backup.
| Is This Answer Correct ? | 15 Yes | 1 No |
Post New Answer View All Answers
how can you get actual data change values from previous transactions in oracle?
Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
How can you control the amount of free space in your index pages? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
How does propagation differ between Advanced Replication and Snapshot Replication (read-only)?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA
Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.
What are the commands you'd issue to show the explain plan for "select * from dual"?
which background process invoke at the time of upgradation tell me???
A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
