ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-26 15:17:08
View the Exhibit and examine the structure of the PROMOTIONS table.Evaluate the following SQL statement:WHEN promo_cost>=(SELECT AVG(promo_cost)WHERE promo_category= 'TV')ELSE 'LOW'FROM promotions;A) It shows COST_REMARK for all the promos in the promo category 'TV' .C).........【阅读全文】
发布时间：2019-02-25 13:24:45
36.choose the best answerView the Exhibits and examine the structures of the PRODUCTS, SALES, and CUSTOMERS tables.You issue the following query:SQL>SELECT p.prod_id,prod_name,prod_list_price,quantity_sold,cust_last_nameFROM products p NATURAL JOIN sales s NATURAL JOIN customers cWHERE prod_id.........【阅读全文】
发布时间：2019-02-25 11:20:39
35.choose the best answerView the Exhibit and examine the description of the EMPLOYEES table.Evaluate the following SQL statement:SELECT first_name, employee_id, NEXT_DAY(ADD_MONTHS(hire_date,6),1) "Review" FROM employees;The query was written to retrieve the FIRST_NAME, EMPLOYEE_ID,.........【阅读全文】
发布时间：2019-02-25 10:16:44
34.choose twoView the Exhibit and examine the structure of the PRODUCT_INFORMATION and INVENTORIES tables.You have a requirement from the supplies department to give a list containing PRODUCT_ID, SUPPLIER_ID, and QUANTITY_ON_HAND for all the products where in QUANTITY_ON_HAND is less than five..........【阅读全文】
发布时间：2019-02-25 09:44:53
33.choose the best answerView the Exhibit and examine the structure of the ORDER_ITEMS table.Examine the following SQL statement:SELECT order_id, product_id, unit_priceFROM order_itemsWHERE unit_price =(SELECT MAX(unit_price)FROM order itemsGROUP BY order_id);You want to d.........【阅读全文】
