ocp考试资料群:569933648 验证码:ocp OCP 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(487)
发布时间:2019-11-06 10:08:36
Which three statements are true about GLOBAL TEMPORARY TABLES?B) A GLOBAL TEMPORARY TABLE can have multiple indexesD) Data Manipulation Language (DML) on GLOBAL TEMPORARY TABLES generates no REDO.F) A tigger can be created on a GLOBAL TEMPORARY TABLE(解析:全局临时表跟普通表一样,.........【阅读全文】
发布时间:2019-11-06 09:38:11
Which two statements are true about transactions in the Oracle Database serve?B) Data Manipulation Language (DML) statements always start a new transaction.D) A Data Detiniton Language (DDL) statement does a commit automatially only for the data dictionary updates caused by the DDLF) I.........【阅读全文】
发布时间:2019-11-04 10:49:06
Which two statements are true about transactions in the Oracle Database serve?B) Data Manipulation Language (DML) statements always start a new transaction.D) A Data Detiniton Language (DDL) statement does a commit automatially only for the data dictionary updates caused by the DDLF) I.........【阅读全文】
发布时间:2019-11-04 10:18:09
In the PROMOTIONS table, the PROMO_BEGTN_DATE columm is of datatype DATE and the default date format is DD-MON-RR.A) TO_NUMBER(PROMO_ BEGIN_DATE) - 5 will return numberC) PROMO_BEGIN_DATE - SYSDATE will return a number.E) PROMO_BEGIN_DATE - SYSDATE will return an error.(解析:这道.........【阅读全文】
发布时间:2019-10-30 13:05:01
The PRODUCT_INFORMATION table has a UNIT_PRICE column of data type NUMBER(8, 2).SELECT TO_CHAR(unit_price,'$9,999') FROM Product_intormation;A) A row whose UNIT_PRICE column contains the value 1023.99 will be displayed as $1,024.C) A row whose UNIT_PRICE column contains the value 10235.........【阅读全文】