Answer Posted / s. manzoor ahamed

1. Type of Backups option in oracle are
Cold backup / Hot (Online) backup, Logical backups
using Exp and imp client utilities, RMAN Backups.

2. Only Cold backup can be taken and no other options.

3. No. Need to take full consistent backup.

4. No. You can't take online backup if the db is configured
in Noarchivelog mode.

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2591

---

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?

2048

---

What are the operating modes in which database mirroring runs? : sql server DBA

1124

---

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

943

---

What is a correlated sub-query? : sql server DBA

1021

---

What are the recovery models for a database? : sql server DBA

1080

---

A table is classified as a parent table and you want to drop and re-create it. How would you do this without affecting the children tables?

2418

---

what is the role of dip user in our database?

2371

---

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

1844

---

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

3713

---

What is fill factor? : sql server DBA

1192

---

. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?

2411

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

2054

---

what is the diffrence between core dba and apps dba?

2523

---

what is a user-defined lock?

1000

---