Considerthefollowingcommandtocreateatablespaceinyourproductiondatabase(whichisusinganAutomaticStorageManagement[ASM]instancetomanagethedatabasefiles):CREATETABLESPACEuser_tbspDATAFILE’+dgroup3(user_temp)/user_files/user_tbsp’SIZE200MWhatwouldbetheresultofthiscommand?()A.Itwouldresultinanerrorbecausethetemplatecannotbeusedalongwiththediskgroup.B.Itwouldresultinanerrorbecausethepathcannotbespecifiedwhilecreatingatablespaceinadiskgroup.C.Itwouldcreateatablespacewithadatafilethathasanalias,anditsattributesaresetbytheuserdefinedtemplate.D.Itwouldcreateatablespacewithadatafilethatdoesnothaveanalias,anditsattributesaresetbytheuserdefinedtemplate.
Considerthefollowingcommandtocreateatablespaceinyourproductiondatabase(whichisusinganAutomaticStorageManagement[ASM]instancetomanagethedatabasefiles):CREATETABLESPACEuser_tbspDATAFILE’+dgroup3(user_temp)/user_files/user_tbsp’SIZE200MWhatwouldbetheresultofthiscommand?()
A.Itwouldresultinanerrorbecausethetemplatecannotbeusedalongwiththediskgroup.
B.Itwouldresultinanerrorbecausethepathcannotbespecifiedwhilecreatingatablespaceinadiskgroup.
C.Itwouldcreateatablespacewithadatafilethathasanalias,anditsattributesaresetbytheuserdefinedtemplate.
D.Itwouldcreateatablespacewithadatafilethatdoesnothaveanalias,anditsattributesaresetbytheuserdefinedtemplate.