1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

create index a on employee(dno)

In this,which index was created?

Question Posted / senthilsjc

Answers were Sorted based on User's Feedback



create index a on employee(dno) In this,which index was created?..

Answer / yousaf khan

First the Control will check if there clustred index exist
if there then it will create a nonclustred Index a on
Employee(dno), other case there is condition diffine like
clustred or nonclustred so it create Defualt type.

Is This Answer Correct ?    1 Yes 0 No

create index a on employee(dno) In this,which index was created?..

Answer / hari

Noncluster index

Is This Answer Correct ?    2 Yes 1 No

Post New Answer

More SQL Server Interview Questions

How to store pdf file in sql server?

1 Answers   CarrizalSoft Technologies, College School Exams Tests, TATA,

what is the information that can be stored inside a bit column? : Sql server database administration

0 Answers  

What are the types of resultset?

0 Answers  

How to create stored procedures with parameters in ms sql server?

0 Answers  

What is normalization of database?

0 Answers  




What is difference between after and before?

0 Answers  

when inserting to a table how many rows will be effected using triggers

2 Answers  

How many cores do I need for sql server 2016?

0 Answers  

What is msdb database? : SQL Server Architecture

0 Answers  

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

What is the new security features added in sql server 2014? : sql server security

0 Answers  

Can you change the data type of a column in a table after the table has been created? If so, which command would you use?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories