Answer Posted / ramesh

And the Advantage are
1.Maintaincace :-Can Take Partioned tables's tablespace
offline for recovery
while other partitions are still avialable to users
Hence the Avialability

2.Performace :As the Objects are plcaed in Diffrent
Tablespaces of Diffrent Servers/locations

In which dictionary table or view would you look to determine at which time a snapshot or MVIEW last successfully refreshed?

2674

---

Claims and Drains are the locks used to control the concurrency between SQL processes and utilities. Referring to the above statement, what is the maximum number of concurrent Claimers for a Subsystem? Choice 1 32 Choice 2 64 Choice 3 128 Choice 4 256 Choice 5 No limit

2250

---

Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.

2544

---

What is dcl? : sql server DBA

1208

---

What is transparent data encryption? : sql server DBA

1137

---

how can you implement fine-grained auditing?

1088

---

what is the diffrence between core dba and apps dba?

2530

---

i have 10gp file.now i need store in database..but database have only 7gb memory only..how do u store the file ?

2031

---

List out some of the requirements to setup a sql server failover cluster.? : sql server DBA

1212

---

What is replication? : sql server DBA

1118

---

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

2380

---

Explain about your sql server dba experience? : sql server DBA

1041

---

What happens on checkpoint? : sql server DBA

1049

---

Does any body has ORACLE Certification Dumps or Materials on 9i DBA, 10G DBA, Internet Application Developer, OCP 8i to 10g DBA Upgrade, Oracle 11i if any body have it, please kindly drop an email to: taruni_2k8@yahoo.com

2072

---

What are the steps you will take to improve performance of a poor performing query?

2812

---