Chinaunix首页 | 论坛 | 博客
  • 博客访问: 146431
  • 博文数量: 260
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 2661
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59

Oracle dba培训、OCP、OCM、MYSAL认证,可以找我们,cuug专业做这些







发布时间: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.(解析:基本的考点。)......【阅读全文】

阅读(33) | 评论(0) | 转发(0)

发布时间: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.........【阅读全文】

阅读(32) | 评论(0) | 转发(0)

发布时间: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......【阅读全文】

阅读(20) | 评论(0) | 转发(0)

发布时间: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;------------.........【阅读全文】

阅读(29) | 评论(0) | 转发(0)

发布时间:2019-12-16 13:26:53

Exanine the desatption of the BOOKS_TRANSACTIONS table----------------------------------------------------------------------------------------------TRANSACTION_TYPE                    VARCHAR2(3)BOOK_ID         .........【阅读全文】

阅读(27) | 评论(0) | 转发(0)

登录 注册