ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-26 16:34:19
39.choose the best answerView the Exhibit and examine the description of the EMPLOYEES table.You want to calculate the total remuneration for each employee. Total remuneration is the sum of the annual salary and the percentage commission earned for a year.Only a few employees earn commission..........【阅读全文】
发布时间：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,.........【阅读全文】
