Answer Posted / deepak

alter index <indexname> rebulid;

If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA

1026

---

What are the different sql server versions you have worked on? : sql server DBA

1022

---

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.

2574

---

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

1206

---

how can you get actual data change values from previous transactions in oracle?

1098

---

What the different types of replication and why are they used? : sql server DBA

1184

---

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

2261

---

how can you connect from 10g user to 11g user??

2121

---

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

1095

---

how do we explain a project in cognos in an interview? please help me. Also how do we perform testing in cognos after creating reports?

3419

---

What are the recovery models for a database? : sql server DBA

1140

---

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

1990

---

Explain the difference between a FUNCTION, PROCEDURE and PACKAGE.

2351

---

How do you troubleshoot errors in a sql server agent job? : sql server DBA

1135

---

What is replication? : sql server DBA

1188

---