Question

Which of the following is true about SQLite primary keys?

a) A primary key is a column or a set of columns that uniquely identify each row in a table.

b) A primary key can be created using the PRIMARY KEY constraint.

c) A table can have multiple primary keys.

d) None of the above.

Answer 1

Answer: a) A primary key is a column or a set of columns that uniquely identify each row in a table.

Explanation: A primary key is a column or a set of columns that uniquely identify each row in a table. A primary key can be created using the PRIMARY KEY constraint. A table can have only one primary key, although a primary key can consist of multiple columns.