Database Interview qustions

1.what is corralative subquery ?

NUnit

http://www.c-sharpcorner.com/UploadFile/ianstallings/Testing.NetComponentsUsingNUnit12232005035544AM/Testing.NetComponentsUsingNUnit.aspx

http://en.wikipedia.org/wiki/Unit_test

http://msdn.microsoft.com/en-US/library/ms182517(v=VS.80).aspx

http://msdn.microsoft.com/en-us/library/ms182526(VS.80).aspx

http://ondotnet.com/pub/a/dotnet/2005/07/18/unittesting_2005.html

http://www.geekzone.co.nz/vs2008/4819

http://site.typemock.com/aspnet_unit_testing_page/2009/9/11/unit-testing-aspnet.html

http://www.c-sharpcorner.com/UploadFile/satisharveti/VS2008UnitTesting08132008055534AM/VS2008UnitTesting.aspx

http://visualstudiomagazine.com/articles/2008/06/01/test-your-net-35-apps.aspx

http://msdn.microsoft.com/en-us/library/ms379625(VS.80).aspx

http://www.c-sharpcorner.com/UploadFile/satisharveti/VS2008UnitTesting408192008082932AM/VS2008UnitTesting4.aspx

http://www.codeproject.com/KB/testing/UnitTestVS2008.aspx

http://msdn.microsoft.com/en-us/library/ms182515(VS.90).aspx

http://radio-weblogs.com/0100190/stories/2002/07/25/sixRulesOfUnitTesting.html

http://c2.com/cgi/wiki?UnitTest

http://www.softwaretestinghelp.com/types-of-software-testing/

http://www.exforsys.com/tutorials/testing/testing-types.html

http://www.aptest.com/testtypes.html

http://www.testinggeek.com/index.php/testing-types

http://www.coleyconsulting.co.uk/testtype.htm

http://www.allinterview.com/showanswers/61894.html

Jobsite

1. http://vacancycorner.com/page/1
2. http://myjobs.shine.com/
3. http://aeroninfo.com/it-jobs/
4. http://www.itguru.co.in/
5. http://www.naukriindia.in/

http://chem11.proboards.com/index.cgi?board=technosphere&action=print&thread=2023

smart cards

links:

           MIFARE:

           http://www.hidglobal.com/page.php?page_id=21

                 http://www.macapsinc.com/httpdocs/php/datasheet/M01040.pdf

           

Sockets

What is a Socket?

A socket is one end of a two-way communications link between two programs running on the network. Sockets are used to implement the connection between a client program and a server program. The java.net package provides two classes--Socket and ServerSocket--that implement the client side of the connection and the server side of the connection, respectively.
Reading from and Writing to a Socket

This page contains a small example that illustrates how a client program can read from and write to a socket.
Writing the Server Side of a Socket

The previous page showed an example of how to write a client program that interacted with an existing server via a Socket object. This page will show you how to write a program that implements the other side of the connection--a server program.

---

What is a Socket?

Mail, ftp, telnet, name and finger are all examples of services provided by computers on the network. Typically, each service is served up on a dedicated, well-known port. [PENDING: define port]. Your programs can access a specific services by connecting to the port dedicated to that service. This is similar to real-life--when you need to have your clothes dry-cleaned you go to the drycleaner, when you need to get money you go to the bank, and so on. In addition to the ports that are dedicated to specific services, computers also have other ports that let programmers to create their own services.
Ports are typically numbered and your program can connect to a port by specifying the port number of the service you wish to connect to. Each service or port recognizes a certain protocol--you must formulate your requests in a manner specific to that service in order for your request to be understood and responded to.

Try this: Locate and view the services file on your computer which lists all of the services provided by your system and the port numbers corresponding to those services. What is the port number for mail? For ftp?

Definition: A socket is one end of a two-way communications link between two programs running on the network.
Your client program can write requests to the socket, and the server will process your request and return the results back to you via the socket. Try this: If you have access to a command line version of the telnet program, use it to connect to port #13 on your computer. What happened? What service is provided on port #13 on your computer?

Sockets are low-level connections. The client and the server both communicate through a stream of bytes written to the socket. The client and the server must agree on a protocol--that is, they must agree on the language of the information transferred back and forth through the socket.

If you are trying to connect to the World Wide Web, the URL class and its friends are probably more suitable to what you are doing. In fact, URLs are a relatively high level connection to the Web and use sockets as part of the underlying implementation. See Working with URLs for information about connecting to the Web via URLs.

The java.net package in the Java development environment provides a class--Socket--that represents one end of a two-way connection between your Java program and another program on the network. The Socket class implements the client side of the two-way link. If you are writing server software, you will also be interested in the ServerSocket class which implements the server side of the two-way link. This lesson shows you how to use the Socket and ServerSocket classes.