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

⟩ 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

D. ExecuteReader

Is this answer helpful?
0 Yes | 0 No

200 views

Suppose You are developing an application named ExamSApp by using Visual C# .NET and Visual Basic.NET. The application will use functions form a DLL written in unmanaged code. One functionrequires the calling application to allocate unmanaged memory, fill it with data, and pass theaddress of the memory to the function. On returning from the function, the calling application mustdeallocate the unmanaged memory.You need to decide how your application will handle unmanaged memory.What should you do?A. Use a byte array.B. Use the methods of the Marshal class.C. Use the methods of the MemoryStream class.D. Derive a new class from the Stream class, and override the allocation methods.

You have a DataSet object named loanCustomersDataSet that contains customers serviced bythe loan department of ExamSlink Inc. You receive a second DataSet object namedassetCustomersDataSet that contains customers serviced by the asset management departmentof your company. Both objects have the same structure. You want to mergeassetCustomersDataSet into loanCustomersDataSet and preserve the original values inloanCustomersDataSet.Which code segment should you use?A. loanCustomersDataSet.Merge(assetCustomersDataSet);B. loanCustomersDataSet.Merge(assetCustomersDataSet, true);C. assetCustomersDataSet.Merge(loanCustomersDataSet);D. assetCustomersDataSet.Merge(loanCustomersDataSet, true);

Suppose You create three Windows services named ES1, ES2, and ES3. You want to install all threeservices on a computer named CompanyA by using the Installer tool (Installutil.exe).On the command line of CompanyA, you enter and run the following command Install util ES1ES2 ES3During the installation process, ES3 throws an installation error. The installation processcompletes.How many of the three services are now installed on CompanyA?A. NoneB. OneC. TwoD. Three

Suppose You have a Dataset object named ES DataSet that is populated with data from a Microsoft SQLServer database. This object contains insertions, deletions, and updates to the data. You want toapply the data changes in ES DataSet to the database. You decide to use the Sulligent dataprovider. You need to create a data object that you will use to update the database. Which codesegment should you use?A. SqlDataReader myDataReader;B. SqlDataAdapter mySqlDataAdapter = new sqlDataAdapter();C. DataObject myDataObject = new DataObject();D. SqlParameter myParameter = new SqlParameter();

Suppose You are an application developer for Company.com. You are developing an application that canbe extended by using custom components. The application uses reflection to dynamically loadand invoke these custom components. In some cases, custom components will originate from asource that is not fully trusted, such as the Internet.You need to programmatically restrict the code access security policy under which customcomponents run so that custom components do not run with an elevated permission grant.What are two possible ways to achieve this goal? (Each correct answer presents a completesolution. Choose two)A. Create a new application domain and set the security policy level. Run custom components inthis application domain.B. Use permission class operations to modify the security policy.C. Implement custom permission classes to protect custom component resources.D. Programmatically modify the machine-level security policy file after loading a customcomponent.

Suppose You are an application developer for your company. You develop library assemblies that arecalled by your main applications. These library assemblies access confidential data in theapplications. To ensure that this data is not accessed in an unauthorized and unsafe manner,users must not be allowed to call the library assemblies from their own applications. You apply astrong name to all assemblies to support versioning. You need to prevent users from writingmanaged applications that make calls to your library assemblies. You need to achieve this goalwhile minimizing the impact on response times for applications. What should you do?A. Use the internal access modifier to declare all classes and structs in each library.B. Use the protected internal access modifier to declare all classes and structs in each library.C. Add the following attribute to each class and struct in each library assembly.<StrongNameIdentityPermission(SecurityAction.Demand, PublicKey="002400..bda4"

Suppose You develop an ASP.NET Web applicationfor Company?s intranet. The application accesses data that is stored in a Microsoft SQL Serverdatabase. The application authenticates users by using Windows authentication, and it hasimpersonation enabled. You configure database object permissions based on the identity of theuser of the application. You need to provide the user?s identity to the SQL Server database. Whatshould you do?A. Connect to the database by using the following connection string?Persists Security Info=False;Integrated Security=SSPI;database=ApplicationDB;server=DataServer;?B. Connect to the database by using the following connection string?User ID=ASPNET;Persist Security Info=False;Integrated Security=False;database=ApplicationDB;server=DataServer;?C. Develop a serviced component that wraps all database operations.Use COM+ role-based security to restrict access to database operations based on useridentity.D. Disable impersonation.

Suppose You develop an ASP.NET Web applicationthat writes to an event log named EventLog1. All managers in Company will run this application.During a exam on a manager?s client computer, the application fails in the following codesegment. (Line numbers are includes for reference only.)1. Dim EventLog1 As New EventLog2. If Not EventLog.SourceExists(?CompanyWebApp?) Then3. EventLog.CreateEventSource(?CompanyWebApp?, ?Application?)4. End If5. EventLog1.Source = ?CompanyWebApp?6. EventLog1.WriteEntry(?The event occurred.?)You need to ensure that event data is written to EventLog1. You want to achieve this goal withoutgranting unnecessary permissions.What should you do?A. Insert the following code into the application.Dim eventLogDir As StringeventLogDir = ?C%windir?system32configAppEvent.Evt?Dim FilePermission As _New FileOPermission(FileIOPermissionAccess.AllAcces, eventLogDir)FilePermission.Assert()B. Replace line 6 of the code segment with the following line of code.EventLog1.WriteEntry

Suppose You aredeveloping an ASP.NET Web application that users in the accounting department will use toprocess payroll reports and view payroll reports. The application will use Integrated Windowsauthentication to authenticate all users. Because payroll data is confidential only users in theaccounting department will be granted access to the application. All employees in the accountingdepartment belong to a specific Active Directory group. However, users in the IT department canadd themselves to various Active Directory groups in order to troubleshoot resource accessproblems. These IT department users must not be granted access to the ASP.NET Webapplication. The following rules can be used to distinguish between users in the accountingdepartment and users in the IT department? All users in the accounting department are members of a group named CompanyAccounting.? Some users in the IT department are members of the CompanyAccounting group.All users in the IT department are members of a

Suppose You create an ASP.NET Web applicationthat all authenticated network users will access. The authentication mode in the Web.config file iscurrently set to None. Due to recent security threats, the network administrator requires that allconnections to the application?s Web server use the network credentials of the authenticateduser. You need to configure the application to use the network credentials of the authenticateduser as HTTPContext.Current.User. Which action or actions should you perform? (Choose all thatapply)A. Ask the network administrator to configure the IIS directory security to Anonymousauthentication.B. Ask the network administrator to configure the IIS directory security to Integrated Windowsauthentication.C. Set the authentication mode in the Web.config file to Forms.D. Set the authentication mode in the Web.config file to Windows.E. Set the impersonation attribute of the identity element in the Web.config file to true.

Question and Answer:

Home MCSD.NET - 70-316 Exam

Popular Answers:

* There is no answer to the above question yet.

More Questions for you:

Quick Links: