Primary key should always be auto increment

Options
- true
- false


CORRECT ANSWER : false

Discussion Board
Primary key

The above statement is true. Primary key should always be auto increment. Auto-incrementing primary keys are useful for following reasons:
1. They do not allow duplicate user names.
2. They allow the user name (or email address, if that's used to login) to be changed (easily).
3. Selects, joins and inserts are faster than Varchar primary keys, as it's much faster to maintain a numeric index.
4. Validation becomes very simple.
5. Sanitation of input is trivial.
6. There is far less overhead as foreign keys don't have to duplicate potentially large string values.

Prajakta Pandit 03-14-2017 01:50 AM

Database

Primary Key like CustomerId should be updated automatically..So auto-increment is necessary for Primary Key.

Pritam Saha 10-13-2014 05:00 AM

Write your comments

 
   
 
 

Enter the code shown above:
 
(Note: If you cannot read the numbers in the above image, reload the page to generate a new one.)


Advertisement