ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-11-20 09:59:00
Which two statements are true about the results of using the INTERSECT operator in compound queres?B) Column names in each SELECT in the compound query can be dfferent.D) The number of columns in each SELECT in the compound query can be dfferent.Answer：：BC......【阅读全文】
发布时间：2019-11-20 09:27:05
Which three statements are true about a self join?B) It can be an outer join.D) It must be an equijoin.F) The ON clause can be used.(解析：左连接其实就是左外连接，是不同的称呼而已，其结果都是一样的，ANSI 语法有select emp.empno,emp.deptno,dept.deptno,dept.dnameselect emp.emp.........【阅读全文】
发布时间：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.........【阅读全文】
