differences between UNION and JOINS

A join selects columns from 2 or more tables. A union selects rows.

difference between an XML "Fragment" and an XML "Document."

An XML fragment is an XML document with no single top-level root element. To put it simple it is a part
(fragment) of a well-formed xml document. (node) Where as a well-formed xml document must have only
one root element.

anchoring different from docking

Anchoring treats the component as having the absolute size and adjusts its location relative to the parent
form. Docking treats the component location as absolute and disregards the component size. So if a status
bar must always be at the bottom no matter what, use docking. If a button should be on the top right, but
change its position with the form being resized, use anchoring.

create a separator in the Menu Designer

A hyphen '-' would do it. Also, an ampersand '&\' would underline the next letter.

Define Lambda Expression With LINQ

LINQ queries can be written in two syntaxes:

•  General Query Syntax
•  Lambda Expression Syntax

Syn for Lambda Expression:

DataSource.Clause(DataAliasName => Expression)

difference between Move and LocationChanged? Resize and SizeChanged?

Both methods do the same, Move and Resize are the names adopted from VB to ease migration to C#.

Define Mandatory Clause in LINQ

1) from clause 2)in clause3) select clause

Define Clause in LINQ

1) from clause 2)in clause 3)let clause 4)where clause 5) orderby clause 6)select clause 7)group by clause

Define Thread life cycle

1.Ready: This is the initial state. The thread object is created.
2.Running: The thread is currently being executed.
3.Sleeping: The thread is temporarily paused. .NET framework offers automatic switching between ―Running and ―Sleeping states, when other threads are executed.
4.Suspended: The thread is temporarily suspended (paused). It will be continued, when you call ―Resume() method.
5. Dead: The thread was closed; it can‘t be restarted or continued.

Define FileStream

To write / read the content to / write the file, you require file streams.
 A file stream acts as a pointer for the file, which contains the memory address of the file on the disc.
 There are two types of file streams.
1) Reading Streams 2) Writing Streams
Using Namespace for FileStram

• System.IO.StreamReader (to read the content of the file)
• System.IO.StreamWriter (to write the content into the file)