4+ years experience Microsoft interview question for .net

4+ years experience  Microsoft interview question for .net

1. Difference between BasicHttpBinding and WSHttpBinding.

2.Types of contracts in WCF: Message Contract, DataContract,FaultContract,ServiceContract.

3.How do you handle exceptions in WCF and How do you pass these exception details to client.

4.What is MessageContract?

5.What is JQuery and have you worked on it.

6.Various ways of Hosting a WCF service:Self-hosting,Hosting in WPF application,Hosting in a Windows Service,Hosting in IIS, Hosting in Windows Activation Service.

UGADI Quiz

1. Ugadi marks the beginning of the Telugu New Year.

2. It is the most important festival for Hindus, which falls on Chaitra Shuddha Prathipade (Padya).

3. Yugadi (start of new year) is based on Bhaskara II lunar calculations in 12th century.

4.It starts on the first new moon after Sun crosses equator from south to north on Spring Equinox.

5. The eating of a specific mixture of six tastes called Ugadi Pachhadi in telugu symbolizes the fact that life is a mixture of different experiences (sadness, happiness, anger, fear, disgust, surprise), which should be accepted together and with equanimity through the New Year.

4. Ugadi in Marathi/Konkani is called as Gudi Padwa.

5. Ugadi in Sindhi is called as Cheti Chand.

6. Ugadi in Punjabi is called as Vaisakhi.

7. Ugadi in Bengali is called as

8. Ugadi in Tamil is called as Puthandu.

9. Ugadi in Malayalee is called as Vishu.

10. Maharshi VedaVyasa describes this event with the words "Yesmin Krishno divamvyataha, Tasmat eeva pratipannam Kaliyugam".

Deloitte .Net Interview Questions

Latest January 2013 Deloitte .Net Interview Questions for experience of 3+years

This requirement was for Delloitte for ASP.NET,C#,Javascript dotnet requirement. Below are the questions asked:
1. Application Blocks.
2.How the exception is logged in your project.
3.Indexed Views
4.Have you done performance tuning in sql server database.
5. Visual Studio 2010 features.
6. Is it possible to write DML statements in views?
7.abc in wcf?
8.Difference between: Web services and WCF.
9.Difference between caching and application variable
10.Types of index in sql server
11.Difference between dataset and datareader
12.How to write class in javascript
13.which is fast: executing linq query or executing query using store procedure.
14. Which interface is implemented by using block?

Wishing all a very happy and prosperous new year 2013.

Have goals and make then happen. Take the responsibility of your life and live your way.

Give me a stock clerk with a goal and I'll give you a man who will make history. Give me a man with no goals and I'll give you a stock clerk.
Very well said by : Penney, J. C. (James Cash)

Convert string to date in c#

Below code shows how to convert string which has both date and time to just the date without time.

string value = "1/1/2012 08:15:20";

DateTime dt = Convert.ToDateTime(value);
string shortDate = dt.ToShortDateString();

Accenture WPF interview questions for Experienced people

Accenture WPF Interview Questions

1. What is PRISM,CAL
2.Difference between MVVM,MVC patterns
3. Difference between Delegates and Events..How it is used in WPF Application.
4.How the MVVM Pattern works. Which layer talks to which layer like Model to viewmodel or vice versa?
5.Difference between SQL Server 2008,2005, 2008 R2.
6.Have you worked on SSRS?
7.You have hosted a WCF Service on one machine and if it goes down..what will you do?
8.2 dropdownlists in your WPF User control. if you change value in one dropdown how it will get notified to other dropdown?
9.Different ways of hosting/deploying wpf apps?
10. Have you used WPF Usercontrols in your WPF applications.
11.What are attached properties in WPF?
12. What are Dependency properties in WPF? Give an example where you have used in your project.
13.Is WPF a webbased or windows based application?

Oracle Tips

1. To Implement Sleep function in PL/SQL use below code:
DBMS_LOCK.SLEEP(10);
2. Any arithmetic expression containing a null always evaluates to null.
3. ORDER BY clause does not affect the ROWNUM of each row.
4. Why use RowNum
a. To limit the no. of rows returned by a query.
b. To assign unique value to each row of a table.
5. In order to create an empty copy of an existing table use below query:

CREATE TABLE new_table AS
SELECT * FROM old_table

WHERE 1 = 2;

6.How to remove duplicate rows from a table ?

SQL> Select the Duplicates with:

SELECT ename,empid FROM Emp
GROUP BY ename, empid

HAVING COUNT(*) > 1;

Delete the Duplicates with

DELETE from Emp A
WHERE (A.ename,A.empid) IN
    (SELECT B.ename, B.empid FROM Emp B

      WHERE A.ename= B.enameAND A.empid = B.empid
       AND A.rowid > B.rowid);