Assertion. The INSERT INTO statement can skip some columns' values. Reason. Only the columns allowing the NULL values or have default-value-defined, can be skipped in INSERT INTO statement of SQL. 1. Both A and R are true and R is the correct explanation of A. 2. Both A and R are true but R is not the correct explanation of A. 3. A is true but R is false. 4. A is false but R is true.

Class - 12 CBSE Computer Science — Assertion Reason Type Questions

Assertion. The INSERT INTO statement can skip some columns' values.
Reason. Only the columns allowing the NULL values or have default-value-defined, can be skipped in INSERT INTO statement of SQL.
Both A and R are true and R is the correct explanation of A.
Both A and R are true but R is not the correct explanation of A.
A is true but R is false.
A is false but R is true.

SQL Queries

3 Likes

Answer

Both A and R are true and R is the correct explanation of A.

Explanation
The INSERT INTO statement allows skipping columns values for columns that permit NULL values or have default values defined. If any other column (that does not have a default value and is defined as NOT NULL) is skipped or omitted, an error message is generated, and the row is not added.

Answered By

1 Like

All Questions