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

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

How to display n-1 columns from n number of columns, from a single table in MS SQL server 2005?

2 Answers  


What is plan freezing?

0 Answers  


What is inner join? Explain with an example?

0 Answers  


How do I clean up sql server transaction log?

0 Answers  


What is Pointer ?

3 Answers   Cap Gemini, CarrizalSoft Technologies,


Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?

0 Answers  


When do you use SQL Profiler?

3 Answers   Wipro,


What does it mean to normalize data?

0 Answers  


How to download microsoft sql server 2005 express edition?

0 Answers  


If you're given a raw data table, how would perform etl (extract, transform, load) with sql to obtain the data in a desired format?

0 Answers   Facebook,


What are the tool windows in sql server management studio? : sql server management studio

0 Answers  


What is sql injection? How to protect against sql injection attack?

0 Answers  


Categories