OCP 071中文考试题库(cuug内部资料)第19题
OCP 071中文考试题库(cuug内部资料)第19题本套题库是OCP考试中的071(中文版)试题，由CUUG整理，如有报考OCP认证意向，可以联系cuug咨询老师。19、请选择两项。查看BRICKS表中的数据:SHAPE WEIGHT-------- ------cube 5cuboid 10cylinder 15查看BOXES表:BOX_SIZE MIN_WEIGHT MAX_WEIGHT---------------- -------------- ---------------SMALL 0 10哪两个查询仅返回CUBE?A) SELECT shapeFROM bricksJOIN boxesON weight > min_weight;B) SELECT shapeFROM bricksJOIN boxesON weight >= min_weightAND weight < max_weight;C) SELECT shapeFROM bricksJOIN boxesON weight BETWEEN min_weight AND max_weight;D) SELECT shapeFROM bricksJOIN boxesON weight < max_weight;E) SELECT shapeFROM bricksJOIN boxesON NOT (weight > max_weight) ;http://www.cuug.com.cn/uploadfile/2021-02/26995463018.jpg
页:
[1]