[单选题]You are the network administrator for Ezonexam.com.You create two shared printers on a Windows 2000 Server computer in Ezonexam.com Ezonexam. One printer is shared as Admin, and the other printer is shared as Executive. Both printers are connected to the same print device. You set the priority of the Admin printer to 90 and the priority of the Executive printer to 50.

正确答案 ：F

Clear the List in the Directory check box in the printer configuration.

解析：解析：Explanation: When this check box is selected you are actually listing the printer in the Active Directory. This box is selected by default and, if selected, ensures that users can search for the printer when configuring a network printer to connect to. Thus if you do not want the Executive printer to appear in the browse list when other employees create a new printer connection on their client computers, then you should clear this checkbox.

[单选题]You are the administrator of a SQL Server 2000 database. Using the default options configures the database. You drop indexes to facilitate a large import of data, and rebuild them after the import is complete.Users report that response times from a stored procedure have become slower. In the stored procedure, you examine the following code.

正确答案 ：L

Recompile the stored procedure.

解析：解析：Explanation:ByrecompilingthestoredprocedureSQLServerwillcreateanewexecutionplanforthestatementsintheprocedure.SQLServerwilldetectthatstatisticsarenotuptodateanditwillautomaticallyrecreatethestatisticsduringthisprocess.Theexecutionplanwillbeoptimizedforthecurrentdistributionofdatainthetables.Note:Storedprocedurescanbeusedtoimprovedatabasequeryperformance.IftheseSQLstatementsandconditionallogicarewrittenintoastoredprocedure,theybecomepartofasingleexecutionplanthatiscachedontheserver.Whenthedatabaseischangedbytheadditionofnewindexesorwhendatainindexedcolumnsarechanged,theoriginalqueryplansandstoredproceduresusedtoaccessthetablesshouldbereoptimizedbyrecompilingthem.ThisoptimizationhappensautomaticallythefirsttimeastoredprocedureisrunafterSQLServer2000isrestarted.Italsooccursifanunderlyingtableusedbythestoredprocedurechanges.Butifanewindexisaddedfromwhichthestoredproceduremightbenefit,optimizationdoesnotautomaticallyoccuruntilthenexttimethestoredprocedureisrunafterSQLServerisrestarted.Thestoredprocedurecanbemanuallyrecompiledbyusingthesp_recompilesystemstoredprocedure.Thisforcesthestoredproceduretoberecompiledthenexttimeitisrun.IncorrectAnswers:B:SQLServerdetectswhetherstatisticsarenotup-to-date,andbydefaultitautomaticallyupdatesthemduringqueryoptimization.Byrecompilingthequerythestatisticswillautomaticallybeupdated.Note:SQLServerkeepsstatisticsaboutthedistributionofthekeyvaluesineachindexandusesthesestatisticstodeterminewhichindex(es)touseinqueryprocessing.Queryoptimizationdependsontheaccuracyofthedistributionsteps.Ifthereissignificantchangeinthekeyvaluesintheindex,orifalargeamountofdatainanindexedcolumnhasbeenadded,changed,orremoved,orthetablehasbeentruncatedandthenrepopulated,UPDATESTATISTICSshouldbererun.C:Consistencyofadatabaseismaintainedthroughtheuseofconstraintsandtriggers.Thesemechanismsareusedtoensurethatthedatabaseremainsconsistentbycontrollingthetypeofdatathatcanbeinsertedintoacolumn,throughreferentialintegritychecks,andthroughcascadingreferentialconstraints.D:Aviewisavirtualtablethatcanbeusedtorestrictusersaccesstothebasetable,ortojoinvariousbasetablessothattheyappearasasingletable.However,creatingaviewthatthestoredproceduremustaccesswouldrequirethecreationofindexesontheviewandwillhavetobeupdatedwhenthebasetablesareupdates.Thiswouldrequiregreateradministrativeeffort.

查看原题