Which of the following is used to specify an alternate key?
A. Composite Key
B. Unique Key
C. Foreign Key
D. Primary Key
Answer (2)
An alternate key in database management is a set of attributes that can uniquely identify a record, and the option used for this is the Unique Key . While it ensures distinct records like a primary key, it can accept null values. Understanding different key types, such as composite and foreign keys, is essential for efficient database management. ;
The alternate key is specified using a Unique Key, which ensures distinct values in a column and can allow for null values. It is distinct from a primary key which cannot accept null values. Therefore, the correct answer is option B: Unique Key.
;
