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 myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement

Question Posted / swapna

Answers were Sorted based on User's Feedback



Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the ..

Answer / swapna

Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.

Is This Answer Correct ?    3 Yes 0 No

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the ..

Answer / mobin sathupally

If we simple say CREATE INDEX then non clustered index will
be created.At the same time if we say CREATE NON CLUSTERED
INDEX then also non clustered index will be created.

Eg.
CREATE TABLE Emp(
eid INT
,ename VARCHAR(20))

CREATE INDEX in_emp_eid
ON Emp(eid)
By executing above code we create non clustered index.

Eg.
CREATE TABLE Emp(
eid INT
,ename VARCHAR(20))

CREATE NONCLUSTERED INDEX in_emp_eid
ON Emp(eid)

By using this code also we create non clustered index only.

Is This Answer Correct ?    3 Yes 0 No

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the ..

Answer / rams

Non-clustered index. Important thing to note: By default a
clustered index gets created on the primary key, unless
specified otherwise.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL Server Interview Questions

What are the difficulties faced in cube development? : sql server analysis services, ssas

0 Answers  

Can I remove the default constraint columns in SQL SERVER?

5 Answers   Value Labs,

What is self contained scalar sub query?

0 Answers  

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

0 Answers  

last function used in MS Access to convert sql what function will use in sql

0 Answers   Cap Gemini,

how do we insert 100 records at a time in a table without using for loop in database

1 Answers  

What does it mean to be in union?

0 Answers  

Why use update_statistics command in sql server?

0 Answers  

What is the Main Difference between ACCESS and SQL SERVER?

0 Answers   MindCracker,

What happens if strings are casted into wrong code pages in ms sql server?

0 Answers  

what is package and it uses and how can u call a package

0 Answers   Satyam,

What is cursors?

0 Answers   NA,

For more SQL Server Interview Questions Click Here
Categories