ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-11-18 14:36:48
·MANAGER is an existing role with no privileges or roles.·EMPLOYEES is an existing table in the HR schema.A) GRANT CREATE SEQUENCE TO manager, emp;C) GRANT CREATE TABLE, emp TO manager;E) GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;(解析：DAnswer：：不能同时授权.........【阅读全文】
发布时间：2019-11-14 14:27:26
The ORDERS table has a column ORDER_DATE of date type DATEWhich two WHERE conditions demonstrate the correct usage of conversion functions?B) WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'D) WHERE order_date IN (TO_DATE ('Oct 21 2018', 'MON DD YYYY'), TO_CHAR('Nov 21 2018','M.........【阅读全文】
发布时间：2019-11-14 13:26:48
Which two statements are true about the DUAL table?B) It can be accessed only by the SYS user.D) It can display multiple rows but only a single column.F) It can be used to display only constants or pseudo columns.(解析：dual 这个虚拟的表可以显示多行多列;任何用户都可以访问它。这道题.........【阅读全文】
发布时间：2019-11-11 10:57:48
Which three actions can you perfom only with system privileges?B) Access flat files via a database, which are stored in an operating system directory.D) Query any table in a database.F) Execute a procedure in another schema.(解析：这道题考的就是可以授权哪些系统权限去做哪些活儿。.........【阅读全文】
发布时间：2019-11-11 10:10:01
Which three statements are true about defining relations between tables in a relatonal database?B) Unique key columns allow null valuesD) Every primary or unique key value must refer to a matching foreign key value.Answer：ABE......【阅读全文】
