Question

Which of the following is true about SQLite foreign keys?

a) A foreign key is a column or a set of columns that refer to the primary key of another table.

b) A foreign key can be used to enforce referential integrity between two tables.

c) SQLite supports foreign keys, but they are not enabled by default.

d) All of the above.

Answer 1

Answer: d) All of the above.

Explanation: A foreign key is a column or a set of columns that refers to the primary key of another table, and it can be used to enforce referential integrity between two tables. SQLite supports foreign keys, but they are not enabled by default. Foreign keys can be enabled using the PRAGMA foreign_keys command.