Answer Posted / kalyan maddipati

you mean to say that the same Oracle database should be at another place and what all the changes made to the Parent database should reflect on the child database? If U wanna that then it is know as parallel servers till 9.0 but from 10G we have the same concept with another name data guard.

How to craeate the New Database Schema in Oracle and mysql? Please tell me with Example?

2408

---

What is a correlated sub-query? : sql server DBA

1005

---

Assuming today is Monday, how would you use the DBMS_JOB package to schedule the execution of a given procedure owned by SCOTT to start Wednesday at 9AM and to run subsequently every other day at 2AM.

2096

---

What is the difference between clustered and non-clustered index? : sql server DBA

1024

---

How many files can a database contain in sql server?how many types of data files exists in sql server? How many of those files can exist for a single database? : sql server DBA

1137

---

What are the commands you'd issue to show the explain plan for "select * from dual"?

2186

---

Which autogrowth database setting is good? : sql server DBA

1058

---

What the different topologies in which replication can be configured? : sql server DBA

1180

---

Where do you find the default index fill factor and how to change it? : sql server DBA

1022

---

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

2641

---

currently iam working in mnc as a oracleappsdba,please send the EXPERIENCE RESUME those who r worked as a oracle apps dba

2375

---

What is fill factor? : sql server DBA

1182

---

What is the difference between the 2 operating modes of database mirroring? : sql server DBA

933

---

Illustrate how to determine the amount of physical CPUs a Unix Box possesses (LINUX and/or Solaris).

1920

---

How do you trace the traffic hitting a sql server? : sql server DBA

1464

---