Create Index myIndex On myTable(myColumn)
What type of Index will get created after executing the
above statement
Answer Posted / 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 View All Answers
What are the triggers in sql?
List the different index configurations possible for a table?
What are types of storage modes? : sql server analysis services, ssas
What is table join?
What are the types of sql server?
What is de-normalization and what are some of the examples of it?
What are the new features introduced in SQL Server 2000? What changed between the previous version of SQL Server and the current version?
What is sql collation?
Explain the concepts and capabilities of sql server?
my name is sejal I have cleared the sbi clerk exam. I am BCA graduate My favorite subject RDBMS Relational database management system. so please send me rRDBMS related interview questions
Once setting replication, is it potential to own a publisher as sixty four bit sql server and distributor or subscribers as a thirty two bit sql server?
What is nonclustered index with included columns ?
What are the steps you should follow to start sql server in single-user mode?
How to get the definition of a trigger back?
What is molap and its advantage? : sql server analysis services, ssas