Competitive Examinations, Scholarships
Interview questions for MS SQL Server
Interview questions for MS SQL Server
This one always gets asked. For a while the database interview questions were limited to Oracle and generic database design questions. This is a set of more than a hundred Microsoft SQL Server interview questions. Some questions are open-ended, and some do not have answers.
What is normalization? - Well a relational database is basically composed of tables that contain related data. So the Process of organizing this data into tables is actually referred to as normalization.
What is a Stored Procedure? - Its nothing but a set of T-SQL statements combined to perform a single task of several tasks. Its basically like a Macro so when you invoke the Stored procedure, you actually run a set of statements.
Can you give an example of Stored Procedure? - sp_helpdb , sp_who2, sp_renamedb are a set of system defined stored procedures. We can also have user defined stored procedures which can be called in similar way.
What is a trigger? - Triggers are basically used to implement business rules. Triggers is also similar to stored procedures. The difference is that it can be activated when data is added or edited or deleted from a table in a database.
What is a view? - If we have several tables in a db and we want to view only specific columns from specific tables we can go for views. It would also suffice the needs of security some times allowing specfic users to see only specific columns based on the permission that we can configure on the view. Views also reduce the effort that is required for writing queries to access specific columns every time. (more…)
Interview questions for ASP
Interview questions for ASP
Used by IBM Consulting Services, according to the site visitor.
How many objects are there in ASP?
Which DLL file is needed to be registered for ASP?
If you want to initialize a global variable for an application, which is the right place to declare it? (like form or some other file).
What is diffrence between Server.transfer and Response.redirect.
Is there any inbuilt paging(for example shoping cart. which will show next 10 records without refreshing) in ASP? How will you do pating.
What does Server.MapPath do?
Name at least three methods of response object other than Redirect.
Name at least two methods of response object other than Transfer.
Tell few programming diffrence between ADO and DAO programming. What is state?
How many types of cookies are there?
Tell few steps for optimizing (for speed and resources) ASP page/application .
Interview questions for Web application developers
Interview questions for Web application developers
What is the maximum length of a varchar field in SQL Server?
How do you define an integer in SQL Server?
How do you separate business logic while creating an ASP.NET application?
If there is a calendar control to be included in each page of your application, and we do not intend to use the Microsoft-provided calendar control, how do you develop it? Do you copy and paste the code into each and very page of your application?
How do you debug an ASP.NET application?
How do you deploy an ASP.NET application?
Name a few differences between .NET application and a Java application?
Specify the best ways to store variables so that we can access them in various pages of ASP.NET application?
What are the XML files that are important in developing an ASP.NET application?
What is XSLT and what is its use?
COM/COM+ services and components in .NET
COM/COM+ services and components in .NET
Explain transaction atomicity. We must ensure that the entire transaction is either committed or rolled back.
Explain consistency. We must ensure that the system is always left at the correct state in case of the failure or success of a transaction.
Explain integrity. Ensure data integrity by protecting concurrent transactions from seeing or being adversely affected by each other’s partial and uncommitted results.
Explain durability. Make sure that the system can return to its original state in case of a failure.
Explain object pooling. With object pooling, COM+ creates objects and keeps them in a pool, where they are ready to be used when the next client makes a request. This improves the performance of a server application that hosts the objects that are frequently used but are expensive to create.
Explain JIT activation. The objective of JIT activation is to minimize the amount of time for which an object lives and consumes resources on the server. With JIT activation, the client can hold a reference to an object on the server for a long time, but the server creates the object only when the client calls a method on the object. After the method call is completed, the object is freed and its memory is reclaimed. JIT activation enables applications to scale up as the number of users increases.
Explain role-based security. In the role-based security model, access to parts of an application are granted or denied based on the role to which the callers belong. A role defines which members of a Windows domain are allowed to work with what components, methods, or interfaces. (more…)
.NET and COM interop questions
.NET and COM interop questions
Describe the advantages of writing a managed code application instead of unmanaged one. What’s involved in certain piece of code being managed? The advantages include automatic garbage collection, memory management, support for versioning and security. These advantages are provided through .NET FCL and CLR, while with the unmanaged code similar capabilities had to be implemented through third-party libraries or as a part of the application itself.
Are COM objects managed or unmanaged? Since COM objects were written before .NET, apparently they are unmanaged.
So can a COM object talk to a .NET object? Yes, through Runtime Callable Wrapper (RCW) or PInvoke.
How do you generate an RCW from a COM object? Use the Type Library Import utility shipped with SDK. tlbimp COMobject.dll /out:.NETobject.dll or reference the COM library from Visual Studio in your project.
I can’t import the COM object that I have on my machine. Did you write that object? You can only import your own objects. If you need to use a COM component from another developer, you should obtain a Primary Interop Assembly (PIA) from whoever authored the original object.
How do you call unmanaged methods from your .NET code through PInvoke? Supply a DllImport attribute. Declare the methods in your .NET code as static extern. Do not implement the methods as they are implemented in your unmanaged code, you’re just providing declarations for method signatures. (more…)
ASP.NET questions, part 2
ASP.NET questions, part 2
Whats an assembly? Assemblies are the building blocks of .NET Framework applications; they form the fundamental unit of deployment, version control, reuse, activation scoping, and security permissions. An assembly is a collection of types and resources that are built to work together and form a logical unit of functionality. An assembly provides the common language runtime with the information it needs to be aware of type implementations. To the runtime, a type does not exist outside the context of an assembly.
Describe the difference between inline and code behind - which is best in a loosely coupled solution? ASP.NET supports two modes of page development: Page logic code that is written inside