ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-10-25 14:13:42
Examine the description of the PRODUCTS table:-----------------------------------------------------------------PRODUCT_NANE VARCHAR2(10)PURCHARGE &nb.........【阅读全文】
发布时间：2019-10-23 15:34:54
Examine this SQL statement:SET customer_name =FROM customersWhich two are true?B) All existing rows in the ORDERS table are updated.D) The UPDATE statement executes successfully even if the subquery selects multiple rows.Answer：BD关联子查询：2、 然后子查询返回的结.........【阅读全文】
发布时间：2019-10-23 14:48:20
Examine this query:What is the result?B) 160D) 200Answer：D(解析：关键就是 round 函数，0 是小数点左边第一位，以此类推。)......【阅读全文】
发布时间：2019-10-21 11:39:52
Which three statements are true about dropping and unused columns in an Oracle database?B) A DROP COLUMN command can be rolled backD) An UNUSED column's space is redaimed automatially when the row containing that column is next queried.F) A column that is set to NNUSED still counts tow.........【阅读全文】
发布时间：2019-10-21 10:25:04
Which two statements are true about a self join?B) It can be a left outer join.D) It can be an inner join.Answer：BD不过在进行内连接时为了区别表的名字，需要加别名from emp2 won w.mgr=m.empno;)......【阅读全文】
