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

create index a on employee(dno)

In this,which index was created?

Question Posted / senthilsjc

Answers were Sorted based on User's Feedback



create index a on employee(dno) In this,which index was created?..

Answer / yousaf khan

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 ?    1 Yes 0 No

create index a on employee(dno) In this,which index was created?..

Answer / hari

Noncluster index

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

As a part of your job, what are the DBCC commands that you commonly use for database maintenance?

1 Answers   HCL,

what are database files and filegroups? : Sql server database administration

0 Answers  

How many triggers are possible per table?

0 Answers  

What is difference between count (*) and count 1?

0 Answers  

System variable and temporary variables

0 Answers   Wipro,

What is the difference between insensitive and scroll cursor?

0 Answers  

Write an sql query to find first weekday of the month?

0 Answers  

can any one post me, how to remove rows in the below table ENO ENAME EDEPT ELOC 3368 BPS BI Adayar 3371 RAN BI valachari 3369 SRI BI valachari 3372 jay BI Chn - - - - - - - -

2 Answers  

What is the recommended total size of your memory optimized tables?

0 Answers  

How many index can be created for single table

4 Answers   CarrizalSoft Technologies, Verizon,

How do I create a partition table in sql server?

0 Answers  

What is tempdb in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories