one datafile is lost in standy side how can you recover that??

2 Answers  

---

Should you place Recovery Catalog in the Same DB? . Can you use RMAN without Recovery catalog

4 Answers  

---

1. how do you delete duplicate rows in a table? 2. can you disable and enable primary key? 3. how do you move tables from one tablespace to another tablespace?????

2 Answers   Genpact,

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

. 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?

0 Answers  

---

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

2 Answers   Zenith,

---

Give the two types of tables involved in producing a star schema and the type of data theyhold.

2 Answers  

---

can u plz tell me what r the mandatory skills for getting job as a sql dba......plz send me all details thank you my id :k.mohann.mohan@gmail.com

0 Answers  

---

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

0 Answers  

---

What view would you use to look at the size of a data file?

3 Answers  

---

How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

What is replication? : sql server DBA

0 Answers  

---