ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-03-06 11:30:30
View the Exhibit and examine the structure of the ORDERS and ORDER_ITEMS tables.SELECT oi.order_id, product_id, order_dateUSING(order_id);A) The statement would not execute because the table alias prefix is not used in the USING clause.C) The statement would not execute because tab.........【阅读全文】
发布时间：2019-03-06 11:05:43
View the Exhibit and examine the data in the PRODUCTS table.A) ALTER TABLE productsB) ALTER TABLE productsC) ALTER TABLE productsD) ALTER TABLE productsAnswer：D......【阅读全文】
发布时间：2019-03-06 10:33:22
You need to list the employees in DEPARTMENT_ID 30 in a single row, ordered by HIRE_DATE.Which query will provide the required output?FROM employeesWITHIN GROUP ORDER BY hire_date;FROM employeesORDER BY hire_date;WITHIN GROUP (ORDER BY hire_date) "Emp_list", MIN(hire_date) .........【阅读全文】
发布时间：2019-03-06 10:00:50
View the Exhibit and examine the structure of the CUSTOMERS table.Evaluate the following two queries:WHERE (UPPER(cust_last_name) LIKE 'A%' ORUPPER(cust_last_name) LIKE 'C%')SQL> SELECT cust_last_name, cust_credit_limit FROM customersAND cust_credit_limit < 10000;A) Only th.........【阅读全文】
发布时间：2019-03-05 14:22:52
Evaluate the following SQL commands:INCREMENT BY 10MAXVALUE 9999SQL>CREATE TABLE ord_itemsitem_no NUMBER(3),expiry_date date CHECK (expiry_date > SYSDATE),CONSTRAINT ord_fk FOREIGN KEY(ord_no) REFERENCES orders(ord_no));A) You cannot use SYSDATE in the condition of a CH.........【阅读全文】
