未知题型
ExaminethefollowingstatementthatisusedtomodifytheprimarykeyconstraintontheSALEStable：SQL>ALTERTABLESALESMODIFYCONSTRAINTpkDISABLEVALIDATE；Whichthreestatementsaretrueregardingtheabovecommand（）
- A.Theconstraintremainsvalid.
B.Theindexontheconstraintisdropped.
C.ItallowstheloadingofdataintothetableusingSQL*Loader.
D.Newdataconformstotheconstraint，butexistingdataisnotchecked.
E.ItallowsthedatamanipulationonthetableusingINSERT/UPDATE/DELETESQLstatements.
【参考答案】
A, B, C
点击查看答案
相关考题
- 未知题型 YouwanttomigrateyourexistingnonASMfilestoASMfilesforthedatabasePROD.Whichmethodorcommandwouldyouusetoaccomplishthistask？（）
- 未知题型 Evaluatethefollowingcommandanditsoutput：SQL>SELECT*FROMdba_temp_free_space；TABLESPACE_NAMETABLESPACE_SIZEALLOCATED_SPACEFREE_SPACELMTEMP250609664101048576149561088Whichtwostatementscorrectlyinterprettheoutput？（）A.FREE_SPACEindicatesonlythespacethatiscurrentlyunallocated.B.ALLOCATED_SPACEindicatesonlythespacecurrentlyallocatedandinuse.C.FREE_SPACEindicatesonlythespacethatiscurrentlyallocatedandavailableforreuse.D.ALLOCATED_SPACEindicatesboththespacecurrentlyallocatedandused，andthespacethat isavailableforreuse.E.FREE_SPACEindicatesboththespacethatiscurrentlyallocatedandavailableforreuse，andthespacethatiscurrentlyunallocated.
- 未知题型 Youdecidedtoconfiguretheflashrecoveryareainyourdatabasetocentralizethestorageofalltherecoveryfilesinacertainlocationondisk.Whichtwoparameterswillyouspecifyintheinit.orafile？（）
- 未知题型 YouexecutedthefollowingcommandtocreateatablespacecalledSALES_DATA：>CREATETABLESPACEsales_dataDATAFILESIZE100MSEGMENTSPACEMANAGEMENTAUTO；WhichtwostatementsaretrueabouttheSALES_DATAtablespace（）
- 未知题型 Identifythetwosituationsinwhichyouusethealertlogfileinyourdatabasetocheckthedetails.（）
- 未知题型 YouaretheDatabaseAdministrator（DBA）ofyourcompany.YouexecutethefollowingstatementonanOracle10ginstance：SQL>ALTERSYSTEMSWITCHLOGFILE；Whichtwotasksareperformedwhenthestatementisexecuted？（）
- 未知题型 WhichtwostatementsaretrueabouttherolesintheOracledatabase？（）
- 未知题型 InwhichsituationswilltheASMmetadatabackuphelpyourecovertheASMdiskinadiskgroup？（）
- 未知题型 Thecurrenttimezoneforoneoftheusersessionsissettothedatabaselocaltimezone.Foroneapplication，theusersessionrequiresthetimezonetobesettothelocaloperatingsystemtimezonewithoutaffectingotherusersessions.Whichtwosolutionscouldtheuserimplementtoachievethisobjective？（）A.usetheALTERSYSTEMcommandtochangethetimezoneB.usetheALTERSESSIONcommandtochangethetimezoneC.usetheALTERDATABASEcommandtochangethetimezoneD.setthevaluefortheoperatingsystemvariableORA_SDTZontheclientmachineE.setthevaluefortheoperatingsystemvariableORA_SDTZonthedatabaseservermachine
- 未知题型 Whichthreebuilt－inscanyouusetonavigatebetweenformsinvokedwiththeOPEN_FORMbuilt－in?（）
- 未知题型 Identifytwocorrectstatementstocompletethesentance.InaCoherenceimplementation，itisabestpracticetoimplementPortableObjectonallcustomerobjectsbecause：（）
- 未知题型 AJavaBeanscomponenthasthefollowingfield：11.privatebooleanenabled；WhichtwopairsofmethoddeclarationsfollowtheJavaBeansstandardforaccessingthisfield？（）
- 未知题型 服务器按外形分类可分为()
- 未知题型 YourcompanyhasanActiveDirectoryforestthatrunsatthefunctionallevelofWindowsServer2008.YouimplementActiveDirectoryRightsManagementServices（AD RMS）.YouinstallMicrosoftSQLServer2005.WhenyouattempttoopentheAD RMSadministrationWebsite，youreceivethefollowingerrormessage："SQLServerdoesnotexistoraccessdenied."YouneedtoopentheAD RMSadministrationWebsite.Whichtwoactionsshouldyouperform（）A.RestartIIS.B.InstallMessageQueuing.C.StarttheMSSQLSVCservice.D.ManuallydeletetheServiceConnectionPointinActiveDirectoryDomainServices（ADDS）andrestartAD RMS.
- 未知题型 YourcompanyhasasingleActiveDirectorydirectoryserviceforest.AlluseraccountsarelocatedintheUserscontainer.Youneedtocreateanumberoforganizationalunits（OUs）thatwillbeusedtostoreuseraccounts.Whataretwopossiblewaystoachievethisgoal？（）A.UsetheActiveDirectorySitesandServicessnap-in.B.UsetheActiveDirectoryUsersandComputerssnap-in.C.UsetheDsaddcommand-linetoolwiththeOUparameter.D.UsetheDsmodcommand-linetoolwiththeOUparameter.
- 未知题型 YournetworkcontainsanActiveDirectorydomainnamedcontoso.com.Thedomaincontainsfivedomaincontrollers.YouaddalogoffscripttoanexistingGroupPolicyobject（GPO）.Youneedtoverifythateachdomaincontrollersuccessfullyreplicatestheupdatedgrouppolicy.Whichtwoobjectsshouldyouverifyoneachdomaincontroller（）A.//servername/SYSVOL/contoso.com/Policies/{GUID}/gpt.iniB.//servername/SYSVOL/contoso.com/Policies/{GUID}/machine/registry.polC.theuSNChangedvaluefortheCN={GUID}，CN=Policies，CN=System，DC=contoso，DC=comcontainerD.theversionNumbervaluefortheCN={GUID}，CN=Policies，CN=System，DC=contoso，DC=comcontainer
- 未知题型 classOrderimplementsRunnable{publicvoidrun（）{try{Thread.sleep（2000）；}catch（Exceptione）System.out.print（"in"）；publicstaticvoidmain（String[]args）{Threadt=newThread（newOrder（））；t.start（）；System.out.print（"pre"）；try{t.join（）；}catch（Exceptione）{}System.out.print（"post"）；可产生哪两项结果？（）A.preinpostB.preinC.inpostpreD.inprepostE.prepostin
- 未知题型 YouworkastheenterpriseexchangeadministratoratTestKing.com.YouareresponsibleformanagingtheExchangeServer2010environment.YouareintheprocessofdevisingaplantoinstallamonitoringsolutionfortheExchangeServer2010environment.YoureceivenotificationtoproposeasolutiontomanagementfortrackingoftheusageofActiveSyncclientsaswellasanalyzingtheusagetrends.Whatshouldyoudo？（）A.TestbestoptionistoincludetheExchangeServerPerformanceTroubleshooterinthesolution.B.TestbestoptionistoincludetheInternetInformationServerlogfilesinthesolution.C.TestbestoptionistoincludetheMicrosoftSystemControlConfigurationManagerinthesolution.D.TestbestoptionistoincludetheExchangeServerMailFlowTroubleshooterinthesolution.
- 未知题型 YouarethenetworkadministratorforCompanyandyousupporttheportablecomputerusers.AnAccountExecutivenamedHildegardfrequentlytravelstomeetwithcustomersandusesherportablecomputertodemonstratethecompany’snewsoftwareproducts.Hildegardneedstoupdatetheseproductsfrequentlysocustomerscanevaluatethelatestsoftwarereleases.YouneedtoallowHildegardtoinstalltheproductupdateswhilelimitingherabilitytoperformtheradministrativedutiesonherportablecomputer.Whatshouldyoudo？（）A.AddHildegard’suseraccountstothePre-Windows2000CompatibleAccessgroup.B.AddHildegard’suseraccounttothelocalPowerUsersgroup.C.AllowHildegard’suseraccountFullControlpermissiontotheProgramFilesfolder.Propagatethepermissionstoallthesubdirectoriesandfilesinthatdirectory.D.AllowHildegard’suseraccountWritepermissionstotheProgramFilesfolder.Propagatethepermissionstoallthesubdirectoriesandfilesinthatdirectory.
- 未知题型 YournetworkincludesWindowsServer2008R2Hyper-Vfailoverclustersthatsupporthighlyavailablevirtualmachines（VMs）.YoumanagevirtualmachinesbyusingMicrosoftSystemCenterVirtualMachineManager（VMM）2008R2.YouareplanningtodeployalargenumberofVMstothefailoverclusters.AllVMsmustremainavailablewhenonenodeofeachclusterisoffline.YouneedtodeterminethebestplacementforthenewVMsamongtheclusters.Whichtwoactionsshouldyouperform？（）A.Foreachcluster，settheclusterreserveto1B.DeterminetheplacementforeachVMbyusingthedatathatisgeneratedbyrunningtheGet-VMPerformancePowerShellcmdletC.DeterminetheplacementforeachVMbyusingthedatathatisgeneratedbyrunningtheGet-VMHostRatingPowerShellcmdletD.Foreachcluster，settheclusterreserveto0
