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                      
tip   SiteMap shows list of All Categories in this site.
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
create index a on employee(dno)

In this,which index was created?
 Question Submitted By :: Senthilsjc
I also faced this Question!!     Rank Answer Posted By  
 
  Re: create index a on employee(dno) In this,which index was created?
Answer
# 1
First the Control will check if there clustred index exist 
if there then it will create a nonclustred Index a on 
Employee(dno), other case there is condition diffine like 
clustred or nonclustred so it create Defualt type.
 
Is This Answer Correct ?    0 Yes 0 No
Yousaf Khan
 
  Re: create index a on employee(dno) In this,which index was created?
Answer
# 2
Noncluster index
 
Is This Answer Correct ?    0 Yes 0 No
Hari
 
 
 

 
 
 
Other SQL Server Interview Questions
 
  Question Asked @ Answers
 
How do you find the error, how can you know the number of rows effected by last SQL statement?  1
what is replication? where do u use Go Keyword? Satyam1
what are three different authentications to connect linked servers? CitiGroup1
1.what is stored procedure?Its significance with example? 2.Explain about index with syntax and example? plz do reply.........  1
Advantages and Disadvantages of Cursor? Zenith10
Can you explain the role of each service?  1
What types of integrity are enforced by a foreign-key constraint  1
What is an Index? Yardi-Software3
What is normalization and what are the different forms of normalizations?  1
What is ACID Property of Transaction?  4
why cluster and non clusterindex are used in sqlserver 2000? explain with example  1
How are SQL Server databases physically stored under Windows 2000?  1
How to find the last update record in SQL Server?  3
What is de-normalization and when do you do it?  3
What is the difference between 2-Tier architecture and 3-Tier architecture Oracle10
i want table name basis on column name.  5
Explain basic SQL queries with SELECT from where Order By, Group By-Having? Wipro2
how to find number of columns in a table in sql server 2000 and 2005 also Virtusa7
Is it possible to have more then one foreign key in a single table? if possible, is this the good way to design the table?  2
Wht is Stuff in sql ser  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