Answer / anand k

One table can only one clustered index or primary key and
249 non-clustered index or unique key

Answer / raji

Indexes may be defined as unique or non-unique. A unique
index acts as a constraint on the table by preventing
identical rows in the index and thus, the original columns.

Answer / namz

There can only be one clustered index but multiple non-
clustered index

Answer / koti

250 indexes(1 cluster index,249 non-cluster indexes)

Answer / c.jagadish

In sqlserver we have two types of indexes (1) Clustered (2)
non clustered indexes.

Indexes may be simple index or composite index.

Index formed based on single column values is called simple
index

index formed based on multiple column values is called
composite index.

Default index is NON CLUSTERED INDEX

When a table contains a primary key column then sqlserver
automatically creates a unique clustered index.

Unique--- automatically creates a non clustered index

so for this reason PRIMARY KEY IS NOT EQUAL TO UNIQUE + NOT
NULL.

Answer / saravanan

four index keys is possible per one table.
read only table u havae create more then index per table

What is inner join? Explain with an example?

0 Answers  

What number sorts of privileges are accessible in sql?

0 Answers  

Do you know what are the restrictions that views have to follow?

0 Answers  

What is bulkcopy in sql?

0 Answers  

Is truncate a dml command?

0 Answers  

How to use values from other tables in update statements in ms sql server?

0 Answers  

Explain the categories of stored procedure?

0 Answers  

Do you know the isolation level that sql server support?

0 Answers  

1.Describe way(s) to tune the SQL table in order to optimize performance. 2. Explain SQL Injection and how can you prevent them?

1 Answers   Techno Solutions,

Can we add an identity column to decimal datatype?

0 Answers  

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

What do you mean by a dependent functionality in a build?

0 Answers   HCL,