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

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







发布时间:2019-11-19 09:58:55

Examine this SQL statement:FROM customersUNIONFROM customersIdentify three ORDER BY clauses, any one of which can complete the query successfully.B) ORDER BY "CUST_NO"D) ORDER BY CUST_NOAnswer:ACE071-140 题目:WHERE department_id=90 UNIONWHERE department_id.........【阅读全文】

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

发布时间:2019-11-19 09:16:19

Examine the data in the CUST NAME column of the CUSTOMERS table:------------------------------Jason MallinAllan MCEwenJulia NayerWhich two WHERE clauses give the required result?B) WHERE UPPER (SUBSTR(cust_nane, INSTR(cust_name, ' ') +1 ) ) LIKE UPPER('MC%')D) WHERE SUB.........【阅读全文】

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

发布时间:2019-11-18 15:01:27

Evalute these conmands which execate sucestullyINCREMENT BY 1MAXVALUE 100000CACHE 5000;A) Any user inserting rows into table ORD_ITEMS must have been granted access to sequence ORD_SEQ.C) Sepuence ORD_SEQ cycles back to 1 after every 5000 numbers and can cycle 20 timesE) Se.........【阅读全文】

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

发布时间:2019-11-18 14:36:48

·MANAGER is an existing role with no privileges or roles.·EMPLOYEES is an existing table in the HR schema.A) GRANT CREATE SEQUENCE TO manager, emp;C) GRANT CREATE TABLE, emp TO manager;E) GRANT CREATE ANY SESSION, CREATE ANY TABLE TO manager;(解析:DAnswer::不能同时授权.........【阅读全文】

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

发布时间:2019-11-14 14:27:26

The ORDERS table has a column ORDER_DATE of date type DATEWhich two WHERE conditions demonstrate the correct usage of conversion functions?B) WHERE TO_CHAR(order_date, 'MON DD YYYY') = 'JAN 20 2019'D) WHERE order_date IN (TO_DATE ('Oct 21 2018', 'MON DD YYYY'), TO_CHAR('Nov 21 2018','M.........【阅读全文】

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

登录 注册