Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between online backup & offline backup?
- 3 Answers
- 10921 Views
- CSC, I also Faced
- E-Mail Answers
Answer Posted / suman
we have two types of backups that is inconsist backup and
consistent backup
online backup is inconsistent backup
offline backup is consistent backuup
1.when the database is up on running at that time we have to
take the online backup it means hot backup
2.when the database is shutdown stage at that time we have
to take the offline backup it means cold backup this is the diff
| Is This Answer Correct ? | 13 Yes | 1 No |
Post New Answer View All Answers
What is the difference between dropping a database and taking a database offline? : sql server DBA
What the different topologies in which replication can be configured? : sql server DBA
Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit
What types of replication are supported in sql server? : sql server DBA
Why would you call update statistics? : sql server DBA
Why does Oracle not permit the use of PCTUSED with indexes?
How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA
How would you go about verifying the network name that the local_listener is currently using?
What is a system database and what is a user database? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.
Explain materialized views and how they are used.
What happens on checkpoint? : sql server DBA
What are the different sql server versions you have worked on? : sql server DBA
how can you enable flashback feature?
