Answer / Siddharth

SQL Server offers three main replication topologies: Simple, Transactional, and Merge. In Simple Replication, only data is replicated. Transactional Replication includes transactions, triggers, and snapshots. Merge Replication allows both conflict resolution and bi-directional replication.

What view would you use to look at the size of a data file?

3 Answers  

---

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

1 Answers  

---

What is transparent data encryption? : sql server DBA

1 Answers  

---

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

1 Answers  

---

Name three advisory statistics you can collect.

1 Answers  

---

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.

1 Answers  

---

Give two examples of how you might determine the structure of the table DEPT.

2 Answers  

---

In oracle 10g export, import if we declare rows=y/n what would be the output?

0 Answers   Value Labs,

---

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

1 Answers  

---

how to restore files with rman?

1 Answers  

---

An automatic job running via DBMS_JOB has failed. Knowing only that "it's failed", how do you approach troubleshooting this issue?

1 Answers  

---

what functionality does oracle provide to secure sensitive information?

1 Answers   Oracle,

---