ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-11-19 09:58:55
Examine this SQL statement:FROM customersUNIONFROM customersIdentify three ORDER BY clauses, any one of which can complete the query successfully.B) ORDER BY "CUST_NO"D) ORDER BY CUST_NOAnswer：ACE071-140 题目：WHERE department_id=90 UNIONWHERE department_id.........【阅读全文】
发布时间：2019-11-19 09:16:19
Examine the data in the CUST NAME column of the CUSTOMERS table:------------------------------Jason MallinAllan MCEwenJulia NayerWhich two WHERE clauses give the required result?B) WHERE UPPER (SUBSTR(cust_nane, INSTR(cust_name, ' ') +1 ) ) LIKE UPPER('MC%')D) WHERE SUB.........【阅读全文】
发布时间：2019-11-18 15:01:27
Evalute these conmands which execate sucestullyINCREMENT BY 1MAXVALUE 100000CACHE 5000;A) Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.C) Sepuence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 timesE) Se.........【阅读全文】
发布时间：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.........【阅读全文】
