单项选择题

YouworkasadatabaseadministratorforCertkiller.com.IntheCertkillerPRODUCTIONdatabaseyouhavegrantedRESUMABLEsystemprivilegetotheCONNECTrole.Resumablespaceoperationhasbeenenabledforallusersession.YouwantusersNOTtobeawareofanykindofspace-relatedproblemswhileperformingtransactions.Instead，youwanttheproblemtoberesolvedbyadatabasetriggerautomatically.Whichcombinationoftriggeringtimeandeventwouldyouusetoachievethisobjective？（）
A.AFTERCREATE
B.AFTERSUSPEND
C.BEFORECREATE
D.AFTERTRUNCATE
E.BEFORESUSPEND
F.AFTERINSERTORDELETEORDELETE
G.BEFOREINSERTORDELETEORDELETE

A.com.IntheCertkillerPRODUCTIONdatabaseyouhavegrantedRESUMABLEsystemprivilegetotheCONNECTrole.Resumablespaceoperationhasbeenenabledforallusersession.YouwantusersNOTtobeawareofanykindofspace-relatedproblemswhileperformingtransactions.Instead，youwanttheproblemtoberesolvedbyadatabasetriggerautomatically.Whichcombinationoftriggeringtimeandeventwouldyouusetoachievethisobjective？（）
A.AFTERCREATE
B.AFTERSUSPEND
C.BEFORECREATE
D.AFTERTRUNCATE
E.BEFORESUSPEND
F.AFTERINSERTORDELETEORDELETE
G.BEFOREINSERTORDELETEORDELETE

你可能感兴趣的试题

单项选择题

YourtestdatabaseisrunninginNOARCHIVELOGmode.Whichstatementistrueregardingthetypeofbackupsthatcanbeperformedonthedatabase（）

A.Youcanperformonlinewholedatabasebackups.
B.Youcanperformofflinewholedatabasebackups.
C.Youcannotperformschema-levelexport/importoperations.
D.YoucanperformthebackupofonlytheSYSTEMtablespacewhenthedatabaseisopen.

单项选择题

YouworkasadatabaseadministratoratCertkiller.com.YourproductiondatabaseusesanAutomaticStorageManagement（ASM）instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers？（）
A.mountthenewdiskgroupintheASMinstance
B.restarttheASMinstanceandtheproductiondatabaseinstance
C.registerthenewdiskgroupsintheproductiondatabaseinstance
D.restarttheASMinstancewithoutrestartingtheproductiondatabaseinstance
E.includethenewdiskgroupintheASM_DISKSTRINGparameterintheparameterfileandrestarttheASMinstance

A.com.YourproductiondatabaseusesanAutomaticStorageManagement（ASM）instancetomanageitsfiles.YouwanttoaddanewdiskgrouptotheASMinstancetomanagetheincreaseddataload.WhatactionwouldyouperformtoincludethenewdiskgroupintheASMinstancewithoutcausinganyimpactonthecurrentlyconnectedusers？（）
A.mountthenewdiskgroupintheASMinstance
B.restarttheASMinstanceandtheproductiondatabaseinstance
C.registerthenewdiskgroupsintheproductiondatabaseinstance
D.restarttheASMinstancewithoutrestartingtheproductiondatabaseinstance
E.includethenewdiskgroupintheASM_DISKSTRINGparameterintheparameterfileandrestarttheASMinstance