Oracle 19c OCP 082认证考试题库(第7题)- 2024年修正版
【优技教育】Oracle 19c OCP 082题库(第7题)- 2024年修正版考试科目：1Z0-082考试题量：90通过分数：60%考试时间：150min本文为(CUUG 原创)整理并解析，转发请注明出处，禁止抄袭及未经注明出处的转载。原文地址：https://www.cuug.com.cn/ocp/082kao**iku/38159072308.html第7题：7、Choose two.Examine these statements which execute successfully: CREATE USER finance IDENTIFIED BY pwfin; CREATE USER fin_manager IDENTIFIED BY pwmgr; CREATE USER fin_clerk IDENTIFIED BY pwclerk; GRANT CREATE SESSION TO finance, fin_clerk; GRANT SELECT ON scott.emp TO finance WITH GRANT OPTION; CONNECT finance/pwfin GRANT SELECT ON scott.emp TO fin_clerk;Which two are true?A) Dropping user FINANCE will automatically revoke SELECT on SCOTT.EMP from user FIN_CLERK.B) Revoking SELECT on SCOTT.EMP from user FINANCE will also revoke the privilege from user FIN_CLERK.C) User FINANCE is unable to grant ALL on SCOTT.EMP to FIN_MANAGER.D) User FIN_CLERK can grant SELECT on SCOTT.EMP to user FIN_MANAGER.E) User FINANCE can grant CREATE SESSION to user FIN_MANAGER.Answer：AB(解析：由于对象权限有级联关系，所以上层没了，下层也随即没有。经过实验发现 C 答案是错的，比较出乎意料。)Oracle 19c OCP认证需要到Oracle指定的WDP机构，有了培训记录之后才能考试，考试需要考2科，分别是082(60%及格)和083(57%及格)，两科都通过之后才能拿到证书。证书如下：http://www.cuug.com.cn/uploadfile/2024-02/36533685624.jpg
CUUG是甲骨文的金牌WDP合作机构，30多年品牌，培养了数万名数据库人才。想快速通过19c OCP考试的同学可以扫码联系老师咨询。http://www.cuug.com.cn/uploadfile/2024-05/37321631940.jpg
页:
[1]