COMPUTER APPLICATIONS
DATABASE MANAGEMENT SYSTEMS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which field in a database table is an automatic field?
|
|
ID
|
|
|
Name
|
|
|
Address
|
|
|
Date of Birth
|
Explanation:
Detailed explanation-1: -Autonumbers will automatically default to 4 digits (0001, 0002, etc.) Bonus: If you want the AutoNumber to include specific text, include that text in the format field. For example, a format of “GA-"0000 will generate AutoNumbers like GA-0001, GA-0002, etc. About the author.
Detailed explanation-2: -Auto Increment is a field used to generate a unique number for every new record added into a table. This is generally used for the primary key column as it becomes easy for the developers to automatically generate a unique number for every new record.
There is 1 question to complete.