ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：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.........【阅读全文】
发布时间：2019-02-22 10:54:42
31.choose the best answerWhich statement is true regarding the USING clause in table joins?A) It can be used to access data from tables through equijoins as well as nonequijoins.B) It can be used to join tables that have columns with the same name and compatible data types.C) It can be u.........【阅读全文】
发布时间：2019-02-22 10:24:13
30.choose the best answerExamine the commands used to create DEPARTMENT_DETAILS and COURSE_DETAILS:SQL> CREATE TABLE DEPARTMENT_DETAILS(DEPARTMENT_ID NUMBER PRIMARY KEY,DEPARTMENT_NAME VARCHAR2(50) ,HOD VARCHAR2(50));SQL> CREATE TABLE COURSE_DETAILS(COURSE_ID NUMBER PRIMARY KEY,.........【阅读全文】
