Infosys .Net Interview Questions

 (.NET, Database and General)

.NET

1. How do you rate yourself in .NET

2. What is caching and types of caching

Ans)

Caching is generally used to catch frequently accessed data. When u used catching at that time u have to depend upon certain variables like parameter, time etc..But one demerit of using catching is if you are using dynamic page at that time u will unable to get the updated value.

Types of catching:

1. Data caching

2. Output caching

3. Fragment caching

To improve the performance of Web Pages, we use Caching. Caching is a used for persisting data in memory for immediate access to the program calls. It has three types:

1. Output Caching – to fetch page level information and data

2. Fragment Caching – to cache the information of a structure level.

3. Application Caching – to fetch the information of an application.

3. What does VS.NET contains

VS.NET contains .NET FRAMEWORK includes Window form, Web Form, Base Class Libraries, CLR and Console applications

4. What is JIT, what are types of JITS and their purpose?

Ans)  just-in-time compilation (JIT), also known as dynamic translation,

is a technique for improving the runtime performance of a computer program.

Computer programs had two modes of runtime operation,

Either interpreted or static compilation

Interpreted code is translated from a high-level language to a machine code continuously during every execution, whereas statically compiled code is translated into machine code before execution, and only requires this translation once.

JIT compilers represent a hybrid approach, with translation occurring continuously, as with interpreters, but with caching of translated code to minimize performance degradation. It also offers other advantages over statically compiled code at development time, such as handling of late-bound data types and the ability to enforce security guarantees.

The role of the Just-In-Time (JIT) compilers is to convert the bytecode into native code or the machine code for execution. The execution speed of the application is increased by the use of the JIT compilers. There are many JIT compilers. Some of them are LaTTe, Cacao, IBM JIT compiler, OpenJIT, SableJIT, and shuJIT.

5. What is SOAP, UDDI and WSDL

SOAP

A framework for exchanging XML-based information in a network SOAP used to be an acronym: Simple Object Access Protocol “This is no longer the case.” (it is neither simple nor has anything to do with objects) the currently most hyped XML/Web service technology mostly just hot air…

WSDL (Web Service Description Language)

An XML-based language for describing network services WSDL descriptions of capabilities and locations of services like an interface description language for Web services communication using SOAP or direct HTTP

UDDI (Universal Description, Discovery, and Integration)

provides a registry mechanism for clients and servers to find each other uses SOAP for communication

6. What are clr? cts? cls?

All .NET applications are compiled into Intermediate Language code (MSIL). When executed on the CLR, MSIL is converted into native machine code specific to the operating platform. This process is done by a Just In Time (JIT) compiler. The code executed by the CLR is called as

Managed Code. This code is type safe and thoroughly checked by the CLR before being deployed. The .NET runtime also provides a facility to incorporate existing COM components

and DLL’s into a .NET application. Code that is not controlled by the CLR is called Unmanaged Code.

The .NET Framework is further comprised of Common Type System (CTS) and Common Language Specification (CLS). The CTS defines the common data types used by .NET programming languages. The CTS tells you how to represent characters and numbers in a program. The CLS represents the guidelines defined by for the .NET Framework. These specifications are normally used by the compiler developers and are available for all languages, which target the .NET Framework.

Database

6. What is dataset?

Datasets store a copy of data from the database tables. However, Datasets cannot directly retrieve data from Databases. DataAdapters are used to link Databases with DataSets. If we see diagrammatically,

DataSets < —– DataAdapters < —– DataProviders  Backup And Restore

5. Steps in webpart deployment. You have no full permissions to deploy in production server. Then how you will deploy?

Ans:Use wssv22 tool. It creates wsp file( Site package file)

6. What are event hanlders in Sharepoint

Ans: Synchronous (ing) and Asynchronous (ed)  doubt

7.In Sp what are event receivers?

Ans: SPList and SpItem.

What is their base class?

Ans: SpReceiverBase

8. Security Permissions in SP?

Ans:   Contributor

Reader

Full Control

9. What are content types?

In Document Library we have Add Columns , Multi Columns

Ans: check this box  “Calculated Fields” .. I= PNR/100

10. You created Doc Library Templates and HR created another library,Different people in organisation created different documents.

One should not view documents created by others. How to achieve this in Sharepoint?

Ans: Sharepoint Service Provider -> Audience And Targetting

11. What is the use of BDC ?

12. Are you using any tools for BDC? How to configure?

13. You want to get Top 5 records from a database and to display in a webpart. What is the out of box feature available in Sharepoint?

Ans: Use content query webpart.

It expects database connection and asks for a select query.

There write like this: select top 5 …

14. Infopath and Excel Services

15. Out of Box different workflow types?

Ans:  Sequential

State

Steps : Initialize

Modify

Associate

16.What are the steps  in creating a custom them?

Ans: hive/templates/themes

2 ways: 1. Theme gallery

2. In visual studio how u will or SPDesigner

Site.ApplyThemes

17. Namespace for webpart

18. UpdateChanges()

19.

Document Library  Form Library

excel ,ppt and word ms office + Infopath form + xml files

+ flat files.(This is one of advantages in SPp 2007)

20.  What is in SP collaboration portal ?

a. What is Publish , Unpublish , Report Center and Search Center.

b. Team Site

21. Different between 2007 and 2010?

22.  STSADM  tool is SP Administration. How to create a batch file?

23. What is Server Farm?

WebFront End Server , Application Server

Microsoft Capacity Planner, SqlServer

24.  Performance Tools in SP

a. Search Tools

b. How to do crawling in content management

25. Sp + Silverlight

26. Difference WSS 3.0 and SP 2007

27. Difference Site Collection and Sites

28. Backup Restore tools

29. Webpart tools (See: Litware site)

30. How many Shared Providers can be created?

Ans: No Limit

31.  Form Authentication

Ans:Create SqlProvider .Use SQLRegIIS.exe

32. Single Sign On

33. Any difference in time between SPTime and Sqlserver?

Ans: Yes

34.  Write CAML sample query