ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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..........【阅读全文】
发布时间：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.........【阅读全文】
发布时间：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.........【阅读全文】
发布时间：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 (c1.city=c2.city AND c1.custname<>c2.cus.........【阅读全文】
发布时间：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.........【阅读全文】
