試題詳解

22.用以修改資料表 COURSE 之屬性 ROOM 值由 N107 改為 N301 之 SQL 陳述式為何？
(A) UPDATE COURSE SET ROOM = ‘N107’ WHERE ROOM = ‘N301’
(B) ALTER COURSE SET ROOM = ‘N301’ WHERE ROOM = ‘N107’
(C) UPDATE COURSE SET ROOM = ‘N301’ WHERE ROOM = ‘N107’
(D) CHANGE COURSE SET ROOM = ‘N301’ WHERE ROOM = ‘N107’