Question

What will be the output of following query?
INSERT INTO student
VALUES (“Suhana”,109,’F’),
VALUES (“Rivaan”,102,’M’),
VALUES (“Atharv”,103,’M’),
VALUES (“Rishika”,105,’F’),
VALUES (“Garvit”,104,’M’),
VALUES (“Shaurya”,109,’M’);
(1 Point)
(a) Error
(b) No Error
(c) Depends on compiler
(d) Successful completion of the query​

Answer 1

Answer:

(a) Error

Explanation:

INSERT INTO  statements inserts the values once at a time in SQL.

Answer 2

The correct answer is option (a) Error.

Explanation:

• The output of following query will be Error.
• INSERT INTO statements only inserts the values once at a time in SQL.
• To fix this error you can use various auditing tools.
• A good auditing tool to identify any rows with errors even if you don't fix the errors is a Power Query.
• To remove rows which contains errors in Power Query, first select the column that contains errors.
• Then, on the Home tab, in the Reduce rows group, choose Keep rows.