A. 100KB default, 10TB maximum
B. 256KB default, 1024MB maximum
C. 10MB default, 126PB maximum
D. 64KB default, 1EB maximum
E. 1MB default, 64MB maximum
第1题:
Considerthefollowingcommandtocreateatablespaceinyourproductiondatabase(whichisusinganAutomaticStorageManagement[ASM]instancetomanagethedatabasefiles):CREATETABLESPACEuser_tbspDATAFILE’+dgroup3(user_temp)/user_files/user_tbsp’SIZE200MWhatwouldbetheresultofthiscommand?()
A.Itwouldresultinanerrorbecausethetemplatecannotbeusedalongwiththediskgroup.
B.Itwouldresultinanerrorbecausethepathcannotbespecifiedwhilecreatingatablespaceinadiskgroup.
C.Itwouldcreateatablespacewithadatafilethathasanalias,anditsattributesaresetbytheuserdefinedtemplate.
D.Itwouldcreateatablespacewithadatafilethatdoesnothaveanalias,anditsattributesaresetbytheuserdefinedtemplate.
第2题:
YouaremaintainingtheSALESdatabaseonOracle10g.Youhaveaddedanewdisktoadiskgroup.AutomaticStorageManagementperformstherebalancingactivity.Youwanttospeeduptherebalancingactivity.Whichparameterwillyouspecifytocontrolthespeedoftherebalancingactivity?()
A.ASM_POWER_LIMIT
B.ASM_DISKSTRING
C.ASM_DISKGROUPS
D.LARGE_POOL_SIZE
第3题:
A.AU_SIZE
B.COMPATIBLE·RDBMS
C.COMPATIBLE·ASM
D.DISK_REPAIR_TIME
E.DG_DROP_TIME
第4题:
YouincludedthefollowingAutomaticStorageManagement(ASM)initializationparametersettingsintheASMinitializationparameterfile:INSTANCE_TYPE=ASMASM_POWER_LIMIT=11LARGE_POOL_SIZE=4MASM_DISKGROUPS=DG1,DG2DB_UNIQUE_NAME=+ASMYouareunabletostarttheASMinstance.Whichinitializationparameterfilesetting(s)isnotallowingtheASMinstancetostart?()
A.onlytheINSTANCE_TYPEinitializationparameterissettoaninvalidvalue
B.onlytheASM_POWER_LIMITinitializationparameterissettoaninvalidvalue
C.onlytheLARGE_POOL_SIZEinitializationparameterissettoaninvalidvalue
D.boththeLARGE_POOL_SIZEandINSTANCE_TYPEinitializationparametersaresettoinvalidvalues
第5题:
Inwhichsituationwillyourunthescriptcontainingthefollowingstatement?()
CREATECONTROLFILEREUSEDATABASESALESNORESETLOGSARCHIVELOG
MAXLOGFILES20
MAXLOGMEMBERS3
MAXDATAFILES30
MAXINSTANCES10
MAXLOGHISTORY1200
LOGFILE
GROUP1(
’/disk1/prod/orders/db/log1a.dbf’,
’/disk2/prod/orders/db/log1b.dbf’
)SIZE100K
GROUP2(
’/disk1/prod/orders/db/log2a.dbf’,
’/disk2/prod/orders/db/log2b.dbf’
)SIZE100K,
DATAFILE
’/disk1/prod/orders/db/database1.dbf’,
’/disk2/prod/orders/db/file1.dbf’;
第6题:
A database is stored in an Automatic Storage Management (ASM) disk group, disk group, DGROUP1 with SQL:There is enough free space in the disk group for mirroring to be done.What happens if the CONTROLLER1 failure group becomes unavailable due to error of for maintenance?()
A. Transactions and queries accessing database objects contained in any tablespace stored in DGROUP1 will fall.
B. Mirroring of allocation units will be done to ASM disks in the CONTROLLER2 failure group until the CONTROLLER1 for failure group is brought back online.
C. The data in the CONTROLLER1 failure group is copied to the controller2 failure group and rebalancing is initiated.
D. ASM does not mirror any data until the controller failure group is brought back online, and newly allocated primary allocation units (AU) are stored in the controller2 failure group, without mirroring.
E. Transactions accessing database objects contained in any tablespace stored in DGROUP1 will fail but queries will succeed.