网友您好, 请在下方输入框内输入要搜索的题目:

题目内容 (请给出正确答案)

Examine the CREATE DISKGROUP command used to create a disk group:SQL> CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?()

A. When two-way disk mirroring is required for the allocation units

B. When three-way disk mirroring is required for the allocation units

C. When using hardware mirroring or RAID

D. When disk mirroring is required for the Automatic Storage Management (ASM) disks


参考答案

更多 “ Examine the CREATE DISKGROUP command used to create a disk group:SQL CREATE DISKGROUP misc EXTERNAL REDUNDANCYDISK ‘ORCL: FRA3‘ NAME misc1, ‘ORCL: FRA4‘ NAME misc2;In which situation would you use this method of disk group creation?()A. When two-way disk mirroring is required for the allocation unitsB. When three-way disk mirroring is required for the allocation unitsC. When using hardware mirroring or RAIDD. When disk mirroring is required for the Automatic Storage Management (ASM) disks ” 相关考题
考题 能使数据库记录只显示当前记录且能暂停的命令是()。 A、GOTOB、DISPC、USED、CREATE

考题 数据库记录的显示命令有LIST和()。 A、GOTOB、DISPC、USED、CREATE

考题 数据库记录的显示命令是指()、DISP。 A、GOTOB、LISTC、USED、CREATE

考题 能使数据库记录满屏显示而不暂停的命令是()。 A、GOTOB、LISTC、USED、CREATE

考题 Youarecreatingajobclass.Youhaveissuedthefollowingcommandtocreatethejobclass:SQLBEGINDBMS_SCHEDULER.CREATE_JOB_CLASS(JOB_CLASS_NAME=’LOW_PRIORITY_CLASS’,RESOURCE_CONSUMER_GROUP=’LOW_GROUP’,LOGGING_LEVEL=DBMS_SCHEDULER.LOGGING_FULL,LOG_HISTORY=1200,COMMENTS=’LOWJOBPRIORITYCLASS’);END;SQL/Whatwillbetheresultoftheabovecommand?()A.Thecommandwillbeexecutedsuccessfully.B.ThecommandwillfailbecauseRESOURCE_CONSUMER_GROUPisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.C.ThecommandwillfailbecauseLOGGING_LEVELisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.D.ThecommandwillfailbecauseLOG_HISTORYisaninvalidparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.E.Thecommandwillfailbecause1200isaninvalidvaluefortheLOG_HISTORYparameterintheDBMS_SCHEDULER.CREATE_JOB_CLASSprocedure.

考题 Youhavecreatedaresourceplan,DAY.Youexecutethefollowingcode:SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE(PLAN=’DAY’,COMMENT=’DEPARTMENTSPLAN’,GROUP_OR_SUBPLAN=’DEPARTMENTS’,CPU_P1=0);END;Then,youissuethefollowingcode:SQLBEGINDBMS_RESOURCE_MANAGER.CREATE_SIMPLE_DIRECTIVE(PLAN=’DAY’,COMMENT=’DEPARTMENTSPLAN’,GROUP_OR_SUBPLAN=’DEVELOPERS’,CPU_P2=100);END;Whatwillbetheimpactofexecutingtheabovecode?()

考题 YouareworkingasaDBAinanorganization.Theflashrecoveryareafilesarecreatedin’+disk1’.Youwanttocreatenewflashrecoveryareafilesinthe’+disk2’location.Thenewlocationoftheflashrecoveryareafilesshouldbewritteninthecontrolfileandthespfile.Whichcommandwillyouissuetochangethelocationoftheflashrecoveryareafiles?()A.ALTERSYSTEMSETDB_RECOVERY_FILE_DEST=’+disk2’;B.ALTERSYSTEMSETDB_RECOVER_FILE_DEST=’+disk2’SCOPE=BOTH;C.ALTERSYSTEMSETDB_CREATE_FILE_DEST=’+disk2’;D.ALTERSYSTEMSETDB_CREATE_ONLINE_LOG_DEST_n=’+disk2’;

考题 Yourapplicationrequiresthatyouprogrammaticallymanipulateanonqueryrecordgroup.Whichthreebuilt-inscanyouuse?() A.CREATE_GROUPB.ADD_GROUP_NOWC.POPULATE_GROUPD.ADD_GROUP_COLUMNE.CREATE_GROUP_FROM_QUERY

考题 下列四组SQL命令,全部属于数据定义语句的命令是()A.CREATE,DROP,UPDATEB.CREATE,DROP,ALTERC.CREATE,DROP,GRANTD.CREATE,DROP,SELECT

考题 下列哪组SQL命令全部属于数据定义语句的命令?()A.CREATE,DROP,ALTERB.CREATE,DROP,SELECTC.CREATE,DROP,GRANTD.CREATE,DROP,UPDATE