ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-20 17:27:37
24. choose the best answerIn the EMPLOYEES table there are 1000 rows and employees are working in the company for more than 10 years.Evaluate the following SQL statement:SQL> UPDATE employeesSET salary = NVL(salary,0) + NVL(comm,0),comm = NVL(comm,0)WHERE hire_date < SYSDATE - 600;.........【阅读全文】
发布时间：2019-02-20 16:14:50
23.choose the best answerView the Exhibits and examine PRODUCTS and SALES tables.You issue the following query to display product name and the number of times theproduct has been sold:SQL>SELECT p.prod_name, i.item_cntFROM (SELECT prod id, COUNT(*) item_cntFROM sales GROUP BY prod_.........【阅读全文】
发布时间：2019-02-20 15:31:30
Evaluate the following CREATE SEQUENCE statement:START WITH 100MAXVALUE 200NOCACHE;You issue the following SQL statement:What is displayed by the SELECT statement?B) 100D) 10Answer：B......【阅读全文】
发布时间：2019-02-20 13:53:12
View the Exhibit and examine the description of SALES and PROMOTIONS tables. A) DELETEWHERE promo_id = (SELECT promo_idWHERE promo_name = 'blowout sale')FROM promotions FROM salesFROM promotionsAND promo_id = (SELECT promo_idWHERE promo_name = 'eve.........【阅读全文】
发布时间：2019-02-19 11:51:23
20.choose twoExamine the description of the EMP_DETAILS table given below:Which two statements are true regarding SQL statements that can be executed on the EMP_DETAIL table?A) You cannot add a new column to the table with LONG as the data type.B) An EMP_IMAGE column can be included .........【阅读全文】
