• 搜标题
  • 搜题干
  • 搜选项
0 / 200字
单项选择题

YouworkinDublinatthemainofficeofTestKing.com.YouareresponsibleformanagingaSQLServer2005database.ThesalesdepartmentwantsareportthatcomparescustomeractivityinthepreviousquarterbetweenthemainofficeinDublinandthebranchofficeinBuenosAires.Theywantthedatasortedbysurnameandfirstname.YourestorearecentbackupoftheBuenosAiresdatabaseontoyourserver.Youwritequeriestobuildthereport，orderingthedatabytheSurnameandFirstNamecolumns.YoureviewthedataandnoticethatthecustomerlistfromtheBuenosAiresdatabaseissorteddifferently.Thesalesdepartmentneedsthereviseddatawithin15minutesforapresentation.
Youneedtoimplementthefastestpossiblesolutionthatensuresthatthedatafrombothdatabasesissortedidentically.
Whatshouldyoudo？（）

A.com.YouareresponsibleformanagingaSQLServer2005database.ThesalesdepartmentwantsareportthatcomparescustomeractivityinthepreviousquarterbetweenthemainofficeinDublinandthebranchofficeinBuenosAires.Theywantthedatasortedbysurnameandfirstname.YourestorearecentbackupoftheBuenosAiresdatabaseontoyourserver.Youwritequeriestobuildthereport，orderingthedatabytheSurnameandFirstNamecolumns.YoureviewthedataandnoticethatthecustomerlistfromtheBuenosAiresdatabaseissorteddifferently.Thesalesdepartmentneedsthereviseddatawithin15minutesforapresentation.
B.
题目列表

你可能感兴趣的试题

单项选择题

Youworkforacompanythatsellsbooks.YouarecreatingareportforaSQLServer2005database.Thereportwilllistsalesrepresentativesandtheirtotalsalesforthecurrentmonth.Thereportmustincludeonlythosesalesrepresentativeswhomettheirsalesquotaforthecurrentmonth.Themonthlysalesquotais$2，000.Thedateparametersarepassedinvariablesnamed@FromDateand@ToDate.Youneedtocreatethereportsothatitmeetstheserequirements.WhichSQLqueryshouldyouuse？（）
A.SELECTs.AgentName,SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROM SalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentName
B.SELECTs.AgentName，SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateANDo.OrderTotal>=2000GROUPBYs.AgentName
C.SELECTs.AgentName，SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDate AND@ToDateGROUPBYs.AgentNameHAVINGSUM（o.OrderTotal）>=2000
D.SELECTs.AgentName，SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.ordertotal=2000ANDo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentNameHAVINGSUM（o.OrderTotal）>=2000

A.YouarecreatingareportforaSQLServer2005database.Thereportwilllistsalesrepresentativesandtheirtotalsalesforthecurrentmonth.Thereportmustincludeonlythosesalesrepresentativeswhomettheirsalesquotaforthecurrentmonth.Themonthlysalesquotais$2，000.Thedateparametersarepassedinvariablesnamed@FromDateand@ToDate.Youneedtocreatethereportsothatitmeetstheserequirements.WhichSQLqueryshouldyouuse？（）
A.SELECTs.AgentName,SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROM
B.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentName
C.SELECTs.AgentName，SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDateAND@ToDateANDo.OrderTotal>=2000GROUPBYs.AgentName
D.SELECTs.AgentName，SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.OrderDateBETWEEN@FromDate
E.AgentNameHAVINGSUM（o.OrderTotal）>=2000
F.SELECTs.AgentName，SUM（ISNULL（o.OrderTotal，0.00））ASSumOrderTotalFROMSalesAgentsJOINOrderHeaderoONs.AgentID=o.AgentIDWHEREo.ordertotal=2000ANDo.OrderDateBETWEEN@FromDateAND@ToDateGROUPBYs.AgentNameHAVINGSUM（o.OrderTotal）>=2000
单项选择题

ournetworkconsistsofasingleActiveDirectorydomain.YouhaveadomaincontrollerandamemberserverthatrunWindowsServer2008R2.BothserversareconfiguredasDNSservers.ClientcomputersruneitherWindowsXPServicePack3orWindows7.Youhaveastandardprimaryzoneonthedomaincontroller.Thememberserverhostsasecondarycopyofthezone.Youneedtoensurethatonlyauthenticatedusersareallowedtoupdatehost（A）recordsintheDNSzone.Whatshouldyoudofirst（）
A.Onthememberserver，addaconditionalforwarder.
B.Onthememberserver，installActiveDirectoryDomainServices.
C.AddallcomputeraccountstotheDNSUpdateProxygroup.
D.ConvertthestandardprimaryzonetoanActiveDirectory-integratedzone.

A.YouhaveadomaincontrollerandamemberserverthatrunWindowsServer2008R2.BothserversareconfiguredasDNSservers.ClientcomputersruneitherWindowsXPServicePack3orWindows7.Youhaveastandardprimaryzoneonthedomaincontroller.Thememberserverhostsasecondarycopyofthezone.Youneedtoensurethatonlyauthenticatedusersareallowedtoupdatehost（A）recordsintheDNSzone.Whatshouldyoudofirst（）
A.Onthememberserver，addaconditionalforwarder.
B.Onthememberserver，installActiveDirectoryDomainServices.
C.AddallcomputeraccountstotheDNSUpdateProxygroup.
D.ConvertthestandardprimaryzonetoanActiveDirectory-integratedzone.
微信扫码免费搜题