Answer Posted / rohit bhosale
In SQL server 2008 we have following types of backup:
1. full backup
2. differential backup
3. transaction log backup
4. tail log backup
5. mirror backup
6. Partial backup
7. copy only backup
8. split backup
9. compressed backup
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
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.
Explain materialized views and how they are used.
You have found corruption in a tablespace that contains static tables that are part of a database that is in NOARCHIVE log mode. How would you restore the tablespace without losing new data in the other tablespaces?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
internal architecture
Where would you look for errors from the database engine?
What are the operating modes in which database mirroring runs? : 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 are the differences of where and if in SAS?
how can you connect from 10g user to 11g user??
What is the difference between dropping a database and taking a database offline? : sql server DBA
Why would you call update statistics? : sql server DBA
suppose you want to audit specific activities on sensitive data. How can you achieve that?
What is the difference between the 2 operating modes of database mirroring? : sql server DBA
What are the recovery models for a database? : sql server DBA
