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

3 Answers   TCS,

---

Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?

0 Answers  

---

what is the use of ocr?

0 Answers   Oracle,

---

Is it possible to update the multiple field values in a single query? If possible then write the actual query.

1 Answers   Oracle,

---

What are statistics, under what circumstances they go out of date, how do you update them?

0 Answers  

---

What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA

0 Answers  

---

i want export 50gb data in datapump it will take 2 hours time to complete that how can u export that tell me script ???

1 Answers   iGate,

---

How would you go about verifying the network name that the local_listener is currently using?

0 Answers  

---

How can you tell how much space is left on a given file system and how much space each of the file system's subdirectories take-up?

0 Answers  

---

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

5 Answers   CSC, Logica CMG,

---

Provide an example of a shell script which logs into SQLPLUS as SYS, determines the current date, changes the date format to include minutes & seconds, issues a drop table command, displays the date again, and finally exits.

0 Answers  

---

Draft one mock email requesting your non-technical management grant you downtime to (provide justification where applicable) complete the following tasks: (1) Generate statistics on a large table; (2) Generate an RDA – if you don't know what an RDA is please say so. (3) Rename datafiles.

0 Answers  

---