Answer / nirav gajjar

The "ORA-01555 snapshot too old" error, which causes user
transactions to fail, is a nightmare for Oracle DBAs and
developers. It usually occurs after queries or batch
processes have been running for a long time, which means
you can lose many hours of processing when the error crops
up.

Answer / kittu

The ora-1555 is too old snapshot. In order to fix this e need to increase undo_retention & undo tablespace size

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

1 Answers   Cap Gemini, iGate,

---

What is the difference between dropping a database and taking a database offline? : sql server DBA

0 Answers  

---

what is the use of recording information about current session?

0 Answers   Oracle,

---

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,

---

Explain an ORA-01555

2 Answers  

---

---

what functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

1 Answers  

---

How can you control the amount of free space in your index pages? : sql server DBA

0 Answers  

---

Explian different types of BACKUPs avaialabe in SQL Server? Given a particular scenario, how would you go about choosing a backup plan?

1 Answers  

---

A lady is trying to pick gloves and hats from her wardrobe in the dark. She has 22 white and 33 green ones. She wants to pick a pair of gloves of white and green. How many tries before she gets it right?

1 Answers   TCS,

---

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

4 Answers   TCS,

---

wat is global index and local indes

1 Answers   Oracle,

---