Answer / kishor

move/copy of the data from one server to another server is
call replication
types of replication

1.snapshot
2.merge
3.transactional
4.transactional with up-datable subscription(newly added in
sql server2005)

How would you determine what sessions are connected and what resources they are waiting for?

2 Answers  

---

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

0 Answers  

---

What does coalescing a tablespace do?

1 Answers  

---

why we use cursors

1 Answers  

---

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

0 Answers  

---

---

why Datapump is faster than traditional export and import

4 Answers   Mphasis,

---

If you're unsure in which script a sys or system-owned object is created, but you know it's in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?

1 Answers  

---

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

0 Answers  

---

What's the benefit of "dbms_stats" over "analyze"?

1 Answers  

---

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

0 Answers  

---

You create a private database link <link name> and upon connection, fails with: ORA-2085: <Link name> connects to <fully qualified remote db name>. What is the problem? How would you go about resolving this error?

0 Answers  

---

How to bind a cobol module to a given job? I am not able to understand this concept.Can anyone help me out as how to carry out this task?

0 Answers   EDS,

---