Can we create clustered index on non primary key column
- 20 Answers
- 51424 Views
- ABC, CTS, I also Faced
- E-Mail Answers
Answer Posted / vikas kant
Yes We can create clustered index on a non primary key
column by using the following syntax--:
create clustered index abc_index on Table1(student_class)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to include date and time values in sql statements?
1. Tell me your daily activities 2. If sql server installation fails at time installation what will do 3. Where does the sql server installation log details are stored 4. After the installation what will you do for memory configuration 5. What is the difference between SQL max maximum memory and AWE memory 6. How will you configure AWE memory 7. How will setup an email alert for the backup job 8. After the SQL installation what are the jobs will you configure 9. What does –g mean in the sql startup parameter 10. What is the difference between Bulked log and Full recovery model 11. What is the difference between mirroring and log shipping 12. What are the steps to be followed before in-place up gradation 13. After installing the patch the sql server does not start and application team tells to rollback the changes .In this scenario what will you do
What sql server means?
What is the order in which the sql query is executed?
What happens if date-only values are provided as date and time literals?
What are date and time data types in ms sql server?
How to delete a login name in ms sql server?
What are window functions in sql server?
State the difference between union and union all?
What is 2nf in normalization?
Define master database?
How to provide default values to function parameters?
how do you test proper tcp/ip configuration windows machine? : Sql server database administration
What protocol does sql server use?
What is meant by datasource?
