ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-11-25 10:17:30
Which three statements are true about sequences in a single instance Orade database?B) Two or more tables cannot have keys generated from the same sequence.D) A sequence can issue duplicate values.F) A sequence can only be dropped by a DBA.(解析：虚拟可以一下子产生一组的数字缓存在.........【阅读全文】
发布时间：2019-11-25 09:40:24
Which two statenents are tue about the COUNT function?B) COUNT (DISTINCT inv_amt) returns the number of rows excluding rows containing dupicates and NULLs in the INV_AMT columnD) A SELECT statement using the COUNT function with a DISTINCT keyword cannot have a WHERE clause.Answer：：BC.........【阅读全文】
发布时间：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.........【阅读全文】
