Welcome Visitor to Tech-Interviews

What are few Oracle DDL statements or commands ?

2010-12-26T02:29:00.000-08:00

Below are few DDL commands to create, alter, drop, and rename tables. CREATE TABLE Create a table. Create a table based on another table by using a subquery. ALTER TABLE Modify table structures. Change column widths, change column data types, and add columns. DROP TABLE Remove rows and a table structure. Once executed, this statement cannot be rolled back. RENAME

How to round off decimal to two decimal places in C# ?

2010-12-16T08:49:00.000-08:00

There are 3 ways to round off decimal to two decimal places : 1. Use ToString() double d = 2.445; d.ToString("0.00") Output : 2.45 2. Use Math.Round double d = 2.445; Math.Round(d, 2) Output : 2.44 3. Create a Custom logic method like below : N = 2.445 I want to show "2.45" only. Step a. N*100 + 0.5 = 245 Step b. Divide System.Math.Floor(245) by 100 Step c. The

Question : Which property of the image control should you use to set the descriptive text?

2010-11-06T09:47:00.000-07:00

Answer : AlternateText

2010-11-06T09:36:00.000-07:00

Question : Your development team is working on a large scale .Net project that has multiple assemblies and code files. Before releasing the software as a Beta product, you and the team are testing classes and assemblies for bugs. Most methods have been programmed to just catch the exception without logging any information. You now want to change this so that information about the sequence of

2010-11-06T09:32:00.000-07:00

Question : You and a group of programmers have written a new web application using Visual Studio.NET for a new client. The application tracks charity donations for a well known charity company. Due to the nature of the data it is vital that the server maintains session state even if the Web server crashes and needs to be restarted. Which alternative is it best to use to store session state

Difference between Web farm and Web Garden

2010-09-30T07:30:00.000-07:00

A Web farm allows you to expand a Web Site across multiple servers whereas A Web garden allows you to expand a Web Site across multiple CPUs within a single server.

State why we create custom HTTPModule ?

2010-09-21T11:57:00.000-07:00

Custom HTTPmodule is created for: URL rewriting Compression Specialized authentication and authorization Specialized logging

What is params keyword in C# ?

2010-09-13T12:28:00.000-07:00

The params keyword lets you specify a method parameter that takes a variable number of arguments. No additional parameters are permitted after the params keyword in a method declaration, and only one params keyword is permitted in a method declaration. You can send a comma-separated list of arguments of the type specified in the parameter declaration, or an array of arguments of the specified

What is CharEnumerator in C# ?

2010-09-13T12:18:00.000-07:00

CharEnumerator is an object in C# that can be used to enumerate through all the characters of a string. Sample Code : string str = "santosh"; CharEnumerator chs = str.GetEnumerator(); while(chs.MoveNext()) { Response.Write(chs.Current); }

Difference between RegisterStartUpScript and RegisterClientScriptBlock ?

2010-09-13T12:14:00.000-07:00

RegisterStartUpScript This adds the javascript code at the end of the page before the closing of form tag. RegisterClientScriptBlock This adds the javascript code at the top of the page.

What’s the Difference Between <%# i %> and <%= i %>?

2010-08-29T10:08:00.001-07:00

We can use two constructs to access page-level variables in an ASP.NET web template: data binding syntax Data binding—the hierarchical mapping of control properties to data container values—is specified by the <%# … %> tags. Code located within a <%# … %>code block is only executed when the DataBind method of its parent controlcontainer is invoked. code rendering syntax The <%= … %> code tags

Difference between Static and Instance Constructor ?

2010-08-28T12:54:00.000-07:00

The static constructor executes at most once in a given application domain. The execution of a static constructor is triggered by the first of the following events to occur within an application domain: • An instance of the class type is created. • Any of the static members of the class type are referenced. where as Instance constructor can execute more than once. Instance constructor executes

What is use of private constructor in C# ?

2010-08-28T12:52:00.000-07:00

If a class contains only static members and isn’t intended to be instantiated, adding an empty private instance constructor will prevent instantiation.

State whether the C# code : var z = null; is okay or not ?

2010-08-28T10:41:00.000-07:00

Above code would give an error as null does not have type

Question : State whether below code would give compilation error or not ?

2010-08-28T10:20:00.000-07:00

delegate string Delegate1(object o); delegate object Delegate2(string s); static string Dispaly(object o) { return "Display"; } static void Main(string[] args) { Delegate1 d1 = Display; Delegate2 d2 = Display; } Answer : It will give no compilation error .

Question : State whether below overload methods will give compilation erro or not ?

2010-08-28T08:38:00.000-07:00

Class Test { void SetX(ref int x) { x = 1; } void SetX(out int x) { X = 2; } } Answer : Gives a compilation error. SetX method cannot define overloaded methods that differ only on ref and out

Question : Whether b.x =1 statement in class A and class B is okay or not ?

2010-08-28T08:24:00.000-07:00

public class A { int x; static void SetX(B b) { b.x = 1; } } public class B : A { static void SetX(B b) { b.x = 1; } } Answer : b.x = 1 in Class A is fine. b.x = 1 in Class B gives compilation error Help : As x is private field in Class A hence accessible within Class A As x is private field

Can namespace declaration have access modifiers ?

2010-08-28T08:11:00.000-07:00

No . Namespace declaration cannot have access modifiers. Help Namespaces implicitly have public declared accessibility. No access modifiers and attributes are allowed on namespace declarations

Is static void Main(int a) {...} a valid entry point for C# program ?

2010-08-28T07:58:00.000-07:00

Answer : No Hint : Entry point method is always named Main, and can have one of the following signatures: static void Main() {...} static void Main(string[] args) {...} static int Main() {...} static int Main(string[] args) {...} The entry point may optionally have one formal parameter. The parameter may have any name, but the type of the parameter must be string[].

How to create read only property in C# ?

2010-08-27T10:38:00.000-07:00

A property that has only a get accessor is a read-only property . Example : public int Count { get { return count; } } public int Capacity { get { return items.Length; } }

What are parameter array ? How is parameter array declared ?

2010-08-27T09:38:00.000-07:00

A parameter array allows variable number of arguments to be passed to a method. A parameter array is declared with the params modifier. Only the last parameter of a method can be a parameter array, and the type of a parameter array must be a single-dimensional array type. Example : public static void DisplayEmployeeDetails(string name, params object[] args) {...}

State different types of method parameters in C# ?

2010-08-27T09:24:00.000-07:00

Different type of method parameters in C# are : Value Parameter Reference Parameter Output Parameter

State differences between BasicHttpBinding and WsHttpBinding ?

2010-08-10T09:40:00.001-07:00

Criteria BasicHttpBinding WsHttpBinding Security support This supports the old ASMX style, i.e. WS-BasicProfile 1.1. This exposes web services using WS-* specifications. Compatibility This is aimed for clients who do not have .NET 3.0 installed and it supports wider ranges of clients. Many of the clients like Windows 2000 still do not run .NET 3.0. So older version of .NET can consume this

State few WebService attribute in XML Web Service ?

2010-08-08T11:58:00.000-07:00

Various WebService attributes are : NameSpace : Specifies the namespace, which defaults to "http://tempuri.org", Description : Specifies description text for the XML Web service

What are various webmethod attributes in Web Service ?

2010-08-08T11:49:00.000-07:00

The WebMethod attribute in Web Service provides the following properties: BufferResponse CacheDuration Description EnableSession MessageName TransactionOption