Answer Posted / suman j

Here first node will be default and second node will be
named instance. Both node will be active.

Move group from cluster administration is possible for both
side.

System performance will go down, if both resources are in
one node.

Active/Passive

Only one Active node with default instance.
No system performance degradation will be there for this
case even if we switchover to the other node. Both have
same configuration.

How do you migrate data from mssql server to azure?

165

---

What are scalar functions?

1000

---

what is memory-optimized nonclustered indexes

1016

---

Can you name a few encryption mechanisms in sql server?

942

---

Define union, union all, minus, intersect?

979

---

How to send email from database?

1013

---

How can you hide the sql server instances?

1021

---

Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many

944

---

What command is used to create a database in the sql server and how?

1180

---

Explain indexing and what are the advantages of it?

1028

---

What is the use of commit?

1000

---

What is 4nf in normalization form?

1025

---

Explain for xml explicit mode?

974

---

Does table partitioning improve performance?

969

---

What are the different types of triggers in SQL SERVER?

1138

---