Interested to Buy Any Domain ? << Click Here >> for more details...
create index a on employee(dno)
In this,which index was created?
- 2 Answers
- 4746 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 does ss stand for sexually?
You want to use bids to deploy a report to a different server than the one you chose in the report wizard. How can you change the server url?
Explain what is analysis service repository?
How to deploy the Report?
What is Replication?
Is it possible for a stored procedure to call itself or recursive stored procedure?
List some major differences between triggers and stored procedures?
What are the different authentication modes in sql server? How can it be changed?
What is page-level compression?
Do you know what are acid properties?
Write a code to select distinct records without using the DISTINCT keyword.
Explain syntax for viewing, dropping and disabling triggers?
What are the different types of backups avaialabe in sql server 2005?
What is self contained multi valued query?
When you use @@error and try-catch?
