試題詳解

複選題
42.您需要在Student資料表中插入兩位新學生。第一位學生命名為Peter，學號為1130701。第二位學生命名為Claire，學號為1130702。您應 該使用下列哪一個SQL陳述式？
(A)INSERT 1130701, 1130702, 'Peter', 'Claire' INTO Student
(B)INSERT NEW ID = 1130701 AND 1130702, Name = 'Peter' AND 'Claire' INTO Student
(C)INSERT INTO Student VALUES (ID = 1130701, 1130702) (Name = 'Peter', 'Claire' )
(D)INSERT INTO Product (ID, Name) VALUES (1130701, 'Peter') INSERT INTO Product (ID, Name) VALUES (1130702, 'Claire')