.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

BEST SQL Interview Questions Site

Posted By:      Posted Date: September 25, 2010    Points: 0   Category :Sql Server
 
Hi,
Can anyone tell me the BEST interview Questions site for SQL 2000 and for SQL 2005, BOTH versions.



View Complete Post


More Related Resource Links

C# Interview Questions

  
C# Interview Questions
This is a list of questions I have gathered from other sources and created myself over a period of time from my experience, many of which I felt where incomplete or simply wrong. I have finally taken the time to go through each question and correct them to the best of my ability. However, please feel free to post feedback to challenge, improve, or suggest new questions. I want to thank those of you that have contributed quality questions and corrections thus far.

There are some question in this list that I do not consider to be good questions for an interview. However, they do exist on other lists available on the Internet so I felt compelled to keep them easy access

Redirect to Security Questions if Site accessed from unrecognized computer?

  

Hello,
I'm fairly new to ASP.NET and i'm using the Membership Provider.  I have the need to do similar to some banking sites. Baically I need to track "authorized" computers/ip's for a user.  If the user accesses the site form a recognized Computer/IP then the user is allowed into the app after successful login.  If the computer/IP is not recognized I need to redirect them to a screen to answer the security question setup in fhte Membership Provider.

Has anyone done anything like this or can anyone point me to any examples?  I did a search, but can't seem to find anything.


My idea is to maintain a list of authorized computers/IP addresses and check them on initial login.  If the IP address isn't found I can redirect them to the questions.  My concern is that they are then actually authenticated and could enter any of the site URL's as an authenticated user.

Any suggestions greatly appreciated. 


web services interview questions.

  
Hi ,   I am preparing for ASP.NET web service interview.   Can you please send me the FAQ for web services.???   Thanks in advance.   Thanks Narendraan.K

.NET Interview Questions

  
This all.Net Interview Questions are most useful whoom going to face interview as a .Net Fresher.Who are interesting in .NET Technology.

The .NET Interview Question as the following:

1. ASP.NET Interview Questions
2. VB.NET Interview Questions
3. C#.NET Interview Questions
4. SQL Server Interview Questions
5. XML Interview Questions
6. HTML Interview Questions
7. WebServices Interview Questions:

SSIS interview questions.

  
Could some of the expert(s) list interview questions that might come up when applying for ETL/SSIS developer I or II positions.Thanks

I am about to get this job but SQL interview questions for tomorrow.

  
Hi,
I have a job interview tomorrow, but they may ask me some questions about SQL but very basic troubleshooting knowledge. Rest of other questions are networking or tcp/ip.
Please let me know if you feel like you can help me.
Of course I've looked at google but it seems to be too much information.


1. at least 5 things to check if SQL isn't functioning.
2. where to check the logs.
3. how to perform a simple query to see if the DB is responding.

Thank you a mil.



C# interview questions and answers

  
Hi...
Can u pls tel me
where to find commonly asked C# interview questions and answers?

Hide ribbon, Hide site content/recycle button. Caledar overlay. Document publishing. Other questions

  

I have a 2010 farm operational and working well. I had a few questions.

(1) How to disable ribbons from appearing on the top (for anonymous sites).

(2) When I move the mouse over a tab in the top bar, how do I display a banner. It was easy enough in 2007, but I am not sure in 2010.


(3) I have disabled quick launch. But it still displays all site content and recycle bin. Is there a way to not to show those.


(4) Calendar overlay - Is this to display multiple calendars in one calendar using different colors to differentiate them. But if I had calendars in different site collections, then I guess due to the gallery boundary, I cannot calendars from multiple site collections.


(5) Document publishing - For some reason, this was easier in SPS 2007. I am not able to get it to work in 2010. Basically update a web page dynamically from a word document. Could anyone kindly provide a link. Also, would I be able to update a page in one site collection from a document from another site collection.

(6) Is it possible to move a folder/doc from one document library to another in one site collection (without webdav). Further, can I move a document library from one site collection to another.

Please advise. Sorry if I asked too many questions in the same post. I am newbie and this is my first post.

Thanks.

 

Sharepoint 3.0 questions Domain name routing to sharepoint site

  

Hello,

Wondering if you can help me.  I am setting up a sharepoint site on Server 2008 for my the small company I work for.  Its pretty new to me but I have done things like this in the past.

The domain the server and PC's are in is called ICCSOL.com.  Now I want people to be able to type in ICCSOL.com in their browsers and for it point  to the Sharepoint home page.

At the moment it goes to a page saying "It works"

My sharepoint site install automatically gave it port number 41658.  So it http://iccserver01:41658/default.aspx

I want ICCSol.com to direct to http://iccserver01:41658/default.aspx

Can anyone help me?  Its probably a simple thing to do but I just cant figure it out.

Many thanks in advance.

Gary


Site Quota Questions!

  

I'm looking to alter a Site Quota on MySites on my 2007 environment.

My questions are this:

 How does it impact current users of sites that exceed this limit?

Will it send them an email?

Will it purge some of their data?

Will it not permit those users from adding anything new to their MySite

Also I was wondering if there are any low/no cost third party tools that would run an audit of our MySites to determine how many sites would exceed my planned limit?

Thanks!

Jay


ASP.NET Interview Questions & Answers

  
1.How we implement Web farm and Web Garden concept in ASP.NET?At least give an example ?
A web farm is a multi-server scenario. So we may have a server in each state of US. If the load on one server is in excess then the other servers step in to bear the brunt.
How they bear it is based on various models.
1. RoundRobin. (All servers share load equally)
2. NLB (economical)
3. HLB (expensive but can scale up to 8192 servers)
4. Hybrid (of 2 and 3).
5. CLB (Component load balancer).
A web garden is a multi-processor setup. i.e., a single server (not like the multi server above).
How to implement webfarms in .Net:
Go to web.config and
Here for mode = you have 4 options.
a) Say mode=inproc (non web farm but fast when you have very few customers).
b) Say mode=StateServer (for webfarm)
c) Say mode=SqlServer (for webfarm)
Whether to use option b or c depends on situation. StateServer is faster but SqlServer is more reliable and used for mission critical applications.
How to use webgardens in .Net:
Go to web.config and
Change the false to true. You have one more attribute that is related to webgarden in the same tag called cpuMask.

2.Is there any limit for query string? if means what is the maximum size?.
Servers should be cautious about depending on URI lengths above 255 bytes, because some older client or proxy implementations may not properly support these leng

ASP.NET Interview Questions & Answers

  
1.How we implement Web farm and Web Garden concept in ASP.NET?At least give an example ?
A web farm is a multi-server scenario. So we may have a server in each state of US. If the load on one server is in excess then the other servers step in to bear the brunt.
How they bear it is based on various models.
1. RoundRobin. (All servers share load equally)
2. NLB (economical)
3. HLB (expensive but can scale up to 8192 servers)
4. Hybrid (of 2 and 3).
5. CLB (Component load balancer).
A web garden is a multi-processor setup. i.e., a single server (not like the multi server above).
How to implement webfarms in .Net:
Go to web.config and
Here for mode = you have 4 options.
a) Say mode=inproc (non web farm but fast when you have very few customers).
b) Say mode=StateServer (for webfarm)
c) Say mode=SqlServer (for webfarm)
Whether to use option b or c depends on situation. StateServer is faster but SqlServer is more reliable and used for mission critical applications.
How to use webgardens in .Net:
Go to web.config and
Change the false to true. You have one more attribute that is related to webgarden in the same tag called cpuMask.

2.Is there any limit for query string? if means what is the maximum size?.
Servers should be cautious about depending on URI lengths above 255 bytes, because some older client or proxy implementations may not properly support these leng

Windows and Unix Interview Questions & Answers

  
1.What is the difference between unix and windows?
Unix and Windows use completely different paradigms for run-time loading of code. Before you try to build a module that can be dynamically loaded, be aware of how your system works.

In Unix, a shared object (.so) file contains code to be used by the program, and also the names of functions and data that it expects to find in the program. When the file is joined to the program, all references to those functions and data in the file's code are changed to point to the actual locations in the program where the functions and data are placed in memory. This is basically a link operation.

In Windows, a dynamic-link library (.dll) file has no dangling references. Instead, an access to functions or data goes through a lookup table. So the DLL code does not have to be fixed up at runtime to refer to the program's memory; instead, the code already uses the DLL's lookup table, and the lookup table is modified at runtime to point to the functions and data.

In Unix, there is only one type of library file (.a) which contains code from several object files (.o). During the link step to create a shared object file (.so), the linker may find that it doesn't know where an identifier is defined. The linker will look for it in the object files in the libraries; if it finds it, it will include all the code from that object file.

In

C# Interview Questions & Answers

  
1.What is the name of c#.net compiler?
The name of c# complier is .CSC

2.what is the main difference between delegate and an event in c#?
They aren't the same. An event is an event. A "delegate" assigns a particular event handler to an object instance. Thus, when an object event happens, the proper procedure/method is called.

An example might help. I frequently code things so that a single method is called for all instances of a class. No matter which button is clicked, call my generic "button_click" method. That method will use the event arguments to determine which button was actually clicked.

In order to assign all button click events to a single method, I have to code the delegates.

VB.NET Interview Questions & Answers

  
1.Difference Between Array and array list?
Array is the collection of values of the same data type
>the variables in an array is called array elements
>Array is a reference type data type
>The array structure in System's Memory

Array list is a class .
>when you want to access the elements of an array through its index value location in an array,use an ArrayList.
>The use of the arraylist is an alternative to the use of th array.
>The Methods Of ArrayList class are
1)Add
2)Remove
3)Clear
4)Insert
5)TrimToSize
6)Sort
7)Reverse

2.What is the base class of .net?
System.Object is the base class of .NET

It Supports all classes in the .NET Framework class hierarchy and provides low-level services to derived classes. This is the ultimate superclass of all classes in the .NET Framework; it is the root of the type hierarchy.

ADO.NET Interview Questions & Answers

  
1.What is the difference between ADO and ADO.NET?
ADO:-
--------

-Ado is a connected architecture.
-Ado is supported by Lock Types.

ADO.Net:-
----------
-Ado.Net is a Disconnected Architecture.
-Ado.Net is not supported by Lock Types.

2.What is the difference between data reader & data set
DataReader is connected object and one can process the rows that are returned by query, one at a time. It discards every row after you have gone through it and so it is extremely fast.It contains only read-only data, so no updates are allowed using DataReader objects.

In DataReader you can not get the no. of records directly from RecordSet.This is similar to VB 6, ForwardOnly RecordSet.

Meanwhile DataSet is disconnected object type.It uses XML to store data


Data reader is much faster then dataset if only selection query is their

SQL Server Interview Questions & Answers

  
1.What is DESCRIBE command in SQL Server?What is its purpose?How to use it?
DESCRIBE is not a SQL Server Command. This a command used in ORACLE & MYSQL to display the sturcture of a Table.


2.Explain about reporting services of MYSQL?
This forms the report generating environment whereby a report is generated by the data generated by the client and server. This feature is administered via a web interface. Reports are created in RDL format. They can be designed by Microsoft visual studio.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend