Which of the following is not a valid SQL command?
A) UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500';
B) UPDATE acctmanager SET amname = UPPER(amname);
C) UPDATE acctmanager SET amname = UPPER(amname)WHERE amid = 'J500';
D) UPDATE acctmanager WHERE amid = 'J500';

Question

Which of the following is not a valid SQL command?​
A) ​UPDATE acctmanager SET amedate = SYSDATE WHERE amid = 'J500';
B) ​UPDATE acctmanager SET amname = UPPER(amname);
C) ​UPDATE acctmanager SET amname = UPPER(amname)WHERE amid = 'J500';
D) ​UPDATE acctmanager WHERE amid = 'J500';

Quizplus · Accepted Answer

The UPDATE command requires the specification of which table to update, thus providing a WHERE clause without any SET clause is not a valid command.

Which of the Following Is Not a Valid SQL Command?​

Which of the Following Is Not a Valid SQL Command?