ocp考试资料群:569933648 验证码:ocp ocp 12c 19c考试题库解析与资料群:钉钉群号:35277291
全部博文(485)
发布时间:2019-08-30 14:39:35
a)it improves database performance by automatically implementing oracle ‘s best practices.c)it can be used by executing the pl/sql procedures in the dbms_addm package.e)it provides recommendations to improve database performance.answer: cdeaddm(automatic database diagnostic monito.........【阅读全文】
发布时间: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; --数.........