Chinaunix首页 | 论坛 | 博客
  • 博客访问: 579896
  • 博文数量: 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-10-16 09:28:38

The CUSTOMERS table has a CUST_LAST_NAME column of data type VARCHAR2.Which query produces output for CUST_LAST_SAME containing Order for the first row and Aus for the second?B) SELECT REPLACE (TRIM(TRALING 'son' FROM cust_last_name), 'An','O') FROM customers;D) SELECT REPLACE (SUBSTR(.........【阅读全文】

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

发布时间:2019-10-15 10:03:24

Exammine the desciption of the PRODUCT DETALS table:--------------------------------------------------PRODUCT_NAME  NOT NULL  VARCHAR2(25)EXPIRY_DATE  DATEA) PRODUCT_ID can be assigned the PEIMARY KEY constraint.C) EXPIRY_DATE contains the SYSDATE by defalt if no.........【阅读全文】

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

发布时间:2019-10-15 09:33:24

The CUSTOMERS table has a CUST_CREDT_LIMIT column of date type number.A) SELECT TO_CHAR(NVL(cust_credit_limit * .15,'Not Available')) FROM customers;C) SELECT NVL(cust_credit_limit * .15, 'Not Available') FROM customers;E) SELECT NVL2(cust_credit_limit,TO_CHAR(cust_credit_limit * .15),.........【阅读全文】

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

发布时间:2019-10-14 11:25:39

Which three are true about the CREATE TABLE command?B) The owner of the table should have space quota available on the tablespace where the table is defined.D) It implicitly rolls back any pending transactions.F) The owner of the table must have the UNLIMITED TABLESPACE system privileg.........【阅读全文】

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

发布时间:2019-10-14 10:24:31

Exanine the desciption of the EMPLOYEES table:----------------------------------------------------------EMP_NAME VARCHAR2 (40)SALARY NUMBER(8,2)Which query is valid?B) SELECT depe_id,join_date, SUM(salary) FROM employees GROUP BY dept_id:D) SELECT dept_ id,AVG (MAX (salary).........【阅读全文】

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

登录 注册