Interview Questions Answers.ORG

Interviewer And Interviewee Guide

MCSD.NET - 70-315 Exam Interview Question:

Download Interview PDF

Next ❯❮ Previous

You create an ASP.NET application that produces sales reports for the XYZ corporation.
The sales data is stored in a Microsoft SQL Server database that is used for transaction
processing. The application consists of complex Transact-SQL statements.
Many users report that the report generation is taking longer to run each day. You need to
improve response times.
What are two possible ways to achieve this goal? (Each correct answer presents a complete
solution. Choose two)
A. Use an OleDbDataAdapter indexes exist on the SQL Server tables.
B. Ensure that appropriate indexes exist in the SQL Server tables.
C. Rewrite your SQL statements to use aliases for all table names.
D. Rewrite your direct SQL statements as stored procedures and call the stored procedures from
your application.
E. Configure queries to run in the security context of the user who is running the query.

Submitted by: Administrator

B. Ensure that appropriate indexes exist in the SQL Server tables.
D. Rewrite your direct SQL statements as stored procedures and call the stored procedures from
your application.
Submitted by: Administrator

Next ❯❮ Previous

Read Online MCSD.NET - 70-315 Exam Job Interview Questions And Answers

Top MCSD.NET - 70-315 Exam Questions

☺

Suppose You are configuring your ASP.NET application XYZApp. XYZApp will be hosted on a Web server
that also runs other applications.
You want to prevent any changes to the configuration settings of your application after the
application is deployed.
What should you do?
A. In the Machine.config file, set the allowOverride attribute in the location element to False.
Make no other changes to the Machine.config file.
B. In the Web.config file, set the allowOverride attribute in the location element to False.
Make no other changes to the Web.config file.
C. In the Machine.config file, set the allowOverride attribute in the appSettings element to False.
Make no other changes to the Machine.config file.
D. In the Web.config file, set the allowOverride attribute in the appSettings element to False.
Make not other changes to the Web.config file.

☺

Suppose You are creating an ASP.NET page for XYZ. The page uses string concatenation to gather data
from multiple e-mail messages and format the data for display on the page.
You want to ensure that the page displays as quickly as possible.
What should you do?
A. Write code that uses the Append method of the StringBuilder object.
B. Write code that uses the Substring method of the String object.
C. Write code that uses the Concat method of the String object.
D. Write code that uses the plus-sign (+) operator to concatenate the strings.

☺

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

☺

You are creating an ASP.NET application to track XYZ sales orders. The application uses an
ADO.NET DataSet object that contains two DataTable objects. One table is named Orders, and
the other table is named OrderDetails. The application displays data from the Orders table in a list
box. You want the order details for an order to be displayed in a grid when a user selects the
order in the list box. You want to modify these objects to enable your code to find all the order
details for the selected order.
What should you do?
A. Add a DataRelation object to the Relations collection of the DataSet object.
B. Use the DataSet.Merge method to connect the Orders table and the OrderDetails table to each
other.
C. Add a ForeignKeyConstraint to the OrderDetails table.
D. Add a keyref constraint to the DataSet schema.

☺

Suppose You are creating an ASP.NET page for selling movie tickets. Users select a region, and then they
select from a list of cities in that region. The site displays the names and locations of movie
theaters in the city selected by the user.
Your company, XYZ Brothers, maintains a list of theaters in a database table that includes the
city, name, and street address of each theater. You want to minimize the time required to retrieve
and display the list of theater names after a user selects the region and city.
What should you do?
A. Modify the connection string to add the packet size property and set its values to 8192.
B. Add the following directive to the page:
OutputCache VaryByParam=?city?
C. Add the following directive to the page:
OutputCache VaryByControl=?region;city?
D. Modify the connection string to keep your database?s connection pool as small as possible.

Top Certifications Categories

☺	CCIE Certification Interview Questions.

☺	CCSP Certification Interview Questions.

☺	AFMC Interview Questions.

☺	Sun Certification Interview Questions.

☺	CCDA Certification Interview Questions.

SHARE

Disclaimer

Interview Questions Answers .ORG is responsive and optimized web portal for individuals to get preparation for their job interviews, learning and training. Content at Interview Questions Answers .ORG might be simplified to improve our users experience. We constantly review our content to avoid errors and copyright violations, but we cannot warrant full correctness of all the content. While using this site, you agree to have read and accepted our terms of use, cookie and privacy policy. Copyright 2007-2024 by Interview Questions Answers .ORG All Rights Reserved.