在Oracle中有表”cd”，它包含属性”cdcode”，”category”和”cdname”，要查询category取值为”

在Oracle中有表”cd”，它包含属性”cdcode”，”category”和”cdname”，要查询category取值为”CLASSIC”或”ROCK”的行，应采用语句

A.SELECT * FROM cd WHERE category IN (‘CLASEIC’,'ROCK’);

B.SELECT * FROM cd WHERE category BETWEEN ‘CLASSIC’ AND ‘ROCK’;

C.SELECT * FROM cd WHERE category=’CLASSIC’ AND category=’ROCK’;

D.SELECT * FROM cd WHERE category=’CLASSIC’ OR category=’ROCK’;

正确答案是AD