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 can we rewrite sub-queries into simple select statements or with joins?

0 Answers  

How to find the version of sql server? : sql server database administration

0 Answers  

How to list all triggers in the database with sys.triggers in ms sql server?

0 Answers  

How to filter out duplications in the returning rows in ms sql server?

0 Answers  

How to find out what is the default collation in a database?

0 Answers  




Why we need sql server?

0 Answers  

Why do we need normalization?

0 Answers  

What is log shipping? Can we do logshipping with SQL Server 7.0 ?

0 Answers   IBM,

how to copy only distinct data into another table which is not already exist in database?

2 Answers   Spectra,

What is co-related sub query?

0 Answers  

What is the use of for clause?

0 Answers  

What is tabulation?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories