Inverview at HCL

Technical Interview.

Q: What is difference between abstract factory and factory method.
A: http://dotnetacademy.blogspot.com/2011/04/what-is-difference-between-abstract_20.html

Q: What is difference between static class and singleton.
A: http://dotnetacademy.blogspot.com/2011/04/what-is-difference-between-static-class.html

Q: What is difference between abstract class and interface.
A: Difference between interface and interface

Q: Explain situation where will you use abstract class and where will you use interface.
A: Its totally up to requirements. If we have requirement where we just wants particular function to be implemented by other classes then we will place them in interface and in a situation where we have some function which we wants to be implemented by child classes as well as we wants to provide a common functionality to particular function which may/may not be overridden in child class then we will use abstract class.
http://dotnetacademy.blogspot.com/2011/04/what-is-difference-between-abstract.html

Q: Is is possible to change access specifier of members of interface.
A: http://dotnetacademy.blogspot.com/2011/04/is-it-possible-to-change-access.html

Q: What is practical use of Encapsulation in programming.
A: http://dotnetacademy.blogspot.com/2011/04/encapsulation.html

Q: Where is practical implementation of Observer design patterns in .NET framework.
A: http://dotnetacademy.blogspot.com/2011/04/observer-design-pattern-in-net.html

Q: Where the .NET framework has implemented singleton design pattern in its classes.

Q: Provide example where you implemented singleton design pattens in your application.
A: I have personally used it in a class which i made to upload file using FTP to remote server in asp.net. i have created a circular linked list in a singleton class and those classes which wants to send/ftp their files takes its object and add their file to that link list and don't wait for completion of FTP process. its up to my singleton class to do FTP.
so to maintain single linked list (but it can easily maintained by taking a static variable/object but i found singleton class more appropriate for it.

Q: Abstract factory implements factory method or factory methods implements abstract factory.
A: Factory Method implements Abstract Factory means every factory method separately becomes abstract factory.

Q: How will you use component build in vb6/c++ in .NET
A: http://dotnetacademy.blogspot.com/2011/04/how-to-use-vb6-components-in-net.html

Q: What is MVP.
A: http://msdn.microsoft.com/en-us/magazine/cc188690.aspx

Q: What is WCF.
A: http://msdn.microsoft.com/en-us/library/ms731082.aspx

Q: Write a code to create a WCF service.
A: http://www.codeproject.com/KB/WCF/wcf_bohansen.aspx

Q: What is end points in WCF services.
A: http://dotnetacademy.blogspot.com/2011/04/what-is-endpoints-in-wcf-service.html

Q: What is procedure to deploy WCF Service.
A: http://msdn.microsoft.com/en-us/library/aa751792.aspx
http://msdn.microsoft.com/en-us/library/ms733766.aspx

Q: How will you define end points in WCF services.
A: http://msdn.microsoft.com/en-us/library/ms733749.aspx

Q: How will you use WCF services in you application.
A: http://weblogs.asp.net/sreejukg/archive/2010/12/15/create-and-consume-wcf-service-using-visual-studio-2010.aspx
http://dotnetslackers.com/articles/ajax/JSON-EnabledWCFServicesInASPNET35.aspx

Q: What all attributes you will require to set for a function to expose it as a service method in WCF.
A: you will have to set attribute [OperationContract] on every method which you wants to expose as service contract method in WCF service.

Q: Provide difference between WCF and Web services.
A: Mainly-

Web Services

1.It Can be accessed only over HTTP
2.It works in stateless environment

WCF

WCF is flexible because its services can be hosted in different types of applications. The following lists several common scenarios for hosting WCF services:
IIS
WAS
Self-hosting
Managed Windows Service

http://www.dotnetspider.com/forum/136895-what-e-difference-between-WCF-webservices-an.aspx


Q: What is SOAP.
A: http://www.soapuser.com/basics1.html
http://webdesign.about.com/od/soap/a/what-is-xml-soap.htm

Q: What is SOA.
A: http://www.whatissoa.com/
http://www.service-architecture.com/web-services/articles/service-oriented_architecture_soa_definition.html

Q: How will you create web service for SOA.
A: http://www.service-architecture.com/
http://www.oracle.com/technetwork/articles/javase/soa-142870.html

Q: Do web service expose contract.
A: Using WSDL web service exposes contract.
http://static.springsource.org/spring-ws/site/reference/html/why-contract-first.html

Q: What is WSDL.
A: http://dotnetacademy.blogspot.com/2011/04/what-is-wsdl.html

Q: What is DISCO.
A: http://dotnetacademy.blogspot.com/2011/04/what-is-disco.html

Q: How to generate WSDL of a web service.
A: using WSDL.EXE
http://msdn.microsoft.com/en-us/library/7h3ystb6(v=vs.71).aspx

Q: How will you generate DISCO of web service using command prompt.
A: http://msdn.microsoft.com/en-us/magazine/cc302073.aspx

Q: What is AJAX and how will you use it in your web page (write code).
A: http://webdesign.about.com/od/ajax/a/aa101705.htm

Q: What all new features introduces in versions of SQL server:
SQL server 7 -> SQL Server 2000 -> SQL Server 2005 -> SQL Server 2008
A: SQL server 7 and Sql Server 2000:
http://itknowledgeexchange.techtarget.com/itanswers/difference-between-sql-server-7-sql-server-2000/

SQL Server 2000 and SQL Server 2005:
Main:
1)In Sql server 2005 Enterprise Manager and Query analizer combined as a sqlserver Management Studio
2)CLR Integration Avaliable
3)XmL Integartion
4)SSIS ,SSRS,SSAS services Avliable
5)DatabaseMail Integration,Notifications Services Avilable
6)Mirroring Avliable
http://www.sqlservercentral.com/articles/Administration/2988/

SQL Server 2005 and SQL Server 2008:
Main:
Transparent Data Encryption. The ability to encrypt an entire database.
Backup Encryption. Executed at backup time to prevent tampering.
External Key Management. Storing Keys separate from the data.
Auditing. Monitoring of data access.
Data Compression. Fact Table size reduction and improved performance.
Resource Governor. Restrict users or groups from consuming high levels or resources.
Hot Plug CPU. Add CPUs on the fly.
Performance Studio. Collection of performance monitoring tools.
Installation improvements. Disk images and service pack uninstall options.
Dynamic Development. New ADO and Visual Studio options as well as Dot Net 3.
Entity Data Services. Line Of Business (LOB) framework and Entity Query Language (eSQL)
LINQ. Development query language for access multiple types of data such as SQL and XML.
Data Synchronizing. Development of frequently disconnected applications.
Large UDT. No size restriction on UDT.
Dates and Times. New data types: Date, Time, Date Time Offset.
File Stream. New data type VarBinary(Max) FileStream for managing binary data.
Table Value Parameters. The ability to pass an entire table to a stored procedure.
Spatial Data. Data type for storing Latitude, Longitude, and GPS entries.
Full Text Search. Native Indexes, thesaurus as metadata, and backup ability.
SQL Server Integration Service. Improved multiprocessor support and faster lookups.
MERGE. TSQL command combining Insert, Update, and Delete.
SQL Server Analysis Server. Stack improvements, faster block computations.
SQL Server Reporting Server. Improved memory management and better rendering.
Microsoft Office 2007. Use OFFICE as an SSRS template. SSRS to WORD.
SQL 200 Support Ends. Mainstream Support for SQL 2000 is coming to an end.
http://www.microsoft.com/sqlserver/2008/en/us/default.aspx

Q: What is difference between Stored Procedure and Functions.
A: http://chiragrdarji.wordpress.com/2007/04/17/difference-between-user-defined-function-and-stored-procedure/

Q: How many type of functions available in sql server.
A: http://chiragrdarji.wordpress.com/2007/04/17/difference-between-user-defined-function-and-stored-procedure/

Q: Write queries how will you use all type of functions in sql server.
A: http://chiragrdarji.wordpress.com/2007/04/17/difference-between-user-defined-function-and-stored-procedure/

Q: Create a Non-Normalized table and then convert it to all normalization forms one by one.
A: Please do this by your self. you will find it very interesting.

Q: Write a code to load a XML file and retrieve its attribute's value using XPath.
A: Step 1. add System.XML namespace.
Step 2. load xml document.
Step 3. Use XPath to fatch relevant record.
like:- xdoc.selectsinglenode("//rootelementname/childelementname[@attributename ='']);
http://www.w3schools.com/xpath/xpath_syntax.asp

http://www.java2s.com/Code/ASP/XML/ReadinganXMLFileandattributesusingXmlReader.htm



Q: What is difference between Delegates and Events.
A: http://www.ikriv.com/en/prog/info/dotnet/Delegates.html
http://blog.monstuff.com/archives/000040.html

Q: What is HLD and LLD.
A: High Level Design (HLD) is the overall system design - covering the system architecture and database design. It describes the relation between various modules and functions of the system. data flow, flow charts and data structures are covered under HLD.

Low Level Design (LLD) is like detailing the HLD. It defines the actual logic for each and every component of the system. Class diagrams with all the methods and relation between classes comes under LLD. Programs specs are covered under LLD.

Q: What is difference between association and aggregation.
A: http://javapapers.com/oops/association-aggregation-composition-abstraction-generalization-realization-dependency/

Q: What is difference between aggregation and composition.
A: http://javapapers.com/oops/association-aggregation-composition-abstraction-generalization-realization-dependency/

PM Round

Q: How will you distribute work in your team. what parameters you will take care while doing so.
A: Please don't accept from me to answer this question :). its totally up to u.

Q: What all things will you take care while interacting with client.
A:

Q: If you are to make your team, work for late night then how will you make them ready.
A: Please don't accept from me to answer this question :)

Q: What is use of XML.
A: As xml is text based language so it becomes platform independent, which makes it best to be used in data transfer on web. it has functionality to define rules in DTD/XSD and we can easily apply and parse it against rules. Its easy to query using XPath. We can create business specific tags and also encrypt it.
http://webdesign.about.com/od/xml/a/aa060401a.htm

Q: What all documentation are needed in CMM level 5 company.
A: will answer it after joining CMM 5 :)

Q: How will you design HLD and LLD.
A: wait for next 2 Weeks :)

Q: How many people were there in your team which you have handled.
A: Well its about u.

Compiled By Rajesh Rolen