ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-11-14 13:26:48
Which two statements are true about the DUAL table?B) It can be accessed only by the SYS user.D) It can display multiple rows but only a single column.F) It can be used to display only constants or pseudo columns.(解析：dual 这个虚拟的表可以显示多行多列;任何用户都可以访问它。这道题.........【阅读全文】
发布时间：2019-11-11 10:57:48
Which three actions can you perfom only with system privileges?B) Access flat files via a database, which are stored in an operating system directory.D) Query any table in a database.F) Execute a procedure in another schema.(解析：这道题考的就是可以授权哪些系统权限去做哪些活儿。.........【阅读全文】
发布时间：2019-11-11 10:10:01
Which three statements are true about defining relations between tables in a relatonal database?B) Unique key columns allow null valuesD) Every primary or unique key value must refer to a matching foreign key value.Answer：ABE......【阅读全文】
发布时间：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.........【阅读全文】
