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

What does truncate do?

0 Answers  


What is the difference between having clause and where clause in sql server?

0 Answers  


How to get a list of columns in a view using the "sp_columns" stored procedure?

0 Answers  


What is the bookmark lookup and rid lookup?

0 Answers  


how can you move the master database

1 Answers   IBM,


How can sql server instances be hidden?

0 Answers  


What is a system database and what is a user database?

0 Answers  


Do you know the different ddl commands in sql?

0 Answers  


What is a Linked Server?

1 Answers  


Differentiate between delete and truncate.

0 Answers  


hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,


what's new in sql server 2016?

0 Answers  


Categories