ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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.........【阅读全文】
发布时间：2019-02-22 13:22:41
View the Exhibit and examine the data in EMP and DEPT tables.In the DEPT table, DEPTNO is the PRIMARY KEY.the DEPTNO column in the DEPT table.DROP TABLE emp;INSERT INTO emp VALUES (2,'SCOTT', 10);A) Both the INSERT statements would succeed because none of the constraints on the.........【阅读全文】
