Which statement is true about both Primary Key and Primary Index?
Which statement is true about both Primary Key and Primary Index?
Primary Key and Primary Index can both be made up of multiple columns. This is referred to as a composite key or composite index. Composite primary keys are used to uniquely identify records in a table using more than one column, and similarly, composite primary indexes are utilized to improve the efficiency of querying those composite primary keys.
D. They can be made up of multiple columns. Both primary keys and primary indexes can be made up of multiple columns, a concept known as a composite primary key or composite primary index. This is particularly useful for tables where a single column may not be able to uniquely identify each record.