下列哪些选项为关于法律起源的学说？ ()

A.Languages(LanguageID,Name)Elements(ElementID,Description)ElementLanguages(ElementID,LanguageID,Text)

B.Languages(LanguageID,Name)Elements(ElementID,LanguageID,Description,Text)

C.Languages(LanguageID,Name)ElementTexts(LanguageID,Text)ElementDescriptions(ElementID,Description)

D.Languages(LanguageID,Name)Elements(ElementID,Description,Text)

.YouuseaSQLServer2005databasetostorethecommentsintheCommentscolumnofatablenamedFeedback.Youneedtoimplementfull-textsearchingsothatyoucanrunreportsonthecomments.Whichtwoactionsshouldyouperform?（）

A.CreateanonclusteredindexontheCommentscolumn.

B.ExecutetheUSEMasterTransact-SQLstatement.

C.Createafull-textcatalog.

D.Createafull-textindexontheCommentscolumn.

hemaforanorderentryapplicationinaSQLServer2005database.Afteradesignreview,amemberofthedevelopmentstaffasksyoutoaddanewcolumnnamedCommissionRatetotheProducttable.Becausetheactualcommissionratesforallproductsarenotknownatthistime,eachproducthasadefaultcommissionrateof12percent.Theratecanbemodifiedasnecessary.Youaddthenewcolumn.Youneedtoconfigurethetabletoassignthedefaultvalueasefficientlyaspossible.Whatshouldyoudo?（）

A.adomainuseraccount

B.alocaluseraccount

C.theNETWORKSERVICEaccount

D.theLOCALSYSTEMaccount

A.AddaReportViewercontroltoAPP3.

B.AddanInternetExplorerActiveXcontroltoAPP3.SetthecontrolsURLtotheADatumCorporationReportManager.

C.CreateahyperlinkinAPP3thatreferencestheReportManager.

D.CreateaproxyclasstotheReportServerWebservice.

uneverySundayandotherjobsrunatthebeginningofeverymonth.Youneedtoschedulethejobsinthewaythatusestheleastamountofadministrativeeffort.Whatshouldyoudo?（）

A.CreateajobschedulethatrunseverySunday.Assignweeklytaskstothisschedule.Createasecondschedulethatrunsonthefirstdayofeverymonth.Assignmonthlytaskstothisschedule.

B.Createajobforeachtaskthatrunsonceaday.UseaTransact-SQLstatementtocheckthedateanddayoftheweek.IfthedayiseitheraSundayorthefirstdayofthemonth,executethecode.

C.Createajobschedulethatrunsonceaday.Assignjobstothisjobschedule.IfthedayiseitheraSundayorthefirstdayofthemonth,executethejobs.

D.CreateajobforeachtaskthatrunsonceaweekonSunday.Addasecondjobschedulethatrunsthejobonthefirstofthemonth.

A.CreateaWebpublishingruleonISA2thatallowsHTTPtrafficonport5017fromIIS1totheSQLServercomputer.

B.CreateaWebpublishingruleonISA1thatallowsHTTPtrafficonport5017fromIIS1totheSQLServercomputer.

C.CreateaWebpublishingruleonISA2thatallowsHTTPStrafficonport5017fromIIS1totheSQLServercomputer.

D.CreateaWebpublishingruleonISA1thatallowsHTTPStrafficonport5017fromIIS1totheSQLServercomputer.

rthatsomequeriesdonotuseoptimalexecutionplans.Youalsonoticethatsomeoptimizerstatisticsaremissingandothersareoutofdate.Youneedtocorrecttheproblemsothatreportsexecutemorequickly.WhichtwoTransact-SQLstatementsshouldyouuse?（）

A.DBCCCHECKTABLE

B.ALTERINDEXREORGANIZE

C.UPDATESTATISTICS

D.CREATESTATISTICS

E.DBCCSHOW_STATISTICS

F.DBCCUPDATEUSAGE

requiretheminimumamountofadministrativeeffort.Theauthenticationenvironmentmustfulfillthecompany’ssecurityrequirements.Whatshouldyoudo？（）

A.CreateaSQLServerloginwithWindowsAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothedb_ownerroleineachdatabase.

B.CreateaSQLServerloginwithSQLServerAuthenticationforeachmainofficedatabaseadministrator.Addalloftheseloginstothesysadminrole.

C.CreateaWindowsglobalgroupnamedDBAdmins.Addeachmainofficedatabaseadministrator’s WindowsuseraccounttotheWindowsDBAdminsgroup.CreateaSQLServerloginwithWindowsAuthenticationforthegroup.Addthegrouptotheserveradminfixedserverrole.

D.Addeachmainofficedatabaseadministrator’sWindowsuseraccounttotheWindowsSQLManagersgroup.

nerror.Youinvestigatetheerror.Youdiscoverthatinoneofthedatabases,adeveloperhasaccidentallydeletedsomedatainatablethatiscriticalfortransactionprocessing.Thedatabaseusesthefullrecoverymodel.Youneedtorestorethetable.Youneedtoachievethisgoalwithoutaffectingtheavailabilityofotherdatainthedatabase.Whatshouldyoudo?（）

A.Backupthecurrenttransactionlog.Restorethedatabasewithadifferentnameandstopatthepointjustbeforethedataloss.Copythetablebackintotheoriginaldatabase.

B.Backupthecurrenttransactionlog.Restorethedatabasetothepointjustbeforethedataloss.

C.Restorethedatabasefromtheexistingbackupfilestoatimejustbeforethedataloss.

D.Restorethedatabasetothepointofthelastfullbackup.