Answer / ramakrishnach.dba

catalog initiates to take backup of database and results will be stored in catalog

Answer / kanna

catalog is initiated to store matadata,backup info and rman architecture

what is the difference between off-line back up and on-line back up in ibm db2 udb?

2 Answers   Zenith,

---

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

0 Answers  

---

How do you switch from an init.ora file to a spfile?

4 Answers   TCS,

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

How do you find out from the RMAN catalog if a particular archive log has been backed-up?

2 Answers   IBM,

---

I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB

0 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

How would you go about generating an EXPLAIN plan?

2 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

which background process invoke at the time of upgradation tell me???

0 Answers   iGate,

---

How would you determine who has added a row to a table?

4 Answers  

---