ocp考试资料群：569933648 验证码：ocp ocp 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（485）
- postgresql（54）
- ocp 12c（175）
- ocp（102）
- 未分配的博文（154）
发布时间：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 .........【阅读全文】