Multiple Choice
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';
Correct Answer:
Verified
Correct Answer:
Verified
Q47: A shared lock prevents another user from
Q48: A(n)_ lock will prevent any DDL operations
Q49: The <u>WHERE</u> clause of the UPDATE command
Q50: If the <u>SET</u> clause of the UPDATE
Q51: If non-numeric data is being added to
Q53: The <u>VALUES </u>clause of the UPDATE command
Q54: The data values being added to a
Q55: _ commands are used to modify data.
Q56: Contents of the PUBLISHER table<br> <img src="https://d2lvgg3v3hfg70.cloudfront.net/TB1929/.jpg"
Q57: Which keyword permanently saves changed data in