题目内容（请给出正确答案）

[主观题]

You plan to use the In Database Archiving feature of Oracle Database 12c, and store rows t

hat are inactive for over three months, in Hybrid Columnar Compressed (HCC) format.Which three storage options support the use of HCC？（）

A. ASM disk groups with ASM disks consisting of Exadata Grid Disks.

B. ASM disk groups with ASM disks consisting of LUNS on any Storage Area Network array

C. ASM disk groups with ASM disks consisting of any zero padded NFS-mounted files

D. Database files stored in ZFS and accessed using conventional NFS mounts.

E. Database files stored in ZFS and accessed using the Oracle Direct NFS feature

F. Database files stored in any file system and accessed using the Oracle Direct NFS feature

G. ASM disk groups with ASM disks consisting of LUNs on Pillar Axiom Storage arrays

查看答案

如搜索结果不匹配，请联系老师获取答案

您可能会需要：

重置密码查看订单联系客服

安装上学吧APP，拍照搜题省时又省心！

更多“You plan to use the In Databas…”相关的问题

第1题

Evaluate this SQL statement:SELECT e.EMPLOYEE_ID,e.LAST_NAME,e.DEPARTMENT_ID, d.DEPARTMENT

_NAMEFROM EMPLOYEES e, DEPARTMENTS dWHERE e.DEPARTMENT_ID = d.DEPARTMENT_ID;In the statement, which capabilities of a SELECT statement are performed?（）

A.selection, projection, join

B.difference, projection, join

C.selection, intersection, join

D.intersection, projection, join

E.difference, projection, product

点击查看答案

第2题

YouworkasadatabaseadministratorforCertkiller.com.Inaproductionenvironment，userscomplainabo

uttheslowresponsetimewhenaccessingthedatabase.YouhavenotoptimizedthememoryusageoftheOracleinstanceandyoususpecttheproblemtobewiththememory.Towhichtypeofobjectwouldyourefertodeterminethecauseoftheslowresponse？（）

A.Thetracefile

B.Thefixedviews

C.Thedatadictionaryviews

D.Theoperatingsystemlogfields

E.Thedynamicperformanceviews.

点击查看答案

第3题

In your multitenant container database (CDB) containing pluggable databases (PDB), users c

omplain about performance degradation.How does real-time Automatic database Diagnostic Monitor (ADDM) check performance degradation and provide solutions?（）

A. It collects data from SGA and compares it with a preserved snapshot.

B. It collects data from SGA, analyzes it, and provides a report.

C. It collects data from SGA and compares it with the latest snapshot.

D. It collects data from both SGA and PGA, analyzes it, and provides a report

点击查看答案

第4题

Given：Whichtwomethods，insertedindividually，correctlycompletetheThreeclass？（）

A.publicvoidfoo（）{}

B.publicintfoo（）{return3；}

C.publicTwofoo（）{returnthis；}

D.publicOnefoo（）{returnthis；}

E.publicObjectfoo（）{returnthis；}

点击查看答案

第5题

ViewtheExhibitandexaminethestructureoftheEMPtable.Youexecutedthefollowingcommandtoaddaprim

arykeytotheEMPtable：ALTERTABLEempADDCONSTRAINTemp_id_pkPRIMARYKEY（emp_id）USINGINDEXemp_id_idx；Whichstatementistrueregardingtheeffectofthecommand？（）

A.ThePRIMARYKEYiscreatedalongwithanewindex.

B.ThePRIMARYKEYiscreatedanditwoulduseanexistinguniqueindex.

C.ThePRIMARYKEYwouldbecreatedinadisabledstatebecauseitisusinganexistingindex.

D.ThestatementproducesanerrorbecausetheUSINGclauseispermittedonlyintheCREATETABLEcommand.

点击查看答案

第6题

YouareworkingontheCertkillerdatabase.Whatisthedefaultnameofthealertlogfileinthisdatabase？（）

A.alert_Certkiller.log

B.alertlog_Certkiller.log

C.alert_log_Certkiller.log

D.Certkiller_alert_log.log

E.log_alert_：Certkiller.log

F.trace_alert_Certkiller.log

点击查看答案

第7题

Considerthefollowingconfiguration：/devices/D1isamemberofdiskgroupdgroupA./devices/D2isamem

berofdiskgroupdgroupA./devices/D3isamemberofdiskgroupdgroupA.Youplantoaddanewdisk，/devices/D4，tothediskgroupdgroupA.Youexecutethefollowingcommand：SQL>ALTERDISKGROUPdgroupAADDDISK’/devices/D*’；Whichtaskwouldbeaccomplishedbythecommand？（）

A.Thecommandaddsthenewdisk，D4，tothediskgroup.

B.Thecommandwouldresultinanerrorbecausetheisnodiskbythename"’/devices/D*’"

C.Thecommandwillbeignoredbecausedisksstartingwith"D"arealreadymembersofthediskgroup.

D.Thecommandwouldresultinanerrorbecausenowildcardcharacterscanbeusedinthediskname.

E.Thecommandfirstdetachesallthememberdisksstartingwith"D"，andthereattachesthemincludingthenewdisk.

点击查看答案

第8题

The tnsnames.ora file has an entry for the service alias ORCL as follows:The TNS ping comm

and executes successfully when tested with ORCL; however, from the same OS usersession, you are not able to connect to the database instance with the following command:SQL >CONNECT scott/tiger@orcl What could be the reason for this?（）

A. The listener is not running on the database node.

B. The TNS_ADMIN environment variable is set to the wrong value.

C. The orcl.oracle.com database service is not registered with the listener.

D. The DEFAULT_DOMAIN parameter is set to the wrong value in the sqlnet.ora file.

E. The listener is running on a different port.

点击查看答案

第9题

YouworkasadatabaseadministratoratCertkiller.com.Inyourproductiondatabasethereisajob，CALC_S

TAT，whichhasbeenscheduledtoruneveryFridayat5.00p.m.CALC_STATupdatestheoptimizerstatisticsfortheobjectsownedbytheAPPSschema.Youwantthetasktobegeneric，therebyallowinguserstomodifytheattributesofthetaskatruntimewithoutaffectingtheoriginaltask.WhichcomponentofOracleSchedulermustyoudefinetoachievethis？（）

A.Window

B.Program

C.Jobclass

D.Windowgroup

点击查看答案

第10题

YouworkasadatabaseadministratorforCertkiller.com.YouhavesettheretentionperiodforAutomaticR

epository（AWR）statisticstofourdaysandcollectionintervalto15minutes.YouwanttoviewthestatisticscollectedandstoredinAWRsnapshot.WhichtwomethodswouldyouusetoviewtheAWRstatistics？（）

A.useenterprisemanager

B.useDBMS_SQLpackage

C.useDBMS_AWRpackage

D.usePRVT_WORKLOADpackage

E.querytheAWRsnapshotrepositoryobjects

F.useDBMS_WORKLOAD_REPOSITORYpackage

点击查看答案