Answer / daid kumar

When we Perform the larg DML operation on a table then this
Error is occure
ORA-01555 snapshot too old
to remove this error in 8i or below version You have to
increase the size or rollback segment
and in above version You can Increase the Size Of Undo
tablespace

Answer / ashok

increase the size of undo tablespace
increase retention period

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

0 Answers  

---

What is database replicaion? What are the different types of replication you can set up in SQL Server?

1 Answers  

---

Explain the concept of the DUAL table.

3 Answers  

---

Can you take Image Backups using RMAN? . Can you use Backupsets created by RMAN with any other utility

1 Answers   Tech Mahindra,

---

I want to reuse a piece of code inside a stored procedure. This piece of code need to be invoked multiple times inside the procedure based on some different conditions. How to achieve this?

1 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 functionality does oracle provide to secure sensitive information?

0 Answers   Oracle,

---

Explain the difference between ARCHIVELOG mode and NOARCHIVELOG mode and the benefits and disadvantages to each.

5 Answers  

---

What are the commands used in dcl? : sql server DBA

0 Answers  

---

how does an oracle clusterware manage crs resources?

0 Answers   Oracle,

---

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

2 Answers  

---

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

1 Answers  

---