Answer Posted / gangaram

1- types of backup are cold backup and hot backup.
2-cold backup
3-no u cant take partial backup. but u can have a
tablespace back up . u need to make the tablespace offline
and then begin backup of tablespace.
4-no the database should be in archive log mode always.

What are the different authentication modes in sql server and how can you change authentication mode? : sql server DBA

1058

---

What is replication? : sql server DBA

1118

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1039

---

how can you create a user-defined lock?

979

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

949

---

Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?

3718

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

2053

---

how can you get actual data change values from previous transactions in oracle?

1056

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

943

---

What are the different types of upgrades that can be performed in sql server? : sql server DBA

1169

---

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

2249

---

What is the difference between clustered and non-clustered index? : sql server DBA

1042

---

what is the last version,the release date of that version and fix pack of ibm db2 udb?

1934

---

What is the default fill factor value? : sql server DBA

1077

---

What would you do with an "in-doubt" distributed transaction?

1851

---