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 |
Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement
What are the source of constraints?
How to Display, Amount of Disk Activity Generated by Transact-SQL Statements?
Explain the functionalities that views support?
What do you understand by check constraint in sql server?
Do you know what are the properties of the relational tables?
What are subqueries in sql server?
Explain syntax for disabling triggers?
Will count(column) include columns with null values in its count?
What does the not null constraint do?
Explain what is the main purpose of having conversation group?
What is 2nf normalization?
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)