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

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

1 Answers  

---

What command would you use to create a backup control file?

2 Answers  

---

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?

1 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

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

1 Answers  

---

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

1 Answers  

---

Explain the use of table functions.

1 Answers  

---

CTS int questions: 1.Temperory tablespace corrupted,how to resolve?If you need to recover? 2.In tablespace begin backup mode,Its possible to add the datafile? 3.How to partition the table using Hash partioning,what happened internally? 4.During rman backup,some files are missing Rman will continue the backup? 5.what are the errors occurs frequently? 6.which join method is best?why? 7.how to solve deadlock errors? please reply anyone.... regards siva

2 Answers   CTS,

---

What command would you use to encrypt a PL/SQL application?

1 Answers  

---

Compare and contrast TRUNCATE and DELETE for a table.

7 Answers  

---

How can we know the exact updation date of a particular database?

2 Answers   Satyam,

---

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

1 Answers  

---