If there is primary key in table clustered index created by default ,othe

When do you create cluster and noncluster index?

Question Posted / naren

Answer Posted / naren

If there is primary key in table clustered index created by
default ,other wise non cluster index created .

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

How to see existing views in ms sql server?

987

Mention the differences between local and global temporary tables.

952

How to execute a sql statement using mssql_query()?

977

Write a query to find 5th highest amount paid from the customer table.

879

Tell me what is fill factor?

907

Write a SQL query in order to merge two different columns into single column?

989

How retrieve field names from the table in SQL through JAVA code?

1832

Explain system functions or built-in functions? What are different types of system functions?

915

What language is sql server written in?

985

How to call stored procedure using http soap?

998

How important do you consider cursors or while loops for a transactional database?

908

What is the sql server 2000 version number?

1008

Tell me the phases a transaction has to undergo?

917

What are views used for?

967

Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?

885