ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-12-18 13:40:49
You execute this command:Which two are true?B) It retains the indexes defined on the table.D) A ROLLBACR statement can be used to retrieve the deleted data.F) A FLASHBACK TABLE statement can be used to retrieve the deleted data.(解析：基本的考点。)......【阅读全文】
发布时间：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 .........【阅读全文】
