Explain Active/Active and Active/Passive cluster
configurations?
Answer / 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.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is 5nf in normalization form?
What is an entity-relationship diagram (erd)?
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue
Explain the storage models of OLAP?
What is the difference between functions and scalar functions?
Which trace flags are enabled in sql server?
What is a partitioned view?
What is the use of “join” in sql server?
What is the difference between clustered and a non-clustered index?
Explain triggers in sql?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
How do I make a resultset scrollable?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)