What is the answer?

Question

When inserting data into a table:

We don't have to insert values for all columns in the table

Names of the columns MUST always be mentioned in the insert statement

The number of columns in the insert statement and the number of columns of the table MUST be the same

Answer 1

Q: We don't have to insert values for all columns in the table
A: True, auto increment/identity column auto generates their value.

Q: Names of the columns MUST always be mentioned in the insert statement
A: Not necessarily, we can leave out fields we don't want to fill IF they have default value set, or they allow NULL.

Q: The number of columns in the insert statement and the number of columns of the table MUST be the same
A: Again, not necessarily, there's the auto-increment/identity field and also fields with defaults and nullable fields.

This was AFAIK, I may be wrong, and if I am please correct me 👍

Answer 2

It is a one question with three answers. What us the true answer?

Answer 3

It is choose one answer.

Answer 4

Thanks.

Answer 5

You mean it was multiple choice or choose one answer? if only one answer I'd say the first option is truthy (cmiiw)

Answer 6

You're welcome, glad if it helps 👍

Answer 7

Wifi at if we?