Answer Posted / kunal sain

Sql loader can import data from any flat files
where as import command import data from exported file.

In what script is "snap$" created? In what script is the "scott/tiger" schema created?

2438

---

What is the default port no on which sql server listens? : sql server DBA

1160

---

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

1001

---

how can you implement fine-grained auditing?

1136

---

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

993

---

what is a crs resource?

1166

---

What are the different ways you can create databases in sql server? : sql server DBA

1135

---

how can you find out if a table can be redefined?

1011

---

Why would you call update statistics? : sql server DBA

988

---

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

1265

---

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?

1983

---

Can you tell me about your experience with the administration of COTS system..? Also, how do you set up seed data..?

2634

---

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?

3408

---

What is a system database and what is a user database? : sql server DBA

1229

---

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

1078

---