Question

Defining a primary key is mandatory while creating a table.
a) True
b) False

Answer 1

It is not mandatory to define a primary key when creating a database table, but it is recommended for uniqueness and data integrity. Tables without primary keys, or 'heap tables,' can have performance and data integrity implications.

Step-by-step explanation:

The statement "Defining a primary key is mandatory while creating a table" is false. While it is highly recommended to define a primary key for each table to ensure each record can be uniquely identified, it is not a mandatory requirement in database systems. Tables without primary keys are known as 'heap tables' and can be useful in certain scenarios, although they come with trade-offs such as potential issues with data integrity and performance.