【优技教育】Oracle 19c OCP 082题库(Q 18题)- 2024年修正版 考试科目:1Z0-082 考试题量:90 通过分数:60% 考试时间:150min 本文为(CUUG 原创)整理并解析,转发请注明出处,禁止抄袭及未经注明出处的转载。 第18题: Q 18、 Choose the best answer. Examine the description of the EMPLOYEES table: Name Null? Type ------------------------------------------------------------- EMPLOYEE_ID NOT NULL NUMBER(4) EMPLOYEE_NAME NOT NULL VARCHAR2 (100) SALARY NOT NULL NUMBER(6,2) . DEPARTMENT_ID NOT NULL NUMBER(4) Which statement will fail? A) SELECT department_id, COUNT(*) FROM employees WHERE department_id <> 90 HAVING COUNT(*) >= 3 GROUP BY department_id; B) SELECT department_id, COUNT (*) FROM employees WHERE department_id <> 90 AND COUNT(*) >= 3 GROUP BY department_id; C) SELECT department_id, COUNT (*) FROM employees WHERE department_id < 90 GROUP BY department_id HAVING COUNT(*) >= 3; D) SELECT department_id, COUNT (*) FROM employees HAVING department_id < 90 AND COUNT(*) >= 3 GROUP BY department_id; Answer:B (解析:D 答案是出人意料可以执行成功,原因是 having 放在了前面,它是 having 语句中的 and 条件,所以允许用到分组函数。)
Oracle 19c OCP认证需要到Oracle指定的WDP机构,有了培训记录之后才能考试,考试需要考2科,分别是082(60%及格)和083(57%及格),两科都通过之后才能拿到证书。证书如下:
CUUG是甲骨文的金牌WDP合作机构,30多年品牌,培养了数万名数据库人才。想快速通过19c OCP考试的同学可以扫码联系老师咨询。
|