この不完全なクエリを調べてください。 SELECT DATA '2019-01-01' + <INTERVAL CLAUSE> デュアルから; <INTERVAL CLAUSE>を置き換えることができる3つの句はどれですか?日付に22時間を追加しますか?
正解:C,D,F
In Oracle SQL, adding hours to a date can be done using the INTERVAL keyword with appropriate clauses: Option C: INTERVAL '12' HOUR Adds exactly 12 hours to a date. Option D: INTERVAL '720' MINUTE Since 720 minutes equal 12 hours, this correctly adds 12 hours to a date. Option F: INTERVAL '11:60' HOUR TO MINUTE This interval represents 11 hours and 60 minutes, which effectively adds up to 12 hours. Options A, B, and E contain incorrect syntax or do not match the required addition of 22 hours as specified in the question.