Answer / monal

RAID: For FUN it is called Redundant Array of INEXPENSIVE
Disks.
In Reality it is called Redundant Array of Independent Disks.
Following 3 are most popular and still in use in different ways.
1. RAID 0: Disk Striping
2. RAID 1: Disk Mirroring
3. RAID 5: Disk Striping with Parity Bit.

How can you enable a trace for a session?

1 Answers  

---

What questions might be they ask in managerial round in capgemini.

1 Answers   Cap Gemini, iGate,

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

0 Answers  

---

What view(s) do you use to associate a user's SQLPLUS session with his o/s process?

0 Answers  

---

What are the steps you will take to improve performance of a poor performing query?

0 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,

---

what is asm?

0 Answers   Oracle,

---

What the different topologies in which replication can be configured? : sql server DBA

0 Answers  

---

what is the difference between db2start command and start database manager command?

1 Answers  

---

What would you use to improve performance on an insert statement that places millions of rows into that table?

2 Answers   TCS,

---

Can you take Online Backups if the the database is running in NOARCHIVELOG mode? 5. How do you bring the database in ARCHIVELOG mode from NOARCHIVELOG mode? 6. You cannot shutdown the database for even some minutes, then in which mode you should run the database?

11 Answers   FA, GE, Wipro,

---

From the database level, how can you tell under which time zone a database is operating?

1 Answers  

---