CapGemini ASP.NET, SHAREPOINT, MOSS 2007 Interview Questions Set 2

1. What are the Session State Mechanisms in asp.net
2. What are the different types of Caching
3. What are the differences between Caching and Application
4. What areas have you worked with MOSS 2007
5. What are the objects in Classic ASP
6. How will you communicate between 2 user controls
7. How will you achive fragment caching and pageoutput caching
8. whats the difference between datareader and dataadapter
9. when will you go for datareader and when to dataadapter
10. Does cache supports Application Events
11. What are the different types of Authentications in ASP.NET?
12. What are the different types of Authorization in ASP.NET ?
13. What are the various Expiration methods in Cache ?

www.codecollege.NET

Skelda ASP.NET, Sharepoint, SQL server interview questions

1. What is a masterpage
2. how will you get a value from a master page to the content page
3. what are the differences between UDF and SP
4. Is an UDF Precompiled
5. Explain the Page life cycle
6. what is inetinfo
7. what is aspnet_Wp.exe
8. what is ISAPI filter
9. what is the flow of the control for a page request
10. how you gave anonymous access for a sharepoint site
11. what privileges you gave for anonymous access of a sharepoint site
12. Is there any event called PreInit
13. When is the viewstate information loaded in a page
14. Have you done performance tuning in sql server
15. what does the "Run with privelege" meanin sharepoint?
16. What are the steps for deploying a webpart
17. What is an Bubbled Event ?
18. How will you fire an Event when mouse is moved over a button ?

www.codecollege.NET

Global English .NET ,SQL Interview Questions

1.What are the differences between Abstract Class and Interface
2.What are the differences between View state and session state
3.Write an example for a Singleton Pattern
4.If you create 3 objects for a class which is having a static variable, then when you print the 1st object then what will be the values printed
5.What is polymorphism
6.what is runtime polymorphism and design time polymorphism
7.What are sps , their adv adn uses
8.what is a UDF
9.what are the differences between a SP and UDF
10.What are cursors
11.What are Indexes,types,differences
12.When will you go for which indexd
13.how will u take a db backup and restore
14.what is caching and what are its types
15.is caching common across all users
16.what is an appdomain
17. how will u write code for communication between applications in 2 diff app domains
18.what is remoting
19.what are webservices
20.what is the difference between remoting and webservice
21.what are the types of joins
22.how will you do query tuning
23.how will you check which part of your SP is running slowly
24.what are the config files in asp.net
25.what are the differences between .net and other prog languages
26.what is a CLR
27.what is a managed code
28.what is a dataset
29.what are the differences between a dataset and datareader
30.what are transactions
31.what are the types of transactions
32. what is a Enterprise Library
33. what are the blocks in the Enterprise Library
34. what are the asp.net controls you have used
35. Have you created any Custom Controls
36. What is a delegate
37. What are the types of delegates

www.codecollege.NET

Question Bank for SQL Transaction and Locks Set 1

Transaction and Locks
======================
What is a "Database Transactions "?
What is ACID?
What is "Begin Trans", "Commit Tran", "Rollback Tran" and "Save Tran"?
What are "Checkpoint's" in SQL Server?
What are "Implicit Transactions"?
Is it good to use "Implicit Transactions"?
What is Concurrency?
What kind of problems occurs if we do not implement proper locking strategy?
What are "Dirty reads"?
What are "Unrepeatable reads"?
What are "Phantom rows"?
What are "Lost Updates"?
What are different levels of granularity of locking resources?
What are different types of Locks in SQL Server?
What are different Isolation levels in SQL Server?
If you are using COM+ what "Isolation" level is set by default?
What are "Lock" hints?
What is a "Deadlock" ?
What are the steps you can take to avoid "Deadlocks" ?
How can I know what locks are running on which resource?
Is the Tracsaction handling in Backend better than that in the Front end?

www.codecollege.NET

Question Bank for SQL Database Optimization Set 1

Database Optimization
======================
What are indexes?
How will you tune your queries?
How will you find slow running queries?
What are B-Trees?
I have a table which has lot of inserts, is it a good database design to create indexes on that table?
What are "Table Scan's" and "Index Scan's"?
What are the two types of indexes and explain them in detail?
What is "FillFactor" concept in indexes?
What is the best value for "FillFactor"?
What are "Index statistics"?
How can we see statistics of an index?
How do you reorganize your index, once you find the problem?
What is Fragmentation?
How can we measure Fragmentation?
How can we remove the Fragmented spaces?
What are the criteria you will look in to while selecting an index?
What is "Index Tuning Wizard"?
What is an Execution plan?
How do you see the SQL plan in textual format?
What is nested join, hash join and merge join in SQL Query plan?
What joins are good in what situations?

www.codecollege.NET

Question Bank for SQL Replication Set 1

Replication
=================
Whats the best way to update data between SQL Servers?
What are the scenarios you will need multiple databases with schema?
How will you plan your replication?
What is a publisher, distributor and subscriber in "Replication"?
What is "Push" and "Pull" subscription?
Can a publication support push and pull at one time?
What are different models / types of replication?
What is Snapshot replication?
What are the advantages and disadvantages of using Snapshot replication?
What type of data will qualify for "Snapshot replication"?
What's the actual location where the distributor runs?
Can you explain in detail how exactly "Snapshot Replication" works?
What is merge replication?
How does merge replication works?
What are advantages and disadvantages of Merge replication?
What is conflict resolution in Merge replication?
What is a transactional replication?
Can you explain in detail how transactional replication works?
What are data type concerns during replications?

www.codecollege.NET

Question Bank for SQL Reporting Services set 1

Reporting Services
=================
Can you explain how can we make a simple report in reporting services?
How do I specify stored procedures in Reporting Services?
What is the architecture for "Reporting Services "?
What are data-driven subscriptions?
How does the report manager work in SSRS?
What is Reporting Services
What are the Reporting Services components..?

www.codecollege.NET

Question Bank for Service Broker, Integration Services/DTS Set 1

Service Broker
==============
What do we need Queues?
What is "Asynchronous" communication?
What is SQL Server Service broker?
What are the essential components of SQL Server Service broker?
What is the main purpose of having Conversation Group?
How to implement Service Broker?
How do we encrypt data between Dialogs?

Integration Services/DTS
=========================
What is Integration Services import / export wizard?
What are prime components in Integration Services?
How can we develop a DTS project in Integration Services?

www.codecollege.NET

Question Bank for Notification Services set 1

Notification Services
=====================
What are notification services?
What are basic components of Notification services?
Can you explain architecture of Notification Services?
Which are the two XML files needed for notification services?
What is Nscontrols command?
What are the situations you will use "Notification" Services?

www.codecollege.NET

Question Bank for Data Warehousing/Data Mining set 1

Data Warehousing/Data Mining
============================
What is "Data Warehousing"?
What are Data Marts?
What are Fact tables and Dimension Tables?
What is Snow Flake Schema design in database?
What is ETL process in Data warehousing?
How can we do ETL process in SQL Server?
What is "Data mining"?
Compare "Data mining" and "Data Warehousing"?
What is BCP?
How can we import and export using BCP utility?
What is Bulk Insert?
What is DTS ?
Can you brief about the Data warehouse project you worked on?
What is an OLTP (Online Transaction Processing) System?
What is an OLAP (On-line Analytical processing) system?
What is Conceptual, Logical and Physical model?
What is Data purging?
What is Analysis Services?
What are CUBES?
What are the primary ways to store data in OLAP?
What is META DATA information in Data warehousing projects?
What is multi-dimensional analysis?
What is MDX?
How did you plan your Data ware house project?
What are different deliverables according to phases?
Can you explain how analysis service works?
What are the different problems that "Data mining" can solve?
What are different stages of "Data mining"?
What is Discrete and Continuous data in Data mining world?
What is MODEL is Data mining world?
How are models actually derived?
What is a Decision Tree Algorithm?
Can decision tree be implemented using SQL?
What is Naïve Bayes Algorithm?
Explain clustering algorithm?
Explain in detail Neural Networks?
What is Back propagation in Neural Networks?
What is Time Series algorithm in data mining?
Explain Association algorithm in Data mining?
What is Sequence clustering algorithm?
What are algorithms provided by Microsoft in SQL Server?
How does data mining and data warehousing work together?
What is XMLA ?
What is Discover and Execute in XMLA?

www.codecollege.NET

Question Bank for XML set 1

XML Integration
===============
What is XML?
What is the version information in XML?
What is ROOT element in XML?
If XML does not have closing tag will it work?
Is XML case sensitive?
What's the difference between XML and HTML?
Is XML meant to replace HTML?
Can you explain why your project needed XML?
What is DTD (Document Type definition)?
What is well formed XML?
What is a valid XML?
What is CDATA section in XML?
What is CSS?
What is XSL? or Is XSL similar to CSS?
What is Element and attributes in XML?
Can we define a column as XML?
How do we specify the XML data type as typed or untyped?
How can we create the XSD schema?
How do I insert in to a table which has XSD schema attached to it?
What is maximum size for XML datatype?
What is Xquery?
What are XML indexes?
What are secondary XML indexes?
What is FOR XML in SQL Server?
Can I use FOR XML to generate SCHEMA of a table and how?
What is the OPENXML statement in SQL Server?
I have huge XML file which we want to load in database?
How to call stored procedure using HTTP SOAP?
What is XMLA ?

www.codecollege.NET

Question Bank for ADO.NET

ADO.NET
=======
Which are namespaces for ADO.NET?
Can you give a overview of ADO.NET architecture ?
What are the two fundamental objects in ADO.NET ?
What is difference between dataset and datareader ?
What are major difference between classic ADO and ADO.NET ?
What is the use of connection object ?
What are the methods provided by the command object ?
What is the use of dataadapter ?
What are basic methods of Dataadapter ?
What is Dataset object?
What are the various objects in Dataset ?
How can we connect to Microsoft Access , Foxpro , Oracle etc ?
What's the namespace to connect to SQL Server?
How do we use stored procedure in ADO.NET?
How can we force the connection object to close?
I want to force the datareader to return only schema?
Can we optimize command object when there is only one row?
Which is the best place to store connectionstring ?
What are steps involved to fill a dataset ?
What are the methods provided by the dataset for XML?
How can we save all data from dataset ?
How can we check for changes made to dataset?
How can we add/remove row's in "DataTable" object of "DataSet" ?
What's basic use of "DataView" ?
What's difference between "DataSet" and "DataReader" ?
How can we load multiple tables in a DataSet ?
How can we add relation's between table in a DataSet ?
What's the use of CommandBuilder ?
What's difference between "Optimistic" and "Pessimistic" locking ?
How many way's are there to implement locking in ADO.NET ?
How can we perform transactions in .NET?
What's difference between Dataset. clone and Dataset. copy ?
Whats the difference between Dataset and ADO Recordset?

www.codecollege.NET

Question Bank for .NET and SQL set 2

.NET Integration
=================
What are steps to load a .NET code in SQL SERVER 2005?
How can we drop a assembly from SQL SERVER?
Are changes made to assembly updated automatically in database?
Why do we need to drop assembly for updating changes?
How to see assemblies loaded in SQL Server?
I want to see which files are linked with which assemblies?
Does .NET CLR and SQL SERVER run in different process?
Does .NET controls SQL SERVER or is it vice-versa?
Is SQLCLR configured by default?
How to configure CLR for SQL SERVER?
Is .NET feature loaded by default in SQL Server?
How does SQL Server control .NET run-time?
What's a "SAND BOX" in SQL Server 2005?
What is a application domain?
How are .NET Appdomain allocated in SQL SERVER 2005?
What is Syntax for creating a new assembly in SQL Server 2005?
Do Assemblies loaded in database need actual .NET DLL?
Does SQL Server handle unmanaged resources?
What is Multi-tasking ?
What is Multi-threading ?
What is a Thread ?
Can we have multiple threads in one App domain ?
What is Non-preemptive threading?
What is pre-emptive threading?
Can you explain threading model in SQL Server?
How does .NET and SQL Server thread work?
How are exception in SQLCLR code handled?
Are all .NET libraries allowed in SQL Server?
What is "Hostprotectionattribute" in SQL Server 2005?
How many types of permission level are there for an assembly?
Can you name system tables for .NET assemblies?
Are two version of same assembly allowed in SQL Server?
How are changes made in assembly replicated?
Is it a good practice to drop a assembly for changes?
In one of the projects following steps where done, will it work?
What does Alter assembly with unchecked data signify?
How do I drop an assembly?
Can we creat SQLCLR using .NET framework 1.0?
While creating .NET UDF what checks should be done?
How do you define a function from the .NET assembly?
Can compare between T-SQL and SQLCLR ?
With respect to .NET is SQL SERVER case sensitive?
Does case sensitive rule apply for VB.NET?
Can nested classes be accessed in T-SQL?
Can we have SQLCLR procedure input as array?
Can object datatype be used in SQLCLR?
How's precision handled for decimal datatypes in .NET?
How do we define INPUT and OUTPUT parameters in SQLCLR?
Is it good to use .NET datatypes in SQLCLR?
How to move values from SQL to .NET datatypes?
What is System.Data.SqlServer?
What is SQLContext?
Can you explain essential steps to deploy SQLCLR?
How do create function in SQL Server using .NET?
How do we create trigger using .NET?
How to create User Define Functions using .NET?
How to create User Defined Create aggregates using .NET?
What is Asynchronous support in ADO.NET?
What is MARS support in ADO.NET?
What is SQLbulkcopy object in ADO.NET ?
How to select range of rows using ADO.NET?

www.codecollege.NET

Question Bank for General Database concepts and SQL Server set 1

Database Concepts
=================
What is a database or database management systems (DBMS)?
What's difference between DBMS and RDBMS ?
What are CODD rules?
Is access database a RDBMS?
What's the main difference between ACCESS and SQL SERVER?
What's the difference between MSDE and SQL SERVER 2000?
What is SQL SERVER Express 2005 Edition?
What is SQL Server 2000 Workload Governor?
What's the difference between SQL SERVER 2000 and 2005?
What are E-R diagrams?
How many types of relationship exist in database designing?
Can you explain Fourth Normal Form?
Can you explain Fifth Normal Form?
What's the difference between Fourth and Fifth normal form?
Have you heard about sixth normal form?
What is Extent and Page?
What are the different sections in Page?
What are page splits?
In which files does actually SQL Server store data?
What is Collation in SQL Server?
Can we have a different collation for database and table?


SQL
===
Revisiting basic syntax of SQL?
What are "GRANT" and "REVOKE' statements?
What is Cascade and Restrict in DROP table SQL?
What is a DDL, DML and DCL concept in RDBMS world?
What are different types of joins in SQL?
What is "CROSS JOIN"?
You want to select the first record in a given set of rows?
How do you sort in SQL?
How do you select unique rows using SQL?
Can you name some aggregate function is SQL Server?
What is the default "SORT" order for a SQL?
What is a self-join?
What's the difference between DELETE and TRUNCATE ?
Select addresses which are between '1/1/2004' and '1/4/2004'?
What are Wildcard operators in SQL Server?
What's the difference between "UNION" and "UNION ALL" ?
What are cursors and what are the situations you will use them?
What are the steps to create a cursor?
What are the different Cursor Types?
What are "Global" and "Local" cursors?
What is "Group by" clause?
What is ROLLUP?
What is CUBE?
What is the difference between "HAVING" and "WHERE" clause?
What is "COMPUTE" clause in SQL?
What is "WITH TIES" clause in SQL?
What does "SET ROWCOUNT" syntax achieves?
What is a Sub-Query?
What is "Correlated Subqueries"?
What is "ALL" and "ANY" operator?
What is a "CASE" statement in SQL?
What does COLLATE Keyword in SQL signify?

www.codecollege.NET

Realtime .NET, SQL, Architecture Interview Questions 1

.net
====
1. what is the diff bet arraylist and hashtable
2. Can objects be stored in arraylist
3. Can arraylist be used instead of generics
4. Differenece between hashtable and dictionary

SQL
===
1. what is indexview

2. what are the 3 types of udfs

3. how will you find which join is running slowly

5. how will you handle exceptions in sql
6. how will you show your exceptions to the user


Architecture
============
1. can proxy pattern be used instead of observer pattern
2. can u say an alternate for observer pattern

www.codecollege.NET

Vigna Systems .NET Interview Questions

1.How will you handle an IIS crash
2.have you handled a team
3.how will you handle a team member if he is not satisfied with the schedule
4.What are the advantages of an sp
5.what are the joins you have used
6.what is a self join
7.Have you used webservices
8.Have you worked in .net 2.0
9.what will you do if you have to fetch some 1000 records from db and display it in a datagrid ? What Measures will you take?
10.how will you do exception handling in sql server

www.codecollege.NET

Cognizant .NET and Sharepoint Interview Questions? or CTS .NET and Sharepoint Interview Questions?

1. Explain the Architecture of your project
2. What is a webpart
3. Why are you using Webparts
4.Have you used Personalization in Webparts
5. Can you explain what is a sequence diagram is
6. Can you explain the Life cycle of a page
7. What security mesearues you took for your project
8. How you tested NLB
9. Whats your role in the project
10. How you did unit testing
11.Have you used any unit testing tools? If yes what are they?
12.Have you used AJAX?
13.Explain me the advantages of AJAX
14.on which stage the https certificate verification is done
15.Have you used sharepoint object model?
16.Tell me about Enterprise Library
17.How will you manage the team
18.What optimization techniques you did with your queries
19.Have you written AJAX handlers
20.have you written HTTP handlers
21.Explain me the working of a HTTP handler
22.What design patterns have you used in your project
23.Have you used Facade Design pattern
24.Why Design patterns coming under the heading Methodology
25.Do you know about CatalogPart in a webpart
26.What is a Catalog mode in webpart
27.Have you used AJAX Control tool kit
28.What controls have you used in AJAX Control tool kit
29. Have you done admin , optimization, tuning in SQL
30. What are callbacks? What are the advantages of callbacks/
31. What are the differences between ADO and ADO.NET

www.codecollege.NET

Photon Info Tech .NET Interview Question SET 2

1. What object can be kept in session
2. what is the adv of using custom session
3. what are the GOF DP u have used
4. Explain about NLB
5. What type of session handling you did in NLB
6. Explain Singleton pattern with a program
7. Explain Chain of Responsibility pattern , on which scenarios you use it
8. What are the best practices you followed
9. Explain about SSL implementation in ASP.NET
10. What will you do in unit testing, hav u used any tools
11. HOw will you do a code review
12. Explain How you handled SQL server session in your project
13. What UML notations have you used
14. what is the purpose of encrypting the session

www.codecollege.NET

Applied Development .NET interview Questions

1. what is a webservice and how it
works
2. what is a proxy
3. what is multilevel inheritance and multiple
inheritance
4. what is the use of multilevel inheritance
5. how ajax
works
6. what is mvp
7. what cons u need to take in designing database
table
8. what cons u need to take in writing stored procs
9. what are
indexes ,types
10. if a web app is running slowly how will u increase the
performance
11. how will u check the performance of methods in a class
12.
how will u either turn on or off methods ina class
13. i want to write some
code in all page_loads automatically how, will i do it
14. where(which layer)
will u write your excep hand
15. what is trace and debug
16. how will u
enable or disbale it
17. which design patterns u have used
18. what is
chain of responsibility
19. From which class Textbox control is
inherited
20. what is inner exception20.
21. what will u avoid when
writting sps

CapGemini .NET interview Questions

1. how will you mange sessions in asp.net
2.
what happens to the session when you go between pages
3. what is
autoeventwireup
4. what are infopath forms and how r they published
5.
where do a sharepoint webpart inherit form
6. what are the diff bet the 2
webparts
7. if u have 2 classes a,b and b is derived from a .in both
class's
constructor a mess box is called. If i create an object for B
then
which will be called first
8. how will u check whether the user is
supportig cookies
9. how will u do cookieless sessions
10. explain about
session management
11. when will u go for what type of session
management
12. caching, types, how
13. where are session details stored
between pages
14. when will u go for interface and when will u go for
abstract classes
15. how will u communicate bet user controls
16. how will u deploy a
webpart in sharepoint and what are the
diff