Chinaunix首页 | 论坛 | 博客
  • 博客访问: 579774
  • 博文数量: 487
  • 博客积分: 0
  • 博客等级: 民兵
  • 技术积分: 4916
  • 用 户 组: 普通用户
  • 注册时间: 2018-07-05 13:59
个人简介

ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291

文章分类

全部博文(487)

文章存档

2023年(37)

2021年(151)

2020年(37)

2019年(222)

2018年(38)

我的朋友

发布时间:2019-02-21 11:38:29

28.choose the best answerEvaluate the following SQL statement:SQL> SELECT promo_id, promo_categoryFROM promotionsWHERE promo_category = 'Internet' ORDER BY 2 DESCUNIONSELECT promo_id, promo_categoryFROM promotionsWHERE promo_category = 'TV'UNIONSELECT promo_id, promo_ca.........【阅读全文】

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

发布时间:2019-02-21 11:02:36

27.choose twoThe SQL statements executed in a user session are as follows:SQL> CREATE TABLE product(pcode NUMBER(2),pname VARCHAR2(10));SQL> INSERT INTO product VALUES (1, 'pen');SQL> INSERT INTO product VALUES (2,'pencil');SQL> SAVEPOINT a;SQL> UPDATE product SET pcode = 10 .........【阅读全文】

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

发布时间:2019-02-21 10:22:36

26.choose twoExamine the structure of the PRODUCTS table.Which two statements are true?A) EXPIRY_DATE always stores date and time in character formatB) PRICE can store a maximum of eight digits and two decimals.C) PRODUCT_PIC can store only videos.D) PRODUCT_NAME always stores .........【阅读全文】

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

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

阅读(655) | 评论(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;.........【阅读全文】

阅读(828) | 评论(0) | 转发(0)
给主人留下些什么吧!~~
留言热议
请登录后留言。

登录 注册