Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

Which index created when Create Index on table(col), Why

Question Posted / guest

Answers were Sorted based on User's Feedback



Which index created when Create Index on table(col), Why..

Answer / indexes

Non Clustered Index by Default.

Is This Answer Correct ?    15 Yes 0 No

Which index created when Create Index on table(col), Why..

Answer / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What is the difference between count () and rowcount ()?

0 Answers  

What is data mart? : sql server analysis services, ssas

0 Answers  

What are different types of join?

0 Answers  

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

If a user does not have permission to a table, but has permission to a view created on it, will he be able to view the data in table?

0 Answers  

what is the difference between group and having give an example with query and sample output

7 Answers  

What are the kinds of subquery?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

what is the Surrogate key?and wt is the diff between Primary key and Surrogate Key?

2 Answers  

Following are some of the question related to below mentioned query? select e1.salary from employee3 e1 where 2= ( select count(distinct(e2.salary)) from employee3 e2 where e2.salary>=e1.salary ) 1) What the query returns? 2) How it works? - Detail explanation (what the sub query does, why it is (where 2=)....etc...Please?

5 Answers  

How to execute multiple stored procedures at one time in sql server?

0 Answers  

What is update_statistics command?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories