根据《注册建造师执业工程规模标准》将电力工程分为火电工程、送变电工程、核电工程、（)4种类别工程。A

A.Itfailsifanyexistingrowviolatestheconstraint.

B.Itdoesnotvalidatetheexistingdatainthetable.

C.Itenablestheconstrainttobeenforcedattheendofeachtransaction.

D.Itpreventsinsert，update，anddeleteoperationsonthetablewhiletheconstraintisintheprocessofbeingenabled

A.Thisclauseisnotvalidforatemporaryorundotablespace.

B.IfthetablespaceisintheNOLOGGINGmode，nooperationonthetablespacewillgenerateredo.

C.ThetablespacewillbeintheNOLOGGINGmodebydefault，ifnotspecifiedwhilecreatingatablespace.

D.Thetablespacelevelloggingattributecanbeoverriddenbyloggingspecificationsatthetable，index，materializedview，materializedviewlog，andpartitionlevels.

Whatistheimpactoftheresultsoftheoutputofthefollowingcommand？（）RMAN>reportunrecoverabledatabase；ReportoffilesthatneedbackupduetounrecoverableoperationsFileTypeofBackupRequiredName4fullorincrementalC：\ORACLE\ORADATA\ORCL\USERS01.DBF

A.Therearenobackupsetswithanybackupsoftheusers01.dbfdatafile.

B.Theusers01.dbfdatafilehashadunrecoverableoperationsoccurinit.Itwillneedtobebackeduporsomedatalossispossibleduringarecovery.

C.Theusers01.dbfdatafileiscorrupted.

D.Theusers01.dbfdatafilebackupexceedstheretentioncriteria.

E.Thelastbackupoftheusers01.dbfdatafilefailedandmustbererun.

A.Thedatabaseautomaticallydeterminestheextent-sizingpolicyforthetablespace.

B.Thesegmentsareautomaticallyshrunkwhenthecontentsareremovedfromthem.

C.Theallocationofextentswithinthetablespaceismanagedthroughthedictionarytables.

D.Thespaceutilizationdescriptionofthedatablocksinsegmentsisrecordedinbitmapblocks.

E.Thespaceutilizationdescriptionofthedatablocksinsegmentsismanagedthroughfreelists.

noindividualsystemprivileges.TheSL_REPuserexecutesthiscommandtocreateatable:SQL>CREATETABLEorders(oidnumber(6),odatedate,ccodenumber(4),oamtnumber(10,2))TABLESPACEpurchase_space;ThePURCHASE_SPACEtablespacealreadyexistsinthedatabase.Whichstatementdescribestheeffectofthecommand（）

A.ThecommandexecutessuccessfullyandcreatesthetableintheUSERStablespace.

B.ThecommandexecutessuccessfullyandcreatesthetableinthePURCHASE_SPACEtablespace.

C.Thecommandproducesanerrorbecausetheuserdoesnothavetheprivilegetocreatethetable.

D.ThecommandproducesanerrorbecausetheuserdoesnothavequotainthePURCHASE_SPACEtablespace.

A.V$SESSION_EVENT

B.V$SESSION

C.V$WAITS

D.V$WAITSTAT

E.V$SESSION_LONGOPS

A.V$SESSION_EVENT

B.V$SESSION

C.V$WAITS

D.V$WAITSTAT

E.V$SYSSTAT

Considerthefollowingscenario：Youhaveadirectory，data，underthediskgrouptdgroupA.Youwanttocreateanaliasforoneofthedatafilesandyouexecutethefollowingcommand：ALTERDISKGROUPtdgroupAADDALIAS’+tdgroupA/data/datafile.dbf’FOR’+tdgroupA.231.45678’；Whichtaskwouldbeaccomplishedbythecommand？（）

A.Thecommanddropsthefile+tdgroupA·231.45678.

B.Thecommandphysicallyrelocatesthefileto+tdgroupA/dataandrenamesthefiletodatafile.dbf.

C.Thecommandcreatesacopyofthe+tdgroupA·231.45678fileandplacesitin+tdgroupA/dataafterrenamingthefiletodatafile.dbf.

D.Thecommandcreatesanalias，datafile.dbf，andplacesitin+tdgroupA/dataanddoesnotremovethe+tdgroupA·231.45678file.

E.Thecommandcreatesafile，datafile.dbf，in+tdgroupA/dataandremovesthereferencesfor+tdgroupA·231.45678fromthedatadictionaryviews.

InyourOracle10gdatabase，youhavescheduledajobtoupdatetheoptimizerstatisticsat05：00pmeveryFriday.Thejobhassuccessfullycompleted.Whichthreepiecesofinformationwouldyouchecktoconfirmthatthestatisticshavebeencollected？（）

A.averagerowsize

B.lastanalyzeddate

C.sizeoftableinbytes

D.sizeoftableindatabaseblocks

E.numberoffreeblocksinthefreelist

F.numberofextentspresentinthetable

A.Multiplexalldatabasefiles.

B.ConfiguretheFlashRecoveryArea.

C.ConfigurethedatabaseinstanceforARCHIVELOGmode.

D.ConfiguretheFAST_START_MTTR_TARGETinitializationparameter