Answer Posted / mathavan

Indexes are used for faster access of required data in a
large table.

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?

1543

---

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

564

---

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

1747

---

what is asm?

608

---

How would you extract DDL of a table without using a GUI tool?

2049

---

---

what are the differences of where and if in SAS?

1664

---

Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA

601

---

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

843

---

What the different components in replication and what is their use? : sql server DBA

540

---

Which autogrowth database setting is good? : sql server DBA

581

---

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

559

---

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

708

---

how can you implement fine-grained auditing?

606

---

What purpose does the model database server? : sql server DBA

630

---

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

567

---