ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-19 10:04:36
18、（8-7） choose twoWhich two statements are true regarding views? (Choose two.)A) A simple view in which column aliases have been used cannot be updated.B) The OR REPLACE option is used to change the definition of an existing view without droppingand re-creating it.C) The WITH CHECK OPTION.........【阅读全文】
发布时间：2019-02-19 09:23:51
17、（7-11） choose twoView the Exhibit and examine the structure of ORDER_ITEMS and ORDERS tables.You need to remove from the ORDER_ITEMS table those rows that have an order status of 0 or 1 inthe ORDERS table.Which two DELETE statements are valid? (Choose two.)A) DELETEFROM order_itemsWHE.........【阅读全文】
发布时间：2019-02-18 16:45:42
16、（7-5） choose the best answerThe PRODUCTS table has the following structure:Evaluate the following two SQL statements:SQL>SELECT prod_id, NVL2(prod_expiry_date, prod_expiry_date + 15,'')FROM products;SQL>SELECT prod_id, NVL(prod_expiry_date, prod_expiry_date + 15)FROM products;Which stat.........【阅读全文】
发布时间：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.........【阅读全文】
