Suppose You Execute A Query On Your External Oracle Database Named XYZSalesDate By Using AnOleDbCommand Object. The Query Uses The Average Function To Return A Single Value Thatrepresents The Average Price Of Products In The Inventory Table. You Want To Optimize Performancewhen You Execute This Query.To Execute This Query From Your ADO.NET Code, You Need To Use A Method Of TheOleDbCommand Object. Which Method Should You Use?A. ExecuteNonQueryB. ExecuteScalarC. ToStringD. ExecuteReader

⟩ Suppose You execute a query on your external Oracle database named XYZSalesDate by using anOleDbCommand object. The query uses the Average function to return a single value thatrepresents the average price of products in the inventory table. You want to optimize performancewhen you execute this query.To execute this query from your ADO.NET code, you need to use a method of theOleDbCommand object. Which method should you use?A. ExecuteNonQueryB. ExecuteScalarC. ToStringD. ExecuteReader

B. ExecuteScalar

Is this answer helpful?
0 Yes | 0 No

202 views

Suppose You are planning to create a DataSet object named EXDataSet to be used in a bond-tradingapplication.Several developers will need to write code to manipulate EXDataSet, and you want to ensure thatmyDataSet is easy for them to use. You decide to create EXDataSet as a strongly typed data set.Which two actions should you take? (Each correct answer presents part of the solution. Choosetwo)A. Create an XSD schema that defines EXDataSet.B. Create an XDR schema that defines EXDataSet.C. Create a class for EXDataSet that is based on the schema and that inherits from the DataSetclass.D. Create a class for EXDataSet that is based on the schema and that inherits from theXmlSchema class.E. Create a key pair for EXDataSet by using the Strong Name tool (Sn.exe).

Your company frequently receives product information from external vendors in the form of XMLdata.You receive XML document files, an .xdr schema file, and an .xsd schema file.You need to write code that will create a typed DataSet object on the basis of product information.Your code will be used in several Visual studio .NET applications to speed up data processing.You need to create this code as quickly as possible.What should you do?A. Create the code manually.B. Use XmlSerializer.Serialize to generate the code.C. Use the XmlSerializer.Deserialize to generate the code.D. Use the Xml Schema Definition tool (Xsd.exe) to generate the code.

You have a DataSet object named myDataSet. This object contains two DataTable objectsnamed Customers and Orders. Customers has a column named CustomerID, which is unique toeach customer.Orders also has a column named CustomerID. You want to use the GetChildRows method of theDataRow object to get all orders for the current customers.What should you do?A. Add a foreign key constraint on CustomerID of Orders between Customers and Orders.B. Add a data relation to myDataSet on OrderID between Customers and Orders.C. Create a unique constraint on CustomerID of Customers..D. Create a primary key on CustomerID of Customers.

Suppose XYZ Inc. provides a credit card processing application for its customers. The current applicationsupports only computers that run on a Microsoft Windows operating system.You are asked to rewrite the current application as a .NET application. This .NET applicationdoes not need to be backward compatible with the current application.You must ensure that this new application meets the following requirements? Must support asynchronous processing.? Must be able to pass data through firewalls.? Must pass only SOAP-Compliant formatted data validated by using an XSD schema.? Must not be limited to client computers running on a Microsoft operating system.You want to accomplish this task by using the minimum amount of development effort.Which type of .NET application should you use?A. Windows serviceB. XML Web serviceC. Serviced componentD. .NET Remoting object

Suppose You create three Windows services named EXService1, EXService2, and EXService3. You wantto install all three services on a computer named XYZA by using the Installer tool (Installutil.exe).On the command line of XYZA, you enter and run the following commandInstallutil EXService1 EXService2 EXService3During the installation process, EXService3 throws an installation error. The installation processcompletes.How many of the three services are now installed on XYZ1?A. NoneB. OneC. TwoD. Three.

Suppose You create an XML Web service named WeatherService. This service contains a Web methodnamed RetrieveWeather. RetrieveWeather takes as input a city named and returns the currentweather conditions for that city.You need to provide callers of this service with the URL they need to issue an HTTP-GET againstWeatherService.Which URL should you use?A. http//XYZSrv/AppPath/WeatherService.asmx/cityname=somecityB. http//XYZSrv/AppPath/WeatherService.asmx/RetrieveWeather?cityname=somecityC. http//XYZSrv/AppPath/WeatherService/RetreieveWeather.asmx?cityname=somecityD. http//XYZSrv/AppPath/WeatherService/RetrieveWeather?cityname=somecity

You create an XML Web service named TimeService. Each time TimeService is started, it checksfor the existence of an event log named TimeServiceLog. If TimeServiceLog does not exist,TimeService creates it.You discover that when TimeService creates TimeServiceLog, it throws aSystem.Security.SecurityException. The exception includes the following message ?Requestedregistry access is not allowed?. You need to resolve this problem.What should you do?.A. Configure Inetinfo.exe to run as the local administrator user account.B. Create an installer for TimeService, and create the new event log in the installer code.C. Modify the Web.config file by adding an identity element to impersonate the LOGON userspecified by Internet Information Services (IIS).D. Modify the permissions of theHKEY_LOCAL_MACHINESYSTEMCurrentControlSetServicesEventlog registry key to givefull control to the IUSR_computername user account.

Suppose You are creating a .NET Remoting object named PropertyCache. PropertyCache will hold aHashtable object or name/value pairs.A variety of remote client applications will communicate with PropertyCache to set and getproperty values. You need to ensure that properties set by one client application are alsoaccessible to other client applications.Which two actions should you take? (Each correct answer presents part of the solution. Choosetwo)A. Configure PropertyCache to be a client-activated object.B. Configure PropertyCache to be a server-activated Singleton object.C. Configure PropertyCache to be a server-activated SingleCall object.D. Derive the PropertyCache class from MarshalByRefObject and overrideInitializeLifetimeService() to return null.E. Mark the PropertyCache class with the Serializable attribute.Implement the ISponsor interface in the PropertyCache class.F. Implement the ISerializable and ILease interfaces in the PropertyCache class.Implement ILease.CurrentLeaseTime to

Suppose You create an XML Web service named XYZService. You must ensure that this service meetsthe following URL authorization requirements.? Anonymous access must be disabled for XYZService.? An authenticated user named User1 cannot access XYZService.? All other authenticared users can access XYZService.You configure Internet Information Services (IIS) to meet these requirements. You now need toconfigure the authorization section in the Web.config file to properly authorize the users.Which code segment should you use?A. <allow users=?*? />.<deny users=?User1? />B. <allow users=??? /><deny users=?User1? />C. <deny users=?*? /><deny users=?User1? /><allow users=??? />D. <deny users=??? /><deny users=?User1? /><allow users=?*? />

Suppose You are creating an ASP.NET application for XYZ. An earlier version of the application usesActiveX components that are written in Visual Basic 6.0. The new ASP.NET application willcontinue to use the ActiveX components.You want the marshaling of data between your ASP.NET application and the ActiveXcomponents to occur as quickly as possible.Which two actions should you take? (Each correct answer presents part of the solution. Choosetwo)A. Use ODBC binding.B. Use late binding.C. Use early bindingD. Set the AspCompat attribute of the Page directive to true.E. Set the AspCompat attribute of the Page directive to false.

Question and Answer:

Home MCSD.NET - 70-306 Exam

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links: