What is the difference between online backup & offline backup?
Answer Posted / mogal
as said above every thing is same but one more point. i.e
" in a hot backup it have fractured blocks and where as in
cold backup there is no fractured blocks"
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA
How to start SQL Server in minimal configuration mode?
What is the difference between dropping a database and taking a database offline? : sql server DBA
how can you schedule a job in database?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
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.
how can you implement fine-grained auditing?
What are the recovery models for a database? : sql server DBA
What are the commands you'd issue to show the explain plan for "select * from dual"?
What are the steps you will take to improve performance of a poor performing query?
How can you control the amount of free space in your index pages? : sql server DBA
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
what is a user-defined lock?
How would you extract DDL of a table without using a GUI tool?
Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.