create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 3885 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can a function call a stored procedure in sql server?
What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure? How many levels of sp nesting is possible?
What is the significance of master, tempdb and model databases?
How you can get a list of all the table constraints in a database?
What is sql injection? How to protect against sql injection attack?
How to execute the cursor queries with "open" statements?
Can the “if update (colname)” statement be used in a delete trigger?
What is report snapshot in ssrs?
What is intellisense?
how can you attach more than 20 ldf files in sql server
What is an indexing technique?
What is the bookmark lookup and rid lookup?
Is foreign key a primary key?
how to trace the traffic hitting a sql server? : Sql server database administration
What are the types of sql server?
