Answer-first summary for fast verification
Answer: 7
The correct answer is C (7). Let's trace through the SQL operations: 1) CREATE TABLE test creates a table with columns c1 and c2. 2) INSERT INTO test adds rows: (1,1), (2,1), (3,1), (4,2). 3) UPDATE test SET c2 = c1 updates all c2 values to match c1: rows become (1,1), (2,2), (3,3), (4,4). 4) DELETE FROM test WHERE c1 = 1 removes the first row, leaving (2,2), (3,3), (4,4). 5) SELECT SUM(c2) FROM test sums the remaining c2 values: 2 + 3 + 4 = 7. The community discussion strongly supports this with 100% consensus on answer C and multiple comments confirming the step-by-step calculation. While one comment raises concerns about sequence ordering in general SQL contexts, this specific question doesn't involve sequences and the operations are straightforward.
Author: LeetQuiz Editorial Team
Ultimate access to all questions.
CREATE TABLE test (c1 NUMBER, c2 NUMBER);
INSERT INTO test (c1, c2) VALUES (1, 1), (2, 1), (3, 1), (4, 2);
UPDATE test SET c2 = c1;
DELETE FROM test WHERE c1 = 1;
SELECT SUM(c2) FROM test;
CREATE TABLE test (c1 NUMBER, c2 NUMBER);
INSERT INTO test (c1, c2) VALUES (1, 1), (2, 1), (3, 1), (4, 2);
UPDATE test SET c2 = c1;
DELETE FROM test WHERE c1 = 1;
SELECT SUM(c2) FROM test;
What is the result of the final SELECT SUM(c2) FROM test; statement?
A
3
B
4
C
7
D
8
