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

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









发布时间:2019-02-18 15:51:35

15、(6-24)choose the best answerExamine the structure of the MEMBERS table:You want to display details of all members who reside in states starting with the letter A followedby exactly one character.Which SQL statement must you execute?A. SELECT * FROM MEMBERS WHERE state LIKE 'A%’;B..........【阅读全文】

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

发布时间:2019-02-18 14:48:55

14、(6-13) choose the best answer:View the Exhibit and examine the structure of the ORDERS table.Which UPDATE statement is valid?A) UPDATE ordersSET order_date = '12-mar-2007'AND order_total = TO_NUMBER(NULL)WHERE order_id = 2455;B) UPDATE ordersSET order_date = '12-mar-2007',order_to.........【阅读全文】

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

发布时间:2019-02-18 14:11:50

13、(6-7) choose twoWhich two statements are true regarding operators used with subqueries? (Choose two.)A) =ANY and =ALL operators have the same functionality.E) The NOT IN operator is equivalent to is NULL.C) The <ANY operator means less than the maximum.D) The NOT operator can be used with.........【阅读全文】

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

发布时间:2019-02-15 15:27:25

12、(5-12)choose two:Examine the data in the CUSTOMERS table:You want to list all cities that have more than one customer along with the customer details.Evaluate the following query:SQL>SELECT c1.custname, c1.cityFROM Customers c1______Customers c2ON ( AND c1.custname<>c2.cus.........【阅读全文】

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

发布时间:2019-02-15 13:19:30

11、(5-8) choose the best answer:Examine the structure of the BOOKS_TRANSACTIONS table.You want to update this table such that BOOK_ID is set to 'INVALID' for all rows where no MEMBER_IDhas been entered.Examine this partial SQL statement:SQL> UPDATE books_transactionsSET book.........【阅读全文】

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

登录 注册