Question

The SQL statements given below are executed in the order shown:
CREATE table Demo (A varchar (10), B varchar (10));
INSERI into Demo values (101,567);
UPDATE Demo Set B = 'NULL';
What will be the result of the statement given below, if executed after the above statements?
SELECT * from Demo;
>
AB
101 NULL
A B
0 567
AB​

Answer 1

Answer:

A. B

101. NULL

Explanation:

THE CREATION OF THE TABLE IS DONE USING COLUMN NAMES A AND B IN THE FIRST STATEMENT

IN THE SECOND VALUES ARE BEEN ADDED TO BOTH COLUMNS.. 101 AND 567

IN THE NEXT QUERY THE VALUE IN B COLUMN IS SET AS NULL SO THE ANSWER IS GIVEN ABOVE

Answer 2

Answer:

A B

101 NULL

Explanation:

it is correct answer okokok