How many index keys possible for a table

Answer Posted / 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.

Is This Answer Correct ?    9 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the steps you should follow to start sql server in single-user mode?

478


What is difference between index seek vs. Index scan?

616


What is a trace frag? Where do we use it?

669


Can we install sql server 2016 on windows 7?

664


What are the new features in sql server 2016?

534






What is the New in SQL server 2008?

573


What are the advantages to use stored procedures?

564


What is difference between unique and primary key?

475


What is difference between inner join and full join?

544


Is it important for a database administrator to understand the operating system and file access?

504


What is sql server management studio? : sql server management studio

578


What are orphan records?

545


Tell me what are the advantages of using stored procedures?

566


How many levels of sp nesting is possible?

580


What are the properties of the transaction?

539