Question 3Asked in DSSSB TGT Computer Science (Technical), 12 Sep 2025, Shift 2 (1:00 PM)

___________ is an invalid statement in standard SQL:1999.

ADELETE FROM Customer WHERE 1=1;
BUPDATE Customer SET Bill = Bill - 5000 WHERE Account = 'High privilege';
CINSERT INTO Employees VALUES (DEFAULT, 'John', 'IT');
DINSERT Employees VALUES ('John', DEFAULT, 'IT');

Show answerHide answer

Correct answer: (D) INSERT Employees VALUES ('John', DEFAULT, 'IT');

Explanation

Standard SQL requires the keyword INTO in an INSERT statement: INSERT INTO table VALUES (...). Omitting INTO is only accepted by some vendors such as MySQL or SQL Server, so D is invalid in standard SQL.

___________ is an invalid statement in standard SQL:1999.

From DSSSB TGT Computer Science PYQ (Technical), 12 Sep 2025, Shift 2 (1:00 PM)