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.
.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
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.
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
http://www.ibm.com/developerworks/webservices/library/ws-wsdl/
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
http://www.ibm.com/developerworks/webservices/library/ws-wsdl/
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.
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
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
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
________________________________________
MOSS
MOSS
1. What are the new features provided in Sharepoint 2007?
2. What are the features of Sharepoint Service Provider ?
3. Difference between Document Library and Form Library?
4. Difference between SpWeb and SPSite?
5. What is Application Definition File?
6.What is Custom List?
2. What are the features of Sharepoint Service Provider ?
3. Difference between Document Library and Form Library?
4. Difference between SpWeb and SPSite?
5. What is Application Definition File?
6.What is Custom List?
7. What is Ghosting and Unghosting?
Ans: If you are creating a master page then it is stored in database.This is called Ghosting( storing in database)
Unghosting: Storing in File System eg: Creating a Theme.
Ans: If you are creating a master page then it is stored in database.This is called Ghosting( storing in database)
Unghosting: Storing in File System eg: Creating a Theme.
8.If you are creating a custom webpart in Visual Studio or Sp Designer what are all the methods present?
9.You applied a theme in CreateChildControls method. And in Render method you applied another theme.Which appears in webpage?
Ans: Theme applied in Render method
Ans: Theme applied in Render method
10.Where Viewstate is created in webpart life cycle?
11. Webpart file extension …
Ans: dwp
Ans: dwp
12. Difference between site template and Site Definition
Ans: Site Template stored as xml file and applied on a single
Site Definition applies on bulk.
Ans: Site Template stored as xml file and applied on a single
Site Definition applies on bulk.
13.What are the steps to follow in creating a Site Definition?
Ans: (doubt)
1 st step: edit webtemp.xml file of sharepointhive/1033/xml/
Here Sharepoint Hive is c:/programfiles/common files/microsoft shared/
2 nd step: paste the custom template in
hive/templates/sitetemplates/
Ans: (doubt)
1 st step: edit webtemp.xml file of sharepointhive/1033/xml/
Here Sharepoint Hive is c:/programfiles/common files/microsoft shared/
2 nd step: paste the custom template in
hive/templates/sitetemplates/
________________________________________
MOSS
1. Difference between WSS & MOSS
2. Webparts and Deployment
3. Difference between Document Library and Picture Library
4. Event Handlers : What is the base Class?
Ans : SPEventReceiverBase
5. Content Type
6. Site Templates
For resuability it is used.
7.How to display a pdf icon when it is uploaded into Document Library?
Ans : Use IFilter of Pdf
8. SP object model
9. Features
10. workflows (out of the box and custom workflows)
11. Deployment of Workflows using WSP, Cab?
Tools to remember:
——————-
1. WSPBuilder (codeplex)
2. BDC Metaman (U2Usite)
3.CAMLQuery Builder(U2U site)
4. Stramit Query Viewer (http://www.codeplex.com/SPCamlViewer)
MOSS
1. Difference between WSS & MOSS
2. Webparts and Deployment
3. Difference between Document Library and Picture Library
4. Event Handlers : What is the base Class?
Ans : SPEventReceiverBase
5. Content Type
6. Site Templates
For resuability it is used.
7.How to display a pdf icon when it is uploaded into Document Library?
Ans : Use IFilter of Pdf
8. SP object model
9. Features
10. workflows (out of the box and custom workflows)
11. Deployment of Workflows using WSP, Cab?
Tools to remember:
——————-
1. WSPBuilder (codeplex)
2. BDC Metaman (U2Usite)
3.CAMLQuery Builder(U2U site)
4. Stramit Query Viewer (http://www.codeplex.com/SPCamlViewer)
