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

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








发布时间:2019-02-21 09:44:50

25. choose the best answerEvaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A) Any views created on the EMP table that include the MGR_ID column would be automatically modified and remain .........【阅读全文】

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

发布时间:2019-02-20 17:27:37

24. choose the best answerIn the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.Evaluate the following SQL statement:SQL> UPDATE employeesSET salary = NVL(salary,0) + NVL(comm,0),comm = NVL(comm,0)WHERE hire_date < SYSDATE - 600;.........【阅读全文】

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

发布时间:2019-02-20 16:14:50

23.choose the best answerView the Exhibits and examine PRODUCTS and SALES tables.You issue the following query to display product name and the number of times theproduct has been sold:SQL>SELECT p.prod_name, i.item_cntFROM (SELECT prod id, COUNT(*) item_cntFROM sales GROUP BY prod_.........【阅读全文】

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

发布时间:2019-02-20 15:31:30

Evaluate the following CREATE SEQUENCE statement:START WITH 100MAXVALUE 200NOCACHE;You issue the following SQL statement:What is displayed by the SELECT statement?B) 100D) 10Answer:B......【阅读全文】

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

发布时间:2019-02-20 13:53:12

View the Exhibit and examine the description of SALES and PROMOTIONS tables. A) DELETEWHERE promo_id = (SELECT promo_idWHERE promo_name = 'blowout sale')FROM promotions FROM salesFROM promotionsAND promo_id = (SELECT promo_idWHERE promo_name = 'eve.........【阅读全文】

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

登录 注册