Interested to Buy Any Domain ? << Click Here >> for more details...
create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 4785 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
What is public role in sql server?
Can a rule be bound to any column of any data type?
explain databases and sql server databases architecture? : Sql server database administration
What is the sql server agent?
Explain what are the different index configurations a table can have?
What is the sql case statement used for?
What is the data tier application?
What are the advantages of log shipping?
Do you know 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?
How to select all columns of all rows from a table with a select statement in ms sql server?
Explain transaction server explicit transaction?
When to use Inner join & when to use subquery?
What is raid and what are different types of raid levels?
What is dbcc?
What is sql server used for?
