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 
We create an index to fast the search. How it fast the 
query? Do we write any special keyword with query?
 Question Submitted By :: Vinod
I also faced this Question!!     Rank Answer Posted By  
 
  Re: We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
Answer
# 1		 
In the case search is the query. How would you search in 
the database? I think you will use sql query.
 
Is This Answer Correct ?    0 Yes 1 No
Nixo
 
  Re: We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
Answer
# 2		 
It is depend on which type of indexing u r using .
clustered or non clustered.

if u r searching one record then used nonclustered indexing.
if u r searching bulk of record then used clustered indexing
 
Is This Answer Correct ?    1 Yes 0 No
Ish
 
 
 
  Re: We create an index to fast the search. How it fast the query? Do we write any special keyword with query?
Answer
# 3		 
we need to use indexed column in where clause
 
Is This Answer Correct ?    1 Yes 0 No
Laxman
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
Suppose in a situation if two list boxes are there and if you select multiple options based on that the options related to those selected items should display in second list box. Again if we select multiple items in second listbox then the related to those selected items should display . In this scenario how will you design database,tables? HP1
What is the difference between Drop and Truncate  10
What is blocking and how would you troubleshoot it?  1
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa7
Which TCP/IP port does SQL Server run on?  2
What are the different types of replication? How are they used?  3
What is the difference between truncate and delete statement? CTS4
Can we rewrite subqueries into simple select statements or with joins? Example? ASD1
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
I have a huge amount of data which is displayed in a report. The data is viewed every day. Every day the data is displayed in 30 secs but suddenly today it is giving an timeout message today. Data has not been changed. The situation is same as yesterday. What might be the reason??? Please Answer. Satyam4
How do you check the performance of a query and how do you optimize it?  1
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS? GE1
What is SQL Profiler what is the use of it? 247Customer2
What is the difference between constraints and triggers? Wipro6
Which databases are part of SQL server default installation? Explain the usage of each? Accenture2
How To Change Column Ordinal Position in SQL Server 2005 using Query i.e I Want To Add Column at Particular Ordinal Position in SQL Server 2005  2
Please tell me some knowledge about Clustering and how to add clustering?  1
hi, may i know what is the command to get abstract the current month, current year and current day from a given date.i want these three in a isolated way..seperatedly is that any way in sql server 2000  3
How to delete an attribute from the emp table  3
why cluster and non clusterindex are used in sqlserver 2000? explain with example  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