Answer / arul

pctfree and pctused only used for DMT tablespace for extent management allocations

What is the recommended interval at which to run statspack snapshots, and why?

1 Answers  

---

What is a system database and what is a user database? : sql server DBA

0 Answers  

---

Why would you use sql agent? : sql server DBA

0 Answers  

---

What authentication modes does sql server support? : sql server DBA

0 Answers  

---

wat is global index and local indes

1 Answers   Oracle,

---

---

I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution

0 Answers  

---

Query processing is slow(eg select query)how will u solve that

3 Answers   TCS,

---

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,

---

Explain the concept of the DUAL table.

3 Answers  

---

What are the different types of database compression introduced in sql server 2008? : sql server DBA

0 Answers  

---

How do you open a cluster administrator? : sql server DBA

0 Answers  

---

What is the difference between the SQL Loader and IMPORT utilities?

3 Answers  

---