ocp考试资料群：569933648 验证码：ocp OCP 12c 19c考试题库解析与资料群：钉钉群号：35277291
全部博文（487）
发布时间：2019-08-29 13:24:46
SQL> CREATE GLOBAL TEMPORARY TABLE report_work_areaenddate DATE,Which three statements are true about rows inserted into REPORT_WORK_AREA?B)Rows will be lost upon session failure.D)Rows are visible to all sessions logged in by all users granted the DBA role until the session that i.........【阅读全文】
发布时间：2019-08-28 13:27:28
Which two methods will achieve this?B)Use an Oracle Loader type External table.D)Use a CLOB column in a table to access the flat file.Answer: AB外部表可以实现通过数据库对象直接访问目录文件里的格式数据，加载方式分为两种 oracle_loader 和oracle_datapump。oracle_loader 方式通过 sqlldr .........【阅读全文】
发布时间：2019-08-28 11:32:26
A)They can be stored in an ASM Cluster File System(ACFS).C)They support the ORACLE_DATAPUMP access driver.E)They support all DML operations.......【阅读全文】
发布时间：2019-08-23 13:44:03
A)Segments are allocated for external tables.C)They do not support partitioning.E)DML operations may be performed on external tables.CUUG：ORGANIZATION EXTERNALTYPE Oracle_DATAPUMPLOCATION ('countries_ext.dmp') --生成外部文件的名称AS SELECT * FROM scott.countries; --数.........【阅读全文】
发布时间：2019-08-22 14:20:05
connect scott/tiger@prod1;CONNECT TO scott IDENTIFIED BY tigerWhich type of database link is created?B)public connected user database linkD)private fixed user database linkAnswer: D总结：Create 子句中有 public 关键字的是 public 类型的;Create 子句中有 identified by .........【阅读全文】
