How do you increase the OS limitation for open files (LINUX and/or Solaris)?

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

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

0 Answers  

---

how can you process messages in order asynchronously?

0 Answers   Oracle,

---

Explain what partitioning is and what its benefit is.

2 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

0 Answers  

---

What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?

0 Answers  

---

What are the operating modes in which database mirroring runs? : sql server DBA

0 Answers  

---

Explain CREATE DATABASE syntax?

2 Answers  

---

by issuing "alter tablespace begin backup;" what happens to tablespace?

5 Answers   CSC, Logica CMG,

---

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,

---