ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-26 16:06:53
View the Exhibit and examine the data in the PROMOTIONS table.PROMO_BEGIN_DATE is stored in the default date format, dd-mon-rr.in the POST category that were launched before January 1, 2000.A) SELECT promo_name, promo_cost, promo_begin_dateWHERE promo_category LIKE '%post%' AND pro.........【阅读全文】
发布时间：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..........【阅读全文】
