ALLInterview.com :: Home Page KalAajKal.com
 Advertise your Business Here     
Browse  |   Placement Papers  |   Company  |   Code Snippets  |   Certifications  |   Visa Questions
Post Question  |   Post Answer  |   My Panel  |   Search  |   Articles  |   Topics  |   ERRORS new
   Refer this Site  Refer This Site to Your Friends  Site Map  Bookmark this Site  Set it as your HomePage  Contact Us     Login  |  Sign Up                      
info       Did you received any Funny E-Mails from your Friends and like to share with rest of our friends? Yeah!! you can post that stuff   HERE
Google
 
Categories  >>  Software  >>  Databases  >>  SQL Server
 
 


 

 
 Oracle interview questions  Oracle Interview Questions
 SQL Server interview questions  SQL Server Interview Questions
 MS Access interview questions  MS Access Interview Questions
 MySQL interview questions  MySQL Interview Questions
 Postgre interview questions  Postgre Interview Questions
 Sybase interview questions  Sybase Interview Questions
 DB Architecture interview questions  DB Architecture Interview Questions
 DB Administration interview questions  DB Administration Interview Questions
 DB Development interview questions  DB Development Interview Questions
 SQL PLSQL interview questions  SQL PLSQL Interview Questions
 Databases AllOther interview questions  Databases AllOther Interview Questions
Question
Please tell me some knowledge about Clustering and how to 
add clustering?
 Question Submitted By :: Vamsimadineni
I also faced this Question!!     Rank Answer Posted By  
 
  Re: Please tell me some knowledge about Clustering and how to add clustering?
Answer
# 1
clustering is the consupt of high availability where min of
2 servers participate. here the data and the log files are
stored on network storage called to be as nas or san. there
will be a dedicated link between the servers participating
in clustering where the secondary server will be pinging the
primary server to check the heart beet of the primary.
  the disks used for storing the resources are called to be
as Quorum disks. 
   there is a necessity of aver all 5 IP addresses for the
cluster. out of five IP addresses one is called to be as
cluster address and the clients connect to the
cluster/database through this address.
   again there are two types of cluster
1. Active/Active cluster
2. Active/Passive cluster.  u can see more details of this
on the net

when we come to active/passive cluster the secondary node
continuously check the heart beet of the primary node. if
the heart beet stops it assumes that the primary server is
down andd this passive node immediately comes online and
accepts the user connections which in turn is a high
availability solution.

By using the cluster in the organization the database might
be online in most of the cases except that the nas or both
the servers are down.
 
Is This Answer Correct ?    2 Yes 0 No
Balakrishna
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
What is the appropriate number of test cases that you can write on a database? Microsoft1
There is a trigger defined for INSERT operations on a table, in an OLTP system. The trigger is written to instantiate a COM object and pass the newly insterted rows to it for some custom processing. What do you think of this implementation? Can this be implemented better? HCL1
What is Files and Filegroups in SQL Server & it's implementation. Zenith1
what is the maximum size of a row in sql server 2000 and 2005  2
how many type of subquery?  2
Display a roll having miminum marks in two subjects? Patni7
What is referential integrity? What are the advantages of it? Digital-Domain3
Explain some DBCC commands?  4
Can you explain the role of each service?  1
What is MSDE?  2
Define candidate key, alternate key, composite key.  9
How To Make password Protected SQL Server 2005 Database i.e when i open SQL Server database then ask for password.  1
what is a cursor and what is its use?  1
how to get the maximum among two tables,for example table 1 (dep1) have (emp_id,emp_name,salary) columns and table 2 (dept2) have (emp_id,emp_name,salary) columns,i want which employee have the maximum salary among two tables? Lason2
i have a table #temp1(id, Name groupname ) and record like this 1 R1 S 2 R3 S 3 R2 S 4 R4 D 5 R5 D 6 R6 K 7 R7 K 8 R8 L 9 R9 L 10 R10 L 11 R11 K and i want to display record based on user defind sorting order e.g. 1 R4 D 2 R5 D 3 R6 K 4 R7 K 5 R11 K 6 R1 S 7 R3 S 8 R2 S 9 R8 L 10 R9 L 11 R10 L  4
wt is mean by acid property? i know it is atomocity,consistency,isolation and durabulaty but wt is these mean and wt actions it's perform Idea1
Which command using Query Analyzer will give you the version of SQL server and operating system?  3
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
The Difference between 'Count' and 'Count(*)'  12
can anyone explain me the concept of Serialization in Detail and Clear? plz its urgent i have interview on friday (15th feb)  1
 
For more SQL Server Interview Questions Click Here 
 
 
 
 
 
   
Copyright Policy  |  Terms of Service  |  Help  |  Site Map 1  |  Articles  |  Site Map  |   Site Map  |  Contact Us interview questions urls   External Links 
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

ALLInterview.com   ::  Forum9.com   ::  KalAajKal.com