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 OPERATOR PERFORMS PATTERN MATCHING?

2 Answers   CarrizalSoft Technologies, CTS,

What is a join and their types?

2 Answers   Challenger Financial,

What is use of except clause? How does it differ from not in clause?

0 Answers  

if 3 duplicate records in a table,i want to delete 2 duplicate records by keeping 1 duplicate and 1 original as it is,how?

5 Answers  

how can you move the master database

1 Answers   IBM,

How to create new tables with "create table" statements in ms sql server?

0 Answers  

What is difference between delete and truncate commands?

0 Answers  

What method is used by the Command classes to execute SQL statements that return single values?

0 Answers   B-Ways TecnoSoft,

What are the different SQL Server Versions you have worked on?

0 Answers  

What is a rownum?

0 Answers  

Explain system views?

0 Answers  

Explain different types of lock modes in sql server 2000?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories