ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-19 10:53:58
1.choose the best answerWhat is the primary difference between the relational database (RDB) andobject-oriented database (OODB) models?A) RDB allows the definition of relationships between different tables, whereas OODBdoes not allow this.B) OODB incorporates methods with data structure definit.........【阅读全文】
发布时间：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..........【阅读全文】
