Which index created when Create Index on table(col), Why

Question Posted / guest

Answers were Sorted based on User's Feedback

Which index created when Create Index on table(col), Why..

Answer / indexes

Non Clustered Index by Default.

Is This Answer Correct ?

15 Yes

0 No

Which index created when Create Index on table(col), Why..

Answer / sanjay

whenever you create index without specifying the type, its
non-clustered.

Is This Answer Correct ?

5 Yes

0 No

More SQL Server Interview Questions

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

What are entities and relationships?

Describe the left outer join & right outer join. : sql server database administration

What is purpose of normalization?

List the different normalization forms?

How dts is used to extract, transform and consolidate data?

How do you troubleshoot errors in a SQL Server Agent Job?

Where the sql logs gets stored? : sql server database administration

How would you use user_constraints table in DB?

Can we install sql server 2016 on windows 7?

Is a null value equal to anything? Can a space in a column be considered a null value? Why or why not?

How do I open a .db file?

For more SQL Server Interview Questions Click Here