ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-02-22 09:54:06
29.choose the best answerEvaluate the following query:SQL> SELECT promo_name || q'{'s start date was \}' || promo_begin_dateAS "Promotion Launches"FROM promotions;What would be the outcome of the above query?A) It produces an error because the data types are not matching.B) It e.........【阅读全文】
发布时间：2019-02-21 11:38:29
28.choose the best answerEvaluate the following SQL statement:SQL> SELECT promo_id, promo_categoryFROM promotionsWHERE promo_category = 'Internet' ORDER BY 2 DESCUNIONSELECT promo_id, promo_categoryFROM promotionsWHERE promo_category = 'TV'UNIONSELECT promo_id, promo_ca.........【阅读全文】
发布时间：2019-02-21 11:02:36
27.choose twoThe SQL statements executed in a user session are as follows:SQL> CREATE TABLE product(pcode NUMBER(2),pname VARCHAR2(10));SQL> INSERT INTO product VALUES (1, 'pen');SQL> INSERT INTO product VALUES (2,'pencil');SQL> SAVEPOINT a;SQL> UPDATE product SET pcode = 10 .........【阅读全文】
发布时间：2019-02-21 10:22:36
26.choose twoExamine the structure of the PRODUCTS table.Which two statements are true?A) EXPIRY_DATE always stores date and time in character formatB) PRICE can store a maximum of eight digits and two decimals.C) PRODUCT_PIC can store only videos.D) PRODUCT_NAME always stores .........【阅读全文】
发布时间：2019-02-21 09:44:50
25. choose the best answerEvaluate the following SQL statement:ALTER TABLE hr.empSET UNUSED (mgr_id);Which statement is true regarding the effect of the above SQL statement?A) Any views created on the EMP table that include the MGR_ID column would be automatically modified and remain .........【阅读全文】
