PrepAway - Latest Free Exam Questions & Answers

What will be the result of the following statement?

If the following SQL statements are executed in the order shown:
CREATE TABLE table1 (c1 INTEGER, c2 INTEGER);
INSERT INTO table1 VALUES (123, 456);
UPDATE table1 SET c1 = NULL;
What will be the result of the following statement?
SELECT * FROM table1;

PrepAway - Latest Free Exam Questions & Answers

A.
C1 C2
— —
123 456
1 record(s) selected.

B.
C1 C2
— —
NULL 456
1 record(s) selected.

C.
C1 C2
— —
– 456
1 record(s) selected.

D.
C1 C2
— —
0 456
1 record(s) selected.

One Comment on “What will be the result of the following statement?


Leave a Reply