Answer / girish k

1. HOT and COLD Backups
2. COLD Backup
3. NO
4. NO

Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracle's. What database recovery options are available? Database is in archive log mode.

0 Answers   Infosys,

---

What SQL query from v$session can you run to show how many sessions are logged in as a particular user account?

3 Answers  

---

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   IBM,

---

How do you tell what your machine name is and what is its IP address?

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,

---

---

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

0 Answers  

---

Can we take incremental backups in datapump?

1 Answers  

---

How would you begin to troubleshoot an ORA-3113 error?

1 Answers  

---

What is RAID and what are different types of RAID configurations?

1 Answers  

---

You're getting high "busy buffer waits" - how can you find what's causing it?

1 Answers  

---

orra 1555 what is this error,why it is occur?

2 Answers   Mphasis,

---

How can you rebuild an index?

6 Answers  

---