Answer / Piyush Saxena

SQL Server Replication can be configured using various topologies, such as: 1) Single Publisher (single source of data), 2) Multiple Publishers (multiple sources of data), 3) Snapshot-Only Publication (publishes a static snapshot of the data), and 4) Peer-to-Peer Topology (equal partnership between two or more replicas).

How you can get a list of all the table constraints in a database? : Sql server administration

1 Answers  

---

What is index fragmentation in ms sql server?

1 Answers  

---

How can you list all the table constraints in a database?

1 Answers  

---

Can you explain what are commit and rollback in sql?

1 Answers  

---

A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?

1 Answers  

---

What are the advantages of the mirroring?

1 Answers  

---

Does partitioning improve performance?

1 Answers  

---

What is the data type of time?

1 Answers  

---

What is blocking and how would you troubleshoot it?

3 Answers   HCL,

---

my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions

1 Answers  

---

Can you explain full-text query in sql server?

1 Answers  

---

Which system table contains information on constraints on all the tables created?

2 Answers  

---