ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-12-17 10:39:30
Examine this SQL statement:WHERE EXISTSFROM emp_historyWhich two are true?B) The subquery is not a correlated subquery.D) All existing rows in the EMPLOYEEE table are deleted.Answer：：AE关联子查询：2、 然后子查询返回的结果又传给主查询)create table emp2 as s.........【阅读全文】
发布时间：2019-12-17 09:58:46
The ORDERS table has a primary key constraint on the ORDER_ID column.The constraint is defined with on DELETE CASCADE.Which three DELETE statements execute successfully?B) DELETE * FROM orders WHERE order_total<1000;D) DELETE FROM orders;Answer：ACD......【阅读全文】
发布时间：2019-12-16 15:04:35
Which two statements are true about single row functions?B) MOD : returns the quotient of a division operationD) FLOOR : returns the smallest integer greater than or equal to a specified numberAnswer：：CEceil 函数向上取整数。SQL> select ceil(-500.1) from dual;------------.........【阅读全文】
发布时间：2019-12-16 13:26:53
Exanine the desatption of the BOOKS_TRANSACTIONS table----------------------------------------------------------------------------------------------TRANSACTION_TYPE VARCHAR2(3)BOOK_ID .........【阅读全文】
发布时间：2019-11-27 09:44:09
Examine the description of the PRODUCT_INFORMATION table:------------------------------------------------------------------------PROD_NANE VARCRAR2 (10)Which query retrieves the number of products with a null list price?B) SELECT Count(nvl( l.........【阅读全文】
