Asp.net, C#.net, Sql Server Interview Questions

Asp.net 2012 objective questions answers

2013-10-10T17:37:00.000+05:30

Questions

C H A P T E R 1: Introducing ASP.NET 4

Lesson 1: Understanding Web Communications

1. From within an ASP.NET page, you need to run a section of code only if the user has previously loaded the page and is submitting data as part of a form. Which Page object property should you use?

A. IsCallback

B. IsReusable

C. IsValid

D. IsPostBack

2. You are troubleshooting a problem users have when submitting information with a form. The form data does not appear in the web browser’s address bar, but you know the web server is receiving the form data. After capturing the web communications with a sniffer, which type of HTTP request should you examine to see the data the user submitted?

A. PUT

B. CONNECT

C. POST

D. GET

Lesson 2: Creating a Website and Adding New Webpages

1. If you want to create a website on a remote computer running IIS 6.0 that does not have Front Page Server Extensions installed, which website type will you create?

A. Remote HTTP

B. File system

C. FTP

D. Local HTTP

2. Joe created a new website by using Visual Studio 2010, setting the website type to File, and setting the programming language to C#. Later, Joe received an elaborate webpage from his vendor, which consisted of the Vendor.aspx file and the Vendor.aspx.vb code-behind page. What must Joe do to use these files?

A. Joe can simply add the files into the website, because ASP.NET 4 supports websites that have webpages that were programmed with different languages.

B. The Vendor.aspx file will work, but Joe must rewrite the code-behind page by using C#.

C. Both files must be rewritten in C#.

D. Joe must create

Lesson 3: Working with Web Configuration Files

1. You want to make a configuration setting change that will be global to all web and Windows applications on the current computer. Which file do you change?

A. Global.asax

B. Application Web.config

C. Machine.config

D. Root Web.config

2. You want to make a configuration setting change that will affect only the current web application. Which file will you change?

A. The Web.config file that is in the same folder as the Machine.config file

B. The Web.config file in the root of the web application

C. The Machine.config file

D. The Global.asax file

C H A P T E R 2: Using Master Pages, Themes, and Caching

Lesson 1: Using Master Pages

1. Which of the following statements about referencing master page methods and properties is true? (Choose all that apply.)

A. Content pages can reference private properties in the master page.

B. Content pages can reference public properties in the master page.

C. Content pages can reference public methods in the master page.

D. Content pages can reference controls in the master page.

2. You are converting an existing web application to use master pages. To maintain compatibility, you need to read properties from the master page. Which of the following changes are you required to make to ASPX pages to enable them to work with a master page? (Choose all that apply.)

A. Add an @ MasterType declaration.

B. Add an @ Master declaration.

C. Add a MasterPageFile attribute to the @ Page declaration.

D. Add a ContentPlaceHolder control.

3. You need to change the master page of a content page at run time. In which page event should you implement the dynamic changing?

A. Page_Load

B. Page_Render

C. Page_PreRender

D. Page_PreInit

Lesson 2: Using Themes

1. Which of the following theme applications will override an attribute that you specified directly on a control? (Choose all that apply.)

A. A theme specified by using @ Page Theme=”MyTheme”

B. A theme specified by using @ Page StyleSheetTheme=”MyTheme”

C. A element in the Web.config file

D. A element in the Web.config file

2. Which of the following is a valid skin definition inside a skin file?

A. </

asp:Label>

Text="Label">

3. You need to allow users to choose their own themes. In which page event should you specify the user-selected theme?

A. Page_Load

B. Page_Render

C. Page_PreRender

D. Page_PreInit

Lesson 3: Caching

1. You are creating an ASP.NET webpage that displays a list of customers generated by a database query. The user can filter the list so that only customers within a specific state are displayed. You want to maximize the performance of your web application by using page output caching. You want to ensure that users can filter by state, but you are not concerned about displaying updates to the list of customers because the customer list doesn’t change very frequently. Which declarative @ OutputCache attribute should you configure?

A. VaryByParam

B. VaryByHeader

C. SqlDependency

D. VaryByCustom

2. You need to programmatically configure page output caching. Which object would you use?

A. Request

B. Response

C. Application

D. Server

3. You want to cache an object but have it automatically expire in 10 minutes. How can you do this?

A. Directly define the Cache item.

B. Call Cache.Get.

C. Call Cache.Insert.

D. Cast DateTime.Now.AddMinutes(10) to the Cache type.

4. Which tool can you use to create a cache dependency? (Choose all that apply.)

A. An HTTP header

B. A file

C. A time span

D. A registry key

E. Another object in the Cache

C H A P T E R 3: Handling Events and Managing State

Lesson 1: Understanding the ASP.NET Life Cycle and Handling Events

1. In which file should you write code to respond to the Application_Start event?

A. Any ASP.NET server page with an .aspx extension

B. Web.config

C. Global.asax

D. Any ASP.NET server page with an .aspx.vb or .aspx.cs extension

2. You need to log data to a database when a user’s session times out. Which event should you respond to?

A. Application_Start

B. Application_End

C. Session_Start

D. Session_End

3. You notice that clicking a CheckBox does not cause an automatic postback. You need the CheckBox to automatically post back so you can update the webpage based on server-side code. How do you make the CheckBox cause an automatic postback?

A. Set the AutoPostBack property to true.

B. Add JavaScript code to call the ForcePostBack method.

C. Set the PostBackAll property of the webpage to true.

D. Add server-side code to listen for the click event from the client.

4. You need to dynamically create an instance of a TextBox server control in a page. You do not use master pages. Based on the recommended best practices, in which page event would you create the server control to ensure that the view state is properly reconnected to the control on postback?

A. PreInit

B. Init

C. Load

D. PreRender

Lesson 2: Using Client-Side State Management

1. You need to store a user’s user name and password as he or she navigates to different pages on your site, so that you can pass those credentials to the server. Which type of state management should you use?

A. Client-side state management

B. Server-side state management

2. You need to track nonconfidential user preferences when a user visits your site, to minimize additional load on your servers. You distribute requests among multiple web servers, each running a copy of your application. Which type of state management should you use?

A. Client-side state management

B. Server-side state management

3. You are creating an ASP.NET webpage that allows a user to browse information in a database. While the user accesses the page, you need to track search and sorting values. You do not need to store the information between visits to the webpage. Which type of client-side state management would meet your requirements and be the simplest to implement?

A. View state

B. Control state

C. Hidden fields

D. Cookies

E. Query strings

4. You are creating an ASP.NET website with dozens of pages. You want to allow the user to set user preferences and have each page process the preference information. You want the preferences to be remembered between visits, even if the user closes the browser. Which type of client-side state management meets your requirements and is the simplest to implement?

A. View state

B. Control state

C. Hidden fields

D. Cookies

E. Query strings

5. You are creating an ASP.NET web form that searches product inventory and displays items that match the user’s criteria. You want users to be able to bookmark or send search results in email. Which type of client-side state management meets your requirements and is the simplest to implement?

A. View state

B. Control state

C. Hidden fields

D. Cookies

E. Query strings

Lesson 3: Using Server-Side State Management

1. You need to store state data that is accessible to any user who connects to your web application and ensure that it stays in memory. Which collection object should you use?

A. Session

B. Application

C. Cookies

D. ViewState

2. You need to store a value indicating whether a user has been authenticated for your site. This value needs to be available and checked on every user request. Which object should you use?

A. Session

B. Application

C. Cookies

D. ViewState

3. Your application is being deployed in a load-balanced web farm. The load balancer is not set up for user server affinity. Rather, it routes requests to servers based on their load. Your application uses session state. How should you configure the SessionState mode attribute? (Choose all that apply.)

A. StateServer

B. InProc

C. Off

D. SqlServer

C H A P T E R 4: Using Server Controls

Lesson 1: Exploring Common Server Controls

1. To add an HTML server control to a webpage, you must drag an HTML element from the Toolbox to the webpage and then perform which of the following tasks?

A. Add the attribute run="server" to the control element in Source view.

B. Double-click the HTML element to convert it to an HTML server control.

C. Add the attribute runat="server" to the control element in Source view.

D. Select the HTML element in Design view and set the RunAt property to true in the Properties window.

2. You are creating a web form that displays a stock chart. Users can choose from three different sizes for the chart: small, medium, and large. How could you implement the user interface? (Choose all that apply. Each answer forms a complete solution.)

A. Add a RadioButtonList control.

B. Add three RadioButton controls. Set the GroupName property of all controls to ChartSize.

C. Add a CheckBoxList control.

D. Add three CheckBox controls. Set the GroupName property of all controls to ChartSize.

3. You are creating a webpage that has several related buttons, such as Fast Forward, Reverse, Play, Stop, and Pause. You want to create a single event handler that processes the postback from these Button controls. Which of the following should you do to handle the event while writing the least amount of code?

(Choose all that apply. Each answer forms part of the complete solution.)

A. Handle the Button.Command event.

B. Handle the Button.Load event.

C. Define the Button.CommandName property of all controls to PlaybackControl.

D. Define the Button.CommandName property so that each control has a unique value.

Lesson 2: Exploring Specialized Server Controls

1. Which of the following represents the best use of the Table, TableRow, and TableCell controls?

A. Creating and populating a table in Design view

B. Displaying data from a collection in a grid format

C. Creating a table of static images stored in a folder on your site

D. Providing layout for dynamically generated controls

2. Your graphics department just completed an elaborate image that shows the product lines that your company sells. Some of the product line graphics are circular, others are rectangular, and others are complex shapes. You want to use this image as a menu on your website. What is the best way to incorporate the image into your website?

A. Use ImageButton and use the x-coordinate and y-coordinate that are returned when the user clicks to figure out what product line the user clicked.

B. Use the Table, TableRow, and TableCell controls, break the image into pieces that are displayed in the cells, and use the TableCell control’s Click event to identify the product line that was clicked.

C. Use the MultiView control and break up the image into pieces that can be displayed in each View control for each product line. Use the Click event of the View to identify the product line that was clicked.

D. Use an ImageMap control and define hot spot areas for each of the product lines. Use the PostBackValue to identify the product line that was clicked.

3. You are creating a website that collects a lot of data from your users. The data collection spreads over multiple webpages. When the user reaches the last page, you need to gather all of the data, validate it, and save it to the database. You notice that it can be rather difficult to gather the data that is spread over multiple pages, and you want to simplify the development of this application. What control should you use to solve this problem?

A. The View control

B. The TextBox control

C. The Wizard control

D. The Panel control

C H A P T E R 5: Input Validation and Site Navigation

Lesson 1: Performing Input Validation

1. You need to validate a vendor ID entered by a user. The valid vendor IDs exist in a database table. How can you validate this input?

A. Provide a RegularExpressionValidator control and set the ValidationExpression property to /DbLookup{code}.

B. Provide a RangeValidator control, and set the MinValue property to

DbLookup(code) and the MaxVaue property to DbLookup(code).

C. Provide a CustomValidator control with server-side code to search the database for the code.

D. Provide a CompareValidator control and set the compare expression to the name of a server-side function that performs a database lookup of the code.

2. You have created a webpage that contains many controls that are validated by using validation controls. This page also contains Button controls that perform postbacks. You disabled all of the client-side validation and noticed that when you clicked any of the Button controls, the code in the Click event handler was executing even when some of the controls did not have valid data. How can you best solve this problem to ensure that code is not executed when invalid data exists?

A. In the Click event handler method for each of your Button controls, test the webpage’s IsValid property and exit the method if this property is false.

B. In the Load event handler method of the webpage, test the webpage’s IsValid property and exit the method if this property is false.

C. Re-enable the client-side script to disable postback until valid data exists.

D. Add the runat="server" attribute to all of the validation controls.

3. You have created an elaborate webpage that contains many validated controls. You want to provide a detailed message for each validation error, but you don’t have space to provide the detailed message next to each control. What can you do to indicate an error at the control and list the detailed error messages at the top of the webpage?

A. Set the Text property of the validator control to the detailed message and set the ErrorMessage property to an asterisk. Place a ValidationSummary control at the top of the webpage.

B. Set the ErrorMessage property of the validator control to the detailed message and set the Text property to an asterisk. Place a ValidationSummary control at the top of the webpage.

C. Set the ToolTip property of the validator control to the detailed message and set the ErrorMessage property to an asterisk. Place a ValidationSummary control at the top of the webpage.

D. Set the ToolTip property of the validator control to the detailed message and set the Text property to an asterisk. Place a ValidationSummary control at the top of the webpage.

Lesson 2: Performing Site Navigation

1. Which of the following server-side methods of the HttpServerUtility class can be used to navigate to a different webpage without requiring a round trip to the client?

A. Redirect

B. MapPath

C. Transfer

D. UrlDecode

2. Which control automatically uses the Web.sitemap file to display site map information to a user on a webpage?

A. Menu

B. TreeView

C. SiteMapDataSource

D. SiteMapPath

3. You want to provide an Up button for your webpages that users can click to navigate one level higher on your website. You want to define the hyperlink programmatically by using the site map. Which class can you use to access the site map content to accomplish this?

A. SiteMapPath

B. SiteMapDataSource

C. SiteMap

D. HttpServerUtility

Lesson 3: Using Web Parts

1. Which of the following can be a Web Part? (Choose all that apply.)

A. A control based on the Web User Control template

B. A standard Label control

C. A type derived from WebPart

D. A master page

2. Which of the following are required to enable users to change the title of a Web Part?

(Choose all that apply.)

A. LayoutEditorPart

B. EditorZone

C. CatalogZone

D. AppearanceEditorPart

3. You have developed a webpage with many different Web Part components. Some Web Parts are enabled by default, and you want to give the user the ability to display others. Which classes should you use?

(Choose all that apply.)

A. LayoutEditorPart

B. DeclarativeCatalogPart

C. CatalogZone

D. AppearanceEditorPart

4. You have created a Web Part control that prompts the user for personalization information, including his or her name, region, and preferences. You want other controls to be able to read information from this control to customize the information they display. How should you modify your Web Part to enable other Web Parts to connect to it?

A. Create a method that shares the user’s information, and add the ConnectionConsumer attribute to that method.

B. Create a method that shares the user’s information, and add the ConnectionProvider attribute to that method.

C. Create a public property that shares the user’s information, and add the Connection- Consumer attribute to that method.

D. Create a public property that shares the user’s information, and add the Connection- Provider attribute to that method.

C H A P T E R 6: Globalization and Accessibility

Lesson 1: Configuring Globalization and Localization

1. You need to create a webpage that is available in both the default language of English and for users whose browsers identify them as German. Which of the following resource files should you create? (Choose all that apply.)

A. App_LocalResources/Page.aspx.resx.de

B. App_LocalResources/Page.aspx.resx

C. App_LocalResources/Page.aspx.de.resx

D. App_LocalResources/Page.aspx.en.resx

2. What must you do to enable users to select their own language preferences (outside of browser and machine settings)? (Choose all that apply.)

A. Set the Page.Culture property.

B. Set the Page.UICulture property.

C. Override the Page.InitializeCulture method.

D. Override the Page.ReadStringResource method.

3. What markup would you write to explicitly attach the local resource, SubmitButtonText, found inside the application’s collection of MyLocalResources.aspx..resx files, to the Text property of a button control?

C. .

4. You add a global resource with the name Login by using Visual Studio. How can you access that global resource programmatically?

A. Resources.Resource.Login

B. Resources.Resource(“Login”)

C. Resources(“Login”)

D. Resources.Login

Lesson 2: Configuring Accessibility

1. Which Image properties can you define to enable screen readers to describe a picture on a webpage? (Choose all that apply.)

A. AccessKey

B. AlternateText

C. DescriptionUrl

D. ToolTip

2. Which of the following are accessibility features provided by ASP.NET?

(Choose all that apply.)

A. Controls provide properties that enable you to provide hidden descriptions that are available to screen readers.

B. Controls are displayed in high contrast by default.

C. Controls that include a list of links at the top provide hidden links to skip over the links.

D. Controls display text in large font sizes by default.

3. For which of the following guidelines does ASP.NET provide automated testing?

(Choose all that apply.)

A. WCAG Priority 1

B. WCAG Priority 2

C. ADA

D. Access Board Section 508

C H A P T E R 7: Creating Custom Web Controls

Lesson 1: Creating User Controls

1. You want to create a user control that will encapsulate basic data entry functionality and that will be reused across a site. What steps should you take?

(Choose all that apply.)

A. Create an ASPX file and use the @ Register directive at the top of the page to indicate that the markup in the file is a user control.

B. Create a code-behind file for your user control that contains a class that inherits from System.Web.UI.UserControl.

C. Create a code-behind file for your user control that contains a class that inherits from System.Web.UI.Page.

D. Create an ASCX file and use the @ Control directive at the top of the page to indicate that the markup in the file is a user control.

2. You want to consume a user control on a page. However, you do not know the number of instances you want to create. This information will be available at run time. Therefore, you want to dynamically create these controls. Which actions should you take?

(Choose all that apply.)

A. Add the controls by using the Controls.Add method of the page instance.

B. Add the controls by using the Controls.Add method of the form instance.

C. Call the form’s LoadControl method for each control you want to add to the page.

D. Call the page’s LoadControl method for each control you want to add to the page.

3. You want to create a user control to display data, but you are concerned that you don’t know how the webpage designers want to format the data. Also, some of the page designers mention that the format of the data might be different, depending on the webpage. How can you best create a user control to solve this problem?

A. Create a separate user control for each webpage and get each webpage designer to tell you the format to implement in each user control.

B. Create a separate user control for each variation of the format after the webpage designers give you the desired formatting options.

C. Create a templated user control that exposes the data to the webpage designers so they can specify their desired format.

D. Create a user control that simply renders the data and let the webpage designers specify the style properties for the user control.

4. You have two TextBox controls inside your user control. You want to allow a developer using the user control to initialize, read, and modify the Text property of these controls.

What step should you take?

A. Add a constructor to the user control. The constructor should take parameters for each of the TextBox.Text properties. It will then set these parameter values appropriately.

B. Create properties on the user control that allow users to get and set the Text property of each TextBox control.

C. You don't need to do anything. Controls added to a user control, by default, expose their default property.

D. Add code to the Init method of the user control. This code should raise an event.

The page that hosts the control

Lesson 2: Creating Custom Web Server Controls

1. You are creating a custom web server control that extends the features of the ASP.NET Button control. Which steps should you take?

(Choose all that apply.)

A. Ensure that your control inherits from the WebControl class and exposes the base Button control as a property of the class.

B. Ensure that your control inherits directly from the Button control.

C. Override the Render method of your control and be sure to call base.Render (C#) or MyBase.Render (Visual Basic).

D. Override the RenderChildren method of your control and be sure to call base.RenderChildren (C#) or MyBase.RenderChildren (Visual Basic).

2. You want to define a custom image to be displayed in the Toolbox for your custom web server control. Which actions do you take?

(Choose all that apply.)

A. Set a reference to the System.Design namespace.

B. Set a reference to the System.Drawing namespace.

C. Add the ToolboxData attribute to the class.

D. Add the ToolboxBitmap attribute to the class.

3. You are going to create a custom web server control that inherits directly from the WebControl class. Which method do you need to override to get your control to display in the browser window?

A. OnInit

B. Finalize

C. ToString

D. Render

4. You are creating a composite control. You create a class that inherits from the CompositeControl class. What method must be overridden so you can provide code to instantiate the child controls and set their properties?

A. CreateChildControls

B. DataBindChildren

C. CreateControlStyle

D. BuildProfileTree

C H A P T E R 8: Debugging and Deploying

Lesson 1: Debugging Websites

1. You are debugging an application on a test server. You have an issue on a particular page and need to get the error details. You do not want to turn on debugging for the entire site. What actions should you take?

(Choose all that apply.)

A. In the Web.config file, set the debug attribute of the compilation element to true.

B. In the Web.config file, set the debug attribute of the compilation element to false.

C. On the page that throws the error, set the debug attribute of the @ Page directive to true.

D. On the page that throws the error, set the debug attribute of the @ Page directive to false.

2. You are deploying your application to a production environment. You want to redirect users to a default error page if they encounter any unhandled exceptions or HTTP errors within the site. You also want to indicate the user’s requested resource on the error page to help with support calls. What actions should you take?

(Choose all that apply.)

A. Set the redirect attribute of the error element to an error page within your site.

B. Set the defaultRedirect attribute of the customErrors element to an error page within your site.

C. Use the statusCode query string parameter to retrieve the requested resource to display on the error page.

D. Use the aspxerrorpath query string parameter to retrieve the requested resource to display on the error page.

3. You are investigating an error that only occurs when the application is deployed to the development or test server. You need to debug this error remotely. What actions should you take?

(Choose all that apply.)

A. Run the Remote Debugging Monitor (Msvsmon.exe) on the development computer that is doing the debugging. Use the tool to define connection rights to the server you want to debug.

B. Run the Remote Debugging Monitor (Msvsmon.exe) on the server you want to debug. Use the tool to define connection rights for the developer doing the debugging.

C. In Visual Studio, use the Attach To Process dialog box to attach to the ASP.NET process on the server you want to debug.

D. In Visual Studio, use the Attach To Process dialog box to attach to the browser process that is running the application you want to debug.

Lesson 2: Troubleshooting Websites

1. You want to identify which event in the webpage life cycle takes the longest time to execute. How can you accomplish this?

A. Turn on ASP.NET tracing and run the website. After that, review the trace results.

B. To each of the life-cycle events, add a line of code that will print the current time.

C. In the Web.config file, add the monitorTimings attribute and set it to true.

D. In the website properties, turn on the performance monitor and run the website. After that, open the performance monitor to see the timings.

2. You want to run a trace continuously to enable you to quickly look at the 10 most recent traces from anyone using your website, but you are concerned about filling your hard drive with excessive data. Which of the following settings will accomplish your objective?

enabled="false"

requestLimit="10"

pageOutput="false"

traceMode="SortByTime"

localOnly="true"

mostRecent="true"

enabled="true"

requestLimit="10"

pageOutput="true"

traceMode="SortByTime"

localOnly="true"

mostRecent="true"

enabled="true"

requestLimit="10"

pageOutput="false"

traceMode="SortByTime"

localOnly="true"

mostRecent="false"

enabled="true"

requestLimit="10"

pageOutput="false"

traceMode="SortByTime"

localOnly="false"

mostRecent="true"

3. You are interested in examining the data that is posted to the web server. What trace result section can you use to see this information?

A. The Control Tree section

B. The Headers Collection section

C. The Form Collection section

D. The Server Variables section

4. You want to configure ASP.NET health monitoring to log information every time a user fails to log on to the server. Which web event class should you use?

A. WebRequestEvent

B. WebAuditEvent

C. WebApplicationLifetimeEvent

D. WebAuthenticationSuccessAuditEvent

Lesson 3: Deploying Websites

1. You need to add a registry entry to make your application function. In which phase of the Web Setup Project should you add the registry entry?

A. Install

B. Commit

C. Rollback

D. Uninstall

2. You need to make a change to an operating system–related registry entry to make your

application function. You want to ensure that you remove this change if setup is cancelled

or the application is removed from the computer. In which phases should you undo your

registry modification? (Choose all that apply.)

A. Install

B. Commit

C. Rollback

D. Uninstall

3. Which of the following deployment tools enables multiple developers to work on a site

simultaneously while detecting potential versioning conflicts?

A. A setup project

B. A Web Setup Project

C. The Copy Web tool

D. The Publish Web Site tool

4. Which of the following deployment tools has the potential to improve responsiveness

of the website to end users?

A. A setup project

B. A Web Setup Project

C. The Copy Web tool

D. The Publish Web Site tool

C H A P T E R 9: Working with Client-Side Scripting, AJAX, and jQuery

Lesson 1: Creating AJAX-Enabled Web Forms

1. You are working on a long data-entry webpage. In the middle of the page, you need to reach out to the server to get information based on a user’s entry for a related field. However, you do not want the user to lose his or her focus or context within the page. Therefore, you decide to implement this feature by using the ASP.NET AJAX controls. Which of these controls must you add to the page to enable this scenario? (Choose all that apply.)

A. UpdatePanel

B. AsyncPostBackTrigger

C. ScriptManager

D. ScriptManagerProxy

2. You need to write a control that will be used across multiple pages. This control should contain updated sales figures. The control should update itself at various intervals if a containing page is left open. Which controls should you use to enable this scenario?

(Choose all that apply.)

A. UpdatePanel

B. Timer

C. ScriptManager

D. ScriptManagerProxy

3. You have an UpdatePanel control defined on a page. You need to indicate that a specified Button control outside of the UpdatePanel should cause the UpdatePanel to execute an update. What steps should you take?

A. Set the AsyncPostBackTrigger attribute of the UpdatePanel to the ID of the Button control.

B. Set the AsyncPostBackTrigger attribute of the Button control to the ID of the UpdatePanel.

C. Add a Trigger control to the AsyncPostBackTriggers section of the UpdatePanel. Set the ControlID attribute of the Trigger control to the ID of the Button control.

D. Add an AsyncPostBackTrigger control to the Triggers section of the UpdatePanel. Set the ControlID attribute of the AsyncPostBackTrigger control to the ID of the Button control.

4. You are creating a page that contains an UpdatePanel control for partial-page updates. You want to notify the user that the update is processing only if the update takes longer than five seconds. Which actions should you take?

A. Add a second UpdatePanel to the page. Set it to trigger based on the first Update-Panel. Set the contents of this UpdatePanel to read “Processing, please wait.”

B. Add an UpdateProgress control to the UpdatePanel. Set its DisplayAfter attribute to 5,000. Set its ProgressTemplate contents to read “Processing, please wait.”

C. Add a ProgressBar control to the page. Write code on the server to call back to the client synchronously to update the ProgressBar control after five seconds.

D. Create a hidden

tag on your page that contains the text “Processing, please wait.” Set the

tag’s ID to match that of the UpdatePanel. Set the Update-Panel control’s Interval property to 5,000.

Lesson 2: Creating Client Scripts with the Microsoft AJAX Library

1. Which of the following lines of JavaScript registers a new class to be used as an extension to a DOM element?

A. MyNamespace.MyClass.registerClass('MyNamespace.MyClass ', Sys.UI.Control);

B. MyNamespace.MyClass.registerClass('MyNamespace.MyClass ', null, Sys.IDisposable);

C. MyNamespace.MyClass.registerClass('MyNamespace.MyClass ', null);

D. MyNamespace.MyClass.registerClass('MyNamespace.MyClass ', Sys.UI.Behavior);

2. You are creating an AJAX component that does an asynchronous postback to the server for partial-page updates. You need your code to be notified when the partialpage response first comes back from the server. Which event should you intercept?

A. endRequest

B. pageLoading

C. pageLoaded

D. beginRequest

3. You write a JavaScript class that uses the Microsoft AJAX Library. You intend to use the class on a webpage. Which of the following actions should you take?

A. Add the following markup to the section of the ASPX page.

B. Add a ScriptManager control to your page. It automatically finds your .js files in your solution. You can then work with them by using IntelliSense.

C. Add a ScriptManager control to your page. Add a reference nested inside the ScriptManager control that points to your JavaScript file.

D. Use the ScriptReference class in your code-behind file and set its path to the path of your .js file.

4. You want to create a custom control that works as an AJAX client behavior. What action(s) should you take?

(Choose all that apply.)

A. Create a custom server-side class that inherits from a valid System.Web.UI.Control.

B. Create a custom server-side class that inherits from ExtenderControl.

C. Create a custom server-side class that implements the interface IScriptControl.

D. Create a custom server-side class that is decorated with the attribute TargetControlType.

Lesson 3: Implementing jQuery

1. You need to write jQuery code to select the first heading (h2) tag on the page and then slowly fade the item into view. Which line of code would accomplish this task?

A. $("#h21").fadeIn(500);

B. $("h2:first").fadeIn("slow");

C. $(".h2:first").fadeIn(500);

D. $("h2:first").fadeIn(500);

2. You want to execute a function after the DOM has loaded. This function should bind an event code to be run when the user presses a key on the keyboard inside a text box control with the textBox1 ID. Which steps should you take?

(Choose all that apply.)

A. Bind to the keyPress event by using the following code.

$("#textBox1").bind("keyPress", ())

B. Add your event binding code to the $(document).ready() event at the top of your script.

C. Add your event binding code to the $(document).load() event at the top of your script.

D. Bind to the keyPress event by using the following code.

$("#textBox1").add("keyPress", ()).

3. You want to use the .ajax() method to call a web method named GetCityCodes. This web method is contained on the same webpage as the jQuery code and UI markup. This method should be called by using JSON. The web method takes the state parameter. Which of the following calls would you use?

A. $.ajax({

type: "POST",

dataType: "json",

contentType: "application/json",

url: "CityLookup.aspx/GetCityCodes",

data: "{'state': '" + state + "'}",

success: function (data) {

alert(data.d);

B. $.ajax({

type: "POST",

dataType: "json",

contentType: "application/json",

url: "CityLookup.asmx/GetCityCodes",

data: "{'state': '" + state + "'}",

success: function (data) {

alert(state.d);

C. $.ajax({

type: "POST",

dataType: "json",

contentType: "application/json",

url: "CityLookup.aspx/GetCityCodes/" + state,

success: function (data) {

alert(data.d);

D. $.ajax({

type: "POST",

dataType: "json",

contentType: "application/json",

url: "CityLookup.asmx/GetCityCodes",

data: "state:" + state,

success: function (data) {

alert(data.d);

4. You want to use an HTTP GET to retrieve a basic text file from the server by using AJAX and jQuery. Which of the following jQuery methods would you use?

A. $.post()

B. $.getScript()

C. $getJSON()

D. $.get()

C H A P T E R 10: Writing and Working with HTTP Modules and Web Services

Lesson 1: Creating HTTP Handlers and HTTP Modules

1. You need to have ASP.NET dynamically generate Microsoft Word documents when a web browser requests a file ending in a .docx extension. How can you do this?

A. Implement the IPartitionResolver interface.

B. Implement the IHttpModule interface.

C. Implement the IHttpHandler interface.

D. Implement the IHttpHandlerFactory interface.

2. You are writing a custom HTTP handler to be hosted in IIS 7.0 integrated mode. You intend to register the handler by using the Web.config file. What should you do?

(Choose all that apply.)

A. Define an element inside the element.

B. Define an element inside the element.

C. Add a element to the element.

D. Add a element to the element.

3. You want to create custom code that will be run for each request made to a website.

What steps should you take? (Choose all that apply.)

A. Create a class file that implements the IHttpHandler interface.

B. Override the Init method to connect your code to specific application events.

C. Override the ProcessRequest method to wire up your code to specific application events.

D. Create a class file that implements the IHttpModule interface.

Lesson 2: Creating and Consuming XML Web Services

1. You want to create a new web service that will expose multiple methods that are meant to work with user-specific data via a transaction. You decide to use ASP.NET session state to manage the user’s context on the server between web service requests. How should you define your web service?

A. Define a class that inherits from WebServiceAttribute.

B. Define a class that inherits from WebService.

C. Define a class that inherits from WebMethodAttribute.

D. Do not inherit from a base class. Hosting the web service in ASP.NET is sufficient.

2. You want to consume an existing web service from your ASP.NET website. What actions should you take?

(Choose all that apply.)

A. Use the Add Reference dialog box to set a reference to the WSDL file that contains the web service.

B. Use the Add Web Reference dialog box to point to the URL of the web service.

C. Write a method in your website that has the same function signature as your web service. Do not implement this method. Instead, mark it with the WebMethod attribute.

D. Call a proxy class that represents your web service.

3. You need to secure your web service. The service will be accessed over the Internet by multiple systems of different types. Authentication information should be secured. You want to trust only those clients who have been verified as trusted. What type of security should you consider?

A. Windows Basic

B. Windows Digest

C. Client certificates

D. Custom SOAP headers

4. You want to create a web service and call it from client-side script. What actions should you take? (Choose all that apply.)

A. Add the ScriptService attribute to the web service class.

B. Write client-side JavaScript to call your service through a proxy object.

C. Add a ScriptManager class to your webpage. Set the ServiceReference to point to the ASMX web service.

D. Make sure that your webpage and service are in the same domain.

Lesson 3: Creating and Consuming WCF Services

1. You want to write a WCF service application. You intend to host the service in IIS and use ASP.NET to build the service. What type of project should you create?

A. A WCF Service library

B. A WCF service application

C. An ASP.NET Web Service application

D. A Windows Service application

2. You define your own custom type to be used with your WCF service. This type represents a product at your company. It contains several public properties. You want to expose this type so that it can be serialized and defined by an XML Schema Definition (XSD) schema. What actions should you take? (Choose all that apply.)

A. Mark your product class with the DataContract attribute.

B. Mark your product class with the ServiceContract attribute.

C. Mark the public members of your product class with the OperationContract attribute.

D. Mark the public members of your product class with the DataMember attribute.

3. You want to expose a portion of your data model as a service by using OData. Which actions should you take?

(Choose all that apply.)

A. Create a service class that inherits from DataService.

B. Create a service class that inherits from DataContract.

C. Indicate what the service should expose inside the InitializeService method.

D. Indicate what the service should expose inside the Init method.

4. You want to write a client to work with a WCF Data Service. Which actions should you take? (Choose all that apply.)

A. Set a web reference to the data service.

B. Set a service reference to the data service.

C. Create an instance of the data service proxy and pass a URI object to point to the data service.

D. Use the classes in System.Data.Services.Client to write code to access the data exposed by the service.

C H A P T E R 11: Connecting to and Querying Data with LINQ

Lesson 1: Getting Started with LINQ

1. Against which of the following classes can you write a LINQ query?

(Choose all that apply).

A. DataSet

B. List

C. Array

D. Dictionary

2. You need to write a LINQ query to retrieve a list of state hospitals. The results should be sorted and grouped first by county. For each county, the hospitals should be sorted by city. Which of the following LINQ queries would you write?

(Choose all that apply.)

Visual Basic Code

Dim hsQ = From hspt In hospitals

Order By hspt.County, hspt.City

Group hspt By hspt.County Into hsptGroup = Group

C# Code

var hsQ = from hspt in hospitals

orderby hspt.County, hspt.City

group hspt by hspt.County;

Visual Basic Code

Dim hsQ = From hspt In hospitals

Order By hspt.County

Group hspt By hspt.County Into hsptGroup = Group

Order By hsptGroup.Last.City

C# Code

var hsQ = from hspt in hospitals

orderby hspt.County

group hspt by hspt.County into hsptGroup

orderby hsptGroup.Last().City

select hsptGroup;

Visual Basic Code

Dim hsQ = From hspt In hospitals

Order By hspt.County, hspt.City

Group hspt By hspt.County Into hsptGroup = Group

Order By hsptGroup.First.County

C# Code

var hsQ = from hspt in hospitals

orderby hspt.County

group hspt by hspt.County into hsptGroup

orderby hsptGroup.Key

select hsptGroup;

Visual Basic Code

Dim hsQ = From hspt In hospitals

Order By hspt.City

Group hspt By hspt.County Into hsptGroup = Group

Order By hsptGroup.First.County

C# Code

var hsQ = from hspt in hospitals

orderby hspt.City

group hspt by hspt.County into hsptGroup

orderby hsptGroup.First().County

select hsptGroup;

3. You want to merge the results from two separate LINQ queries into a single result set.

How would you accomplish this?

A. Use the ToList method.

B. Use the DataContractJsonSerializer class.

C. Use the XElement class.

D. Use the Concat method.

Lesson 2: LINQ and ADO.NET

1. You need to write a where clause in a LINQ query against a strongly typed DataSet of universities (from u in universities). The where clause should select all universities with more than 10,000 enrolled students. Which where clause would you write?

A. where u.Field("EnrolledStudents") > 10000

B. where u.EnrolledStudents > 10000

C. C#: where u[“EnrolledStudents”] > 10000

Visual Basic: where u(“EnrolledStudents”) > 10000

D. where university.Fields.EnrolledStudents > 10000

2. Which of the following objects represents a LINQ to SQL O/R map?

A. DataSet

B. XElement

C. ObjectContext

D. DataContext

3. You are using an Entity Data Model object. Which of the following lines of code will initialize this object and connect to the associated database?

(Choose all that apply.)

A. MyModel.myEntities model = new MyModel.myEntitites()

B. MyModel.myEntities model = new MyModel.myEntitites(cnnString)

C. PubsModel.pubsEntities pubs = new PubsModel.pubsEntities(

new System.Data.EntityClient.EntityConnection(cnnString))

D. MyModel.myEntities model = new MyModel.myEntitites(

new DataContext(cnnString))

C H A P T E R 12: Working with Data Source Controls and Data-Bound Controls

Lesson 1: Connecting to Data with Data Source Controls

1. You have a data context map for your SQL Server database defined inside a class file. You need to connect to this data by using a data source control. Which data source control should you use?

A. ObjectDataSource

B. SqlDataSource

C. SiteMapDataSource

D. LinqDataSource

2. You are using an ObjectDataSource control to connect to a business object. Which attributes of the control must you set to return data for the data source?

(Choose all that apply.)

A. TypeName

B. SelectMethod

C. DataSourceId

D. SelectParameters

3. You want to apply caching to your data source control to increase your scalability for frequently used data. You want to set the cache to expire every 60 seconds. Which attributes of your data source control should you set to do so?

(Choose all that apply.)

A. CacheTimeout

B. CacheDuration

C. EnableCaching

D. DisableCaching

4. You are using an EntityDataSource control on your page. You need to write a custom query that uses a parameter in the Where clause. What actions should you take?

(Choose all that apply.)

A. Set the command by using the EntitySetName property.

B. Set the command by using the CommandText property.

C. Add a WhereParameters section to the EntityDataSource control markup.

D. Name the parameter by using the @ ParamName construct inside the Where parameter definition.

Lesson 2: Working with Data-Bound Web Server Controls

1. You are creating a data-bound CheckBoxList control that allows a user to select options for configuring a vehicle. When the data is displayed to the user, you want the OptionName column to display. When the data is posted back to the server, you need the OptionId column value for all selected items. Which of the following attribute definitions would you set?

(Choose all that apply.)

A. DataTextField=OptionId

B. DataTextField=OptionName

C. DataValueField=OptionId

D. DataValueField=OptionName

2. You want to display a list of suppliers on a webpage. The supplier list must display 10 suppliers at a time, and you require the ability to edit individual suppliers. Which web control is the best choice for this scenario?

(Choose all that apply.)

A. The DetailsView control

B. The Repeater control

C. The GridView control

D. The ListView control

3. You want to display a list of parts in a master-detail scenario so that users can select apart number from a list that takes a minimum amount of space on the webpage. When the part is selected, a DetailsView control displays all the information about the part and allows users to edit the part. Which web control is the best choice to display the part number list for this scenario?

A. The DropDownList control

B. The RadioButtonList control

C. The FormView control

D. The TextBox control

Lesson 3: Working with ASP.NET Dynamic Data

1. You need to add metadata to your data context object, Invoice, in order to change how invoices are handled by Dynamic Data. Which actions should you take?

(Choose all that apply.)

A. Create a new partial class called Invoice in the App_Code directory.

B. Create a new class called InvoiceAnnotations in the App_Code directory.

C. Decorate the Invoice class with the MetadataTypeAttribute class.

D. Decorate the InvoiceAnnotations class with the ScaffoldTableAttribute class.

2. You have defined a custom field template user control for changing the way an Invoice number is edited. You want to apply this control to the Invoice.Number property. Which data annotation attribute class would you use to do so?

A. MetadataType

B. Display

C. Editable

D. UIHint

3. You want to implement custom business logic that should run when the InvoiceNumber property is modified. What actions should you take?

(Choose all that apply.)

A. Add a CustomValidator control to the DynamicData/FieldTemplates/Integer_Edit.asax file. Set this control to process custom logic to validate an invoice number.

B. Extend the OnInvoiceNumberChanged partial method inside the Invoice partial class to include additional validation logic.

C. Extend the OnInvoiceNumberChanging partial method inside the Invoice partial class to include additional validation logic.

D. If the logic fails, throw a ValidationException instance.

C H A P T E R 13: Implementing User Profiles, Authentication, and Authorization

Lesson 1: Working with User Profiles

1. Which of the following Web.config files correctly enables the website to track the age of anonymous users in a variable of type Int32?

2. You want to create a user profile that uses a custom type as one of the profile properties.

What actions must you take?

(Choose all that apply.)

A. Mark your class as serializable.

B. Set the type attribute of the profile property to the fully qualified name of your custom type.

C. Add the group element to your profile property. Add one element to the group element for each property in your custom type. Set each element’s name to match that of a property in your custom type.

D. Add your custom type in the Machine.config file in the element.

Lesson 2: Using ASP.NET Membership

1. Which of the following controls provides a link for unauthenticated users to log on?

A. Login

B. LoginView

C. LoginStatus

D. LoginName

2. You are creating a web form that enables users to log on to your website. Which of the following ASP.NET controls should you add to the page? (Choose two answers.)

A. Login

B. CreateUserWizard

C. LoginName

D. PasswordRecovery

3. You have created an ASP.NET web form that enables users to create accounts with a CreateUserWizard control. After a new user creates an account, you want to redirect the user to a page listing the rules for your website. To which of the following events should you respond?

A. CreateUserWizard.Unload

B. CreateUserWizard.ContinueButtonClick

C. CreateUserWizard.CreatedUser

D. CreateUserWizard.Init

4. Which of the following Web.config segments correctly requires that all users be authenticated by using a Windows user account?

5. Given the following Web.config file, what permissions do users have to the Marketing folder?

A. Authenticated users and members of the FABRIKAM\Marketing group have access. All other users are denied access.

B. Members of the FABRIKAM\Marketing group have access. All other users are denied access.

C. All users, authenticated and unauthenticated, have access.

D. All users are denied access.

6. You are configuring NTFS file permissions for a website with the following

Web.config file:

For the Marketing folder, you remove all file permissions, and then grant read access to the FABRIKAM\John and FABRIKAM\Sam user accounts. John is a member of the FABRIKAM\Domain Users and FABRIKAM\Marketing groups. Sam is only a member of the FABRIKAM\Domain Users group. Which of the following users can access web

forms located in the Marketing folder?

A. Unauthenticated users

B. Authenticated users

C. Members of the FABRIKAM\Domain Users group

D. FABRIKAM\John

E. FABRIKAM\Sam

C H A P T E R 14: Creating Websites with ASP.NET MVC 2

Lesson 1: Understanding ASP.NET MV C Applications

1. You need to define a page that allows a user to add a new product to the product catalog. You are using ASP.NET MVC and the default structure and routing. Which actions do you take?

(Choose two.)

A. Add a class to the Controllers folder and name it Catalog. Add a method called AddProduct to this class.

B. Add a class to the Controllers folder and name it ProductController. Add a method called Add to this class.

C. Add a new folder to the Views folder and name it Product. Create a view inside this new folder and name it Add.aspx.

D. Add a new folder to the Views folder and name it AddProduct. Create a view inside this new folder and name it Catalog.aspx.

2. You have a very large website and you want to structure the files in this site logically so that they are easier to manage. What actions should you take?

(Choose all that apply.)

A. Create separate area folders inside the Models, Views, and Controllers folders. Name these folders based on the logical grouping in your site folder.

B. Ensure that the RegisterAllAreas() method is defined in your Application_Start method.

C. Create separate Controllers, Models, and Views folders within your area folders.

D. Create an Areas folder and add individual area folders based on the logical grouping in your site.

3. You are writing an action method inside your controller. You want to pass string data to the view and display that data inside the view. You are using the default MVC templates. What actions should you take?

(Choose all that apply.)

A. In your action method, add your string value to the ViewData collection.

B. In the view, reference the string value by using this inline code: <%: object %>.

C. Create a constructor for your view that takes a string value.

D. Reference the string value in the code-behind file for your view, and write it to the page.

Lesson 2: Creating Models, Views, and Controllers

1. You are writing an action method called ShipOrder inside the Order controller. The logic in your code indicates that you need to call the Shipment controller’s Status method as a result of your controller’s action method. Which line of code would accomplish this?

A. return View("Shipment.Status")

B. return redirect("Shipment/Status")

C. Response.Redirect("Shipment.aspx?action=Status")

D. return Content("Shipment.Status")

2. You want to add a default route for when requests are made to your site without the controller and action parameters in the URL. This default route should point to Default.aspx inside the view folder named Main. You create a controller named DefaultController. Which code would you write?

Visual Basic Code

routes.MapRoute("HomePage", _

"{controller}/{action}", _

New With {.controller = "DefaultController", .action = "Default"} )

C# Code

routes.MapRoute("HomePage",

"{controller}/{action}",

new { controller = "DefaultController", action = "Default"} );

Visual Basic Code

routes.MapRoute("Default", _

"{DefaultController}/{Default}", _

New With {.controller = "Default", .action = "Default"} )

C# Code

MapRoute("Default ",

"{ DefaultController }/{ Default }",

new { controller = "Default", action = "Default"} );

Visual Basic Code

routes.MapRoute("Default", _

"{DefaultController}/{Default}")

C# Code

routes.MapRoute("Default ",

"{ DefaultController }/{ Default }");

Visual Basic Code

routes.MapRoute("HomePage", _

"{controller}/{action}", _

New With {.controller = "Default", .action = "Default"} )

C# Code

routes.MapRoute("HomePage",

"{controller}/{action}",

new { controller = "Default", action = "Default"} );

3. You want to create a strongly typed view. What actions should you take? (Choose all that apply.)

A. Mark your @ Page directive to inherit from ViewPage.

B. Add a strong type as a parameter to the View method inside your action method.

C. Add a strong type to the ViewData collection inside your action method.

D. Mark your @ Page directive to include the ViewDataClass attribute and point to an entity inside your model.

What is the difference between 'protected' and 'protected internal'?

2012-04-19T14:38:00.000+05:30

public

The type or member can be accessed by any other code in the same assembly or another assembly that references it.

private
The type or member can be accessed only by code in the same class or struct.

protected
The type or member can be accessed only by code in the same class or struct, or in a class that is derived from that class.

internal
The type or member can be accessed by any code in the same assembly, but not from another assembly.

protected internal
The type or member can be accessed by any code in the assembly in which it is declared, or from within a derived class in another assembly. Access from another assembly must take place within a class declaration that derives from the class in which the protected internal element is declared, and it must take place through an instance of the derived class type.

Find and Delete duplicate records in a table

2012-03-03T15:31:00.002+05:30

Many times you can face problem of duplicate records in table.So How would you identify and delete duplicate records in a table?

For that Firstly check if table has duplicate records or not using below query.

SELECT [FirstName] FROM tblTest GROUP BY [FirstName] HAVING COUNT(*) > 1

Then Delete duplicate records.

DELETE FROM tblTest WHERE ID NOT IN (SELECT MAX(ID) FROM tblTest GROUP BY [FirstName])

Difference between Primary Key and Unique Key

2012-03-03T15:24:00.002+05:30

Both Primary Key and Unique Key gives uniqueness of the column on which they are defined.
By default Unique Key creates a nonclustered index whereas Primary Key creates a clustered index on the column.
A Primary key value cannot be NULL whereas Unique Key allows only one NULL.

Difference between Truncate and Delete in SQL

2012-03-03T15:23:00.002+05:30

Truncate an Delete both are used to delete data from the table. These both command will only delete data of the specified table, they cannot remove the whole table data structure.Both statements delete the data from the table not the structure of the table.

TRUNCATE is a DDL (data definition language) command whereas DELETE is a DML (data manipulation language) command.
You can use WHERE clause(conditions) with DELETE but you can't use WHERE clause with TRUNCATE .
You cann't rollback data in TRUNCATE but in DELETE you can rollback data.TRUNCATE removes(delete) the record permanently.
A trigger doesn’t get fired in case of TRUNCATE whereas Triggers get fired in DELETE command.
If tables which are referenced by one or more FOREIGN KEY constraints then TRUNCATE will not work.
TRUNCATE resets the Identity counter if there is any identity column present in the table where delete not resets the identity counter.
Delete and Truncate both are logged operation.But DELETE is a logged operation on a per row basis and TRUNCATE logs the deallocation of the data pages in which the data exists.
TRUNCATE is faster than DELETE.

Difference between Stored procedure and User Functions

2012-03-03T15:21:00.002+05:30

Fundamental difference between Stored procedure vs User Functions:

Procedure may return none or more values.Function must always return one value either a scalar value or a table.
Procedure have input,output parameters.Functions have only input parameters.
Stored procedures are called independently by EXEC command whereas Functions are called from within SQL statement.
Functions can be called from procedure.Procedures cannot be called from function.
Exception can be handled in Procedure by try-catch block but try-catch block cannot be used in a function.(error-handling)
Transaction management possible in procedure but not in function.

WCF interview

2011-06-22T11:11:00.000+05:30

What are the important principles of SOA (Service oriented Architecture)?
What are ends, contract, address, and bindings?
Which specifications does WCF follow?
What are the main components of WCF?
Explain how Ends, Contract, Address, and Bindings are done in WCF?
What is a service class?
What is a service contract, operation contract and Data Contract?
What are the various ways of hosting a WCF service?
How do we host a WCF service in IIS?
What are the advantages of hosting WCF Services in IIS as compared to self-hosting?
What are the major differences between services and Web services?
What is the difference WCF and Web services?
What are different bindings supported by WCF?
Which are the various programming approaches for WCF?
What is one-way operation?
Can you explain duplex contracts in WCF?
How can we host a service on two different protocols on a single server?
How can we use MSMQ bindings in WCF?
Can you explain transactions in WCF?
What different transaction isolation levels provided in WCF?
Can we do transactions using MSMQ?
Can we have two-way communications in MSMQ?
What are Volatile queues?
What are Dead letter queues?
What is a poison message?

Differences between user controls and custom controls

2011-05-16T12:22:00.000+05:30

This question is asked in every interview happens for asp.net in all organizations, article will help the interviewee (candidate).

Factors	User control	Custom control
Deployment	Designed for single-application scenarios Deployed in the source form (.ascx) along with the source code of the application If the same control needs to be used in more than one application, it introduces redundancy and maintenance problems	Designed so that it can be used by more than one application Deployed either in the application's Bin directory or in the global assembly cache Distributed easily and without problems associated with redundancy and maintenance
Creation	Creation is similar to the way Web Forms pages are created; well-suited for rapid application development (RAD)	Writing involves lots of code because there is no designer support
Content	A much better choice when you need static content within a fixed layout, for example, when you make headers and footers	More suited for when an application requires dynamic content to be displayed; can be reused across an application, for example, for a data bound table control with dynamic rows
Design	Writing doesn't require much application designing because they are authored at design time and mostly contain static data	Writing from scratch requires a good understanding of the control's life cycle and the order in which events execute, which is normally taken care of in user controls

Increase SQL Server performance

2011-04-25T14:38:00.001+05:30

Following are tips which will increase your SQl performance :-

Every index increases the time takes to perform INSERTS, UPDATES and DELETES, so the number of indexes should not be too much. Try to use maximum 4-5 indexes on one table, not more. If you have read-only table, then the number of indexes may be increased.308
Keep your indexes as narrow as possible. This reduces the size of the index and reduces the number of reads required to read the index.
Try to create indexes on columns that have integer values rather than character values.
If you create a composite (multi-column) index, the order of the columns in the key are very important. Try to order the columns in the key as to enhance selectivity, with the most selective columns to the leftmost of the key.
If you want to join several tables, try to create surrogate integer keys for this purpose and create indexes on their columns.
Create surrogate integer primary key (identity for example) if your table will not have many insert operations.
Clustered indexes are more preferable than nonclustered, if you need to select by a range of values or you need to sort results set with GROUP BY or ORDER BY.
If your application will be performing the same query over and over on the same table, consider creating a covering index on the table.
You can use the SQL Server Profiler Create Trace Wizard with "Identify Scans of Large Tables" trace to determine which tables in your database may need indexes. This trace will show which tables are being scanned by queries instead of using an index.

what is Static Constructors?

2011-04-23T14:53:00.000+05:30

Static Constructors: A static constructor is used to initialize any static data, or to perform a particular action that needs performed once only. It is called automatically before the first instance is created or any static members are referenced.

Static constructors have the following properties:

1. A static constructor does not take access modifiers or have parameters.
2. A static constructor is called automatically to initialize the class before the first instance is created or any static members are referenced.
3. A static constructor cannot be called directly.
4. The user has no control on when the static constructor is executed in the program.
5. A typical use of static constructors is when the class is using a log file and the constructor is used to write entries to this file.

Static constructors are also useful when creating wrapper classes for unmanaged code, when the constructor can call the LoadLibrary method.

Datatable Pivots with C# and ASP.NET

2011-04-13T15:58:00.000+05:30

private DataTable PivotTable(DataTable origTable)
        {

                DataTable newTable = new DataTable();
                DataRow dr = null;
                //Add Columns to new Table
                for (int i = 0; i < origTable.Rows.Count; i++)
                    newTable.Columns.Add(origTable.Rows[i][0].ToString(), typeof(String));
                //Execute the Pivot Method
                for (int cols = 0; cols < origTable.Columns.Count; cols++)
                {
                    dr = newTable.NewRow();
                    for (int rows = 0; rows < origTable.Rows.Count; rows++)
                    {
                        if (rows < origTable.Rows.Count)
                        {
                            dr[0] = origTable.Columns[cols].ColumnName; // Add the Column Name in the first Column
                            dr[rows] = origTable.Rows[rows][cols];
                        }
                    }
                    newTable.Rows.Add(dr); //add the DataRow to the new Table rows collection
                }
                newTable.Rows[0].Delete();
                return newTable;
            }

        }

what is endpoint in wcf

2011-04-11T14:58:00.001+05:30

All communication with a Windows Communication Foundation (WCF) service occurs through the endpoints of the service. Endpoints provide clients access to the functionality offered by a WCF service.
Each endpoint consists of four properties:

An address that indicates where the endpoint can be found.
A binding that specifies how a client can communicate with the endpoint.
A contract that identifies the operations available.
A set of behaviors that specify local implementation details of the endpoint.

This topic discusses this endpoint structure and explains how it is represented in the WCF object model.

The Structure of an Endpoint

Each endpoint consists of the following:

Address: The address uniquely identifies the endpoint and tells potential consumers of the service where it is located. It is represented in the WCF object model by the EndpointAddress class. An EndpointAddress class contains:
- A Uri property, which represents the address of the service.
- An Identity property, which represents the security identity of the service and a collection of optional message headers. The optional message headers are used to provide additional and more detailed addressing information to identify or interact with the endpoint.
For more information, see Specifying an Endpoint Address.
Binding: The binding specifies how to communicate with the endpoint. This includes:
- The transport protocol to use (for example, TCP or HTTP).
- The encoding to use for the messages (for example, text or binary).
- The necessary security requirements (for example, SSL or SOAP message security).
For more information, see Windows Communication Foundation Bindings Overview. A binding is represented in the WCF object model by the abstract base class Binding. For most scenarios, users can use one of the system-provided bindings. For more information, see System-Provided Bindings.
Contracts: The contract outlines what functionality the endpoint exposes to the client. A contract specifies:
- What operations can be called by a client.
- The form of the message.
- The type of input parameters or data required to call the operation.
- What type of processing or response message the client can expect.
For more information about defining a contract, see Designing Service Contracts.
Behaviors: You can use endpoint behaviors to customize the local behavior of the service endpoint. Endpoint behaviors achieve this by participating in the process of building a WCF runtime. An example of an endpoint behavior is the ListenUri property, which allows you to specify a different listening address than the SOAP or Web Services Description Language (WSDL) address. For more information, see ClientViaBehavior.

Go to question list

Components of WCF

2011-04-11T14:55:00.003+05:30

The main components of WCF are

1. Service class
2. Hosting environment
3. End point

Go to question list

Difference between web services and WCF

2011-04-11T14:53:00.002+05:30

Windows Communication Foundation (WCF) has an ASP.NET compatibility mode option to enable WCF applications to be programmed and configured like ASP.NET Web services, and mimic their behavior.

Major Difference is That Web Services Use XmlSerializer But WCF Uses
DataContractSerializer which is better in Performance as Compared to XmlSerializer.
Key issues with XmlSerializer to serialize .NET types to XML

* Only Public fields or Properties of .NET types can be translated into XML.
* Only the classes which implement IEnumerable interface.
* Classes that implement the IDictionary interface, such as Hash table can not be serialized.

Important difference between DataContractSerializer and XMLSerializer.

* A practical benefit of the design of the DataContractSerializer is better performance over Xmlserializer.
* XML Serialization does not indicate the which fields or properties of the type are serialized into XML where as DataCotratSerializer Explicitly shows the which fields or properties are serialized into XML.
* The DataContractSerializer can translate the HashTable into XML.

Go to question list

Capgemini Interview Questions WCF, Asp.net, C#.net, Sql server

2011-03-29T15:09:00.001+05:30

Windows Communication Foundation (WCF) questions:
1. Difference between web services and WCF?
2. Components of WCF?
3. What is End Point?
4. WCF Hosting types?
5. How many protocols can be used to access WCF?
6. What is WCF Binding?
7. What is WCF contract?
8. What are the transfer modes available?
Oops questions:
1. Features of Oops?
2. What do you understand by polymorphism and message passing?
3. Difference between overloading and overwriting?
C#.net questions
1. What is the use of private constructor and why to make constructor as private?
2. How to erase unmanaged code objects from memory?
3. What is the use of finalize() method?
4. Why to use GC.Collect() method?
5. How many catch blocks can be created after try block?
6. Can we put try without catch?
7. What is delegate?
8. What are anonymous methods?
9. What will happen if I call 5 times a single anonymous method?
10. What is shared classes?
ASP.net questions
1. What is impersonation?
2. How many securities provided by asp.net?
3. What is assembly?
4. Difference between assembly and namespaces?
5. What is strong name?
6. What do you meant by late binding?
Sql Server
1. Tell me types of logs generated by sql server?
2. How to perform exception handling in sql server?
3. If I had a before update trigger and I am updating trigger and table in same time what will happen?
4. Single line statement for copy the structure of table to another table?

ASP.NET MVC

2011-03-04T15:17:00.000+05:30

Model: The model contains the core information for an application. This includes the data and validation rules as well as data access and aggregation logic.
View: The view encapsulates the presentation of the application, and in ASP.NET this is typically the HTML markup.
Controller: The controller contains the control-flow logic. It interacts with the Model and Views to control the flow of information and execution of the application.
This separation of entity allows you to have nimbleness and flexibility in building and maintaining your application. For example, by separating the views, you can iterate on the appearance of your application without touching on any of the core business logic. You can also separate work by role, so that, for example designers can work on the views, while developers work on the model.
ASP.NET MVC brings the power of this development paradigm to ASP.NET development, allowing you to use your .NET development skills to build MVC applications.
It gives you
Complete control over your HTML Markup
Enables rich AJAX and jQuery integration
Allows you to create SEO-friendly URLs for your site
Makes Test Driven Development (TDD) easy

Value Converters

2011-02-24T18:13:00.001+05:30

Introduction

If you want to databind two properties that have incompatible types, you need a piece of code in between, that converts the value from source to target type and back. This piece of code is called ValueConverter. A value converter is a class, that implements the simple interface IValueConverter with the two methods object Convert(object value) and object ConvertBack(object value).
How to implement a ValueConverter

WPF already provides a few value converts, but you will soon need to implement your own converts. To do this, add a class to your project and call it [SourceType]To[TargetType]Converter. This is a common naming for value converters. Make it public and implement the IValueConverter interface. That's all you need to do.

public class BoolToVisibilityConverter : IValueConverter
{
public object Convert(object value, Type targetType,
object parameter, CultureInfo culture)
{
// Do the conversion from bool to visibility
}

public object ConvertBack(object value, Type targetType,
object parameter, CultureInfo culture)
{
// Do the conversion from visibility to bool
}
}

How to use a ValueConverter in XAML

First thing you need to do is to map the namespace of your converter to a XAML namespace. Then you can create an instance of a value converter in the resources of the view and give it a name. Then you can reference it by using {StaticResource}

Simplify the usage of ValueConvers

If you want to use a normal ValueConverter in XAML, you have to add an instance of it to the resources and reference it by using a key. This is cumbersome, because and the key is typically just the name of the converter.

A simple and cool trick is to derive value converters from MarkupExtension. This way you can create and use it in the binding like this: Text={Binding Time, Converter={x:MyConverter}}, and that is quite cool!

public abstract class BaseConverter : MarkupExtension
{
public override object ProvideValue(IServiceProvider serviceProvider)
{
return this;
}
}

StringFormat Converter

The StringFormatConverter is a useful converter to control the format of an implicit string conversion of an object (e.g. if you bind a DateTime to a TextBlock ).

[ValueConversion(typeof(object), typeof(string))]
public class StringFormatConverter : BaseConverter, IValueConverter
{
public object Convert(object value, Type targetType, object parameter,
System.Globalization.CultureInfo culture)
{
string format = parameter as string;
if (!string.IsNullOrEmpty(format))
{
return string.Format(culture, format, value);
}
else
{
return value.ToString();
}

public object ConvertBack(object value, Type targetType, object parameter,
System.Globalization.CultureInfo culture)
{
return null;
}
}
http://www.wpftutorial.net/ValueConverters.html

Data Binding (WPF)

2011-02-24T18:03:00.000+05:30

Windows Presentation Foundation (WPF) data binding provides a simple and consistent way for applications to present and interact with data. Elements can be bound to data from a variety of data sources in the form of common language runtime (CLR) objects and XML. ContentControls such as Button and ItemsControls such as ListBox and ListView have built-in functionality to enable flexible styling of single data items or collections of data items. Sort, filter, and group views can be generated on top of the data.

The data binding functionality in WPF has several advantages over traditional models, including a broad range of properties that inherently support data binding, flexible UI representation of data, and clean separation of business logic from UI.

This topic first discusses concepts fundamental to WPF data binding and then goes into the usage of the Binding class and other features of data binding.

This topic contains the following sections.

MSDN

Routed Event

2011-02-24T17:10:00.001+05:30

Functional definition: A routed event is a type of event that can invoke handlers on multiple listeners in an element tree, rather than just on the object that raised the event.
Implementation definition: A routed event is a CLR event that is backed by an instance of the RoutedEvent class and is processed by the Windows Presentation Foundation (WPF) event system.
A typical WPF application contains many elements. Whether created in code or declared in XAML, these elements exist in an element tree relationship to each other. The event route can travel in one of two directions depending on the event definition, but generally the route travels from the source element and then "bubbles" upward through the element tree until it reaches the element tree root (typically a page or a window). This bubbling concept might be familiar to you if you have worked with the DHTML object model previously.
http://msdn.microsoft.com/en-us/library/ms742806.aspx#prerequisites

.Net Generics

2011-02-24T15:42:00.000+05:30

Introduction

Generics are a new feature in version 2.0 of the C# language and the common language runtime (CLR)

When you use generics, you are creating classes or methods that use a generic type, rather than a specific type. For example, rather than creating a type-specific, you could create a reusable List class using generics.

How is that different from the ArrayList class?

The System.Collection.ArrayList can be used with any objectn, but no type checking is done when objects are passed to methods. You have to manually cast objects back to our type when retrieving; which makes the code harder.

Using the code

I have a Strongly Typed Class named "StudentList" and Generics Class named "MyCustomList" and a sample class named "Student".

"StudentList" class can accepts only Type of Student Objects for its Methods.

But "MyCustomList" Class can Accept any Type u specifying in "T"

Consider the class Student

Student dhas = new Student("Manick", "Dhas", 22);
Student raj = new Student("Sundar", "Raj", 32);

///Using a custom strongly typed StudentList

StudentList mc = new StudentList();
mc.Add(dhas);
mc.Add(raj);

Response.Write("Using a custom strongly typed StudentList
");
foreach (Student s in mc)
{
Response.Write("First Name : " + s.FirstName + "
");
Response.Write("Last Name : " + s.LastName + "
");
Response.Write("Age : " + s.Age + "

");
}
We can use MyCustomList like..

///Creating a list of Student objects using my custom generics

MyCustomList student = new MyCustomList();
student.Add(dhas);
student.Add(raj);

Response.Write("
Using a list of Student objects using my custom generics
");
foreach (Student s in student)
{
Response.Write("First Name : " + s.FirstName + "
");
Response.Write("Last Name : " + s.LastName + "
");
Response.Write("Age : " + s.Age + "

");
}

///Creating a list of Student objects using my custom generics

MyCustomList intlist = new MyCustomList();
intlist.Add(1);
intlist.Add(2);

Response.Write("
Using a list of String values using my custom generics
");
foreach (int i in intlist)
{
Response.Write("Index : " + i.ToString() + "
");
}

///Creating a list of Student objects using my custom generics

MyCustomList strlist = new MyCustomList();
strlist.Add("One");
strlist.Add("Two");

Response.Write("
Using a list of int values using my custom generics
");
foreach (string str in strlist)
{
Response.Write("Index : " + str + "
");
}

Execute multiple SELECT statements using a SqlCommand object and read the results using a SqlDataReader object

2010-06-28T23:14:00.000+05:30

using System;
using System.Data;
using System.Data.SqlClient;

class ExecuteSelect
{
  public static void Main()
  {
    SqlConnection mySqlConnection =new SqlConnection("server=(local)\\SQLEXPRESS;database=MyDatabase; Integrated Security=SSPI;");

    SqlCommand mySqlCommand = mySqlConnection.CreateCommand();

    mySqlCommand.CommandText =
      "SELECT TOP 5 ProductID, ProductName " +
      "FROM Products " +
      "ORDER BY ProductID;" +
      "SELECT TOP 3 CustomerID, CompanyName " +
      "FROM Customers " +
      "ORDER BY CustomerID;" +
      "SELECT TOP 6 OrderID, CustomerID " +
      "FROM Orders " +
      "ORDER BY OrderID;";

    mySqlConnection.Open();

    SqlDataReader mySqlDataReader = mySqlCommand.ExecuteReader();

    do
    {
      while (mySqlDataReader.Read())
      {
        Console.WriteLine("mySqlDataReader[0] = " + mySqlDataReader[0]);
        Console.WriteLine("mySqlDataReader[1] = " + mySqlDataReader[1]);
      }
      Console.WriteLine("");
    } while (mySqlDataReader.NextResult());

    mySqlDataReader.Close();
    mySqlConnection.Close();
  }
}

Overloading Web Services

2010-04-22T12:11:00.003+05:30

The procedure to solve this problem is very easy. Start each method with a Web Method attribute. Add Description property to add a description of web method and MessageName property to change web method name.

namespace TestOverloadingWebService

{

[WebService(Namespace = "http://tempuri.org/", Description=" <b> Function

overloading in Web Services </b>")]

public class OverloadingInWebService : System.Web.Services.WebService

{

[WebMethod(MessageName = "AddInt", Description = "Add two integer

Value", EnableSession = true)]

public int Add(int a, int b)

{

return (a + b);

}

[WebMethod(MessageName = "AddFloat", Description = "Add two Float

Value", EnableSession = true)]

public float Add(float a, float b)

{

return (a + b);

}

JavaScript Question

2010-04-20T18:43:00.001+05:30

Q1. Disbable back option by java script

Ans. window.history.go(+1) use in java script;

or
onunload =window.history.go(-1) in body tag

Q2. we can disable the right click using

Ans. <body oncontextmenu="return false">
</body>

Virtual functions in C#

2010-04-20T18:41:00.003+05:30

Virtual functions implement the concept of polymorphism are the same as in C# except that you use the override keyword with the virtual function implementaion in the child class. The parent class uses the same virtual keyword. Every class that overrides the virtual method will use the override keyword.

class Shape
{
   public virtual void Draw()
   {
       Console.WriteLine("Shape.Draw") ;
   }
}

class Rectangle : Shape
{
   public override void Draw()
   {
       Console.WriteLine("Rectangle.Draw");
   }
}