When a DBMS creates a(n)____ key,it is usually an automatic numbering data type,such as the Access AutoNumber data type.
A) surrogate
B) artificial
C) natural
D) logical

Question

When a DBMS creates a(n)____ key,it is usually an automatic numbering data type,such as the Access AutoNumber data type.​
A) ​surrogate
B) ​artificial
C) ​natural
D) ​logical

Quizplus · Accepted Answer

A surrogate key is an artificial primary key that is usually an automatic numbering data type generated by the DBMS. It is used to uniquely identify each row in a table and avoid using natural keys that may change. Therefore, A) is the best choice for the fill-in-the-blank statement.

When a DBMS Creates A(n)____ Key,it Is Usually an Automatic