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   interview questions urls   External Links  Contact Us     Login  |  Sign Up                      
Do you have a collection of Interview Questions and interested to share with us!!
Please send that collection to along with your userid / name. ThanQ
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 
1.What is the deferece between DBMS & RDBMS?
2.How can you trouble shoot? If u will get error while 
installing sql server?
3.How can u trouble shoot slow running query?
4.how can u trouble log shipping errors?
5.why do we use merge replication instead of T.log 
replication?
 Question Submitted By :: Laxman
I also faced this Question!!     Rank Answer Posted By  
 
  Re: 1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
Answer
# 1		 
1)DBMS Does Not Support Boyes'Coda 12 Rules
RDBMS Support 12 Rules of Boy's Coda
 
Is This Answer Correct ?    0 Yes 1 No
Dinesh Sharma
 
  Re: 1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
Answer
# 2		 
DBMS : Collection of data in Database
RDBMS : Collection of releated data in a database.

In Trancation Replication : Initial snapahot of the data is 
applied to at subscribers. and then when data modifications 
are made at the publisher , the individual transcation are 
captured and propogated to sbuscribers

In Merge replication : is the process of distributing data 
from publisher to subscriber, allowing the publisher and 
subscribers to make updates while connected or disconnected 
and then merging the updates between sites when they are 
connencted
 
Is This Answer Correct ?    1 Yes 0 No
Hari
 
 
 
  Re: 1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
Answer
# 3		 
2) ANS: Look into the setup log - sqlstp.log for errors.
 
Is This Answer Correct ?    0 Yes 0 No
Koti-khammam
 
  Re: 1.What is the deferece between DBMS & RDBMS? 2.How can you trouble shoot? If u will get error while installing sql server? 3.How can u trouble shoot slow running query? 4.how can u trouble log shipping errors? 5.why do we use merge replication instead of T.log replication?
Answer
# 4		 
3) ANS: There are a number of common reasons for slow-
running queries and updates:

Slow network communication.

Inadequate memory in the server computer, or not enough 
memory available for SQL Server.

Lack of useful statistics on indexed columns.

Out-of-date statistics on indexed columns.

Lack of useful indexes.

Lack of useful indexed views.

Lack of useful data striping.

Lack of useful partitioning.
 
Is This Answer Correct ?    0 Yes 0 No
Koti-khammam
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Difference between Cluster and Non-cluster index? Oracle6
How m-m relationships are implemented?  1
How to Execute an Operating System Command From Within SQL Server ?  2
About DTS usage ? Cognizent2
could u plz explain about joins and views?  2
How to retrieve duplicate rows in a table? How to delete the duplicate entries in a table? Leo-Technologies9
What are the types of indexes available with SQL Server?  2
What is a deadlock and what is a live lock? How will you go about resolving deadlocks?  1
How to delete particular value in the column of a table.Is it possible or not?if possible give it as in query.  3
wat will be the sql query to extract only last 3 records from table supose table hving thousands for records  13
how to find out the repeated value from table using groupby function?  3
Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.  1
How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?  1
Write an SQL query if u want to select the data from one block which intern reflects in another block ? thanx,do reply Covansys1
Lets say due to N/W or Security issues client is not able to connect to server or vice versa. How do you troubleshoot?  1
How do you fine the performance tunning? Accenture2
Alternative way to DetDate() function?  2
What is the purpose of using COLLATE in a query?  1
Using query analyzer, name 3 ways you can get an accurate count of the number of records in a table? eFunds4
What is bit datatype and what's the information that can be stored inside a bit column?  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
   
Copyright © 2007  ALLInterview.com.  All Rights Reserved.

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