Answer Posted / murugavel

1) char datatype is used to store fixed length character
value & varchar is used to store variable length character
value.

2) Composite Key: combination of multiple fields will
produce the uniqeness is called composite key.

Candidate Key: A field has the ability to become a primary
key is known as candidate key.

3) Temporary Table: This table is only visible to this
session of SQL Server. When I close this session, the table
will be automatically dropped. You can treat this table just
like any other table with a few exceptions. The only real
major one is that you can't have foreign key constraints on
a temporary table.

Derived Table:In very basic terms, a derived table is a
virtual table that's calculated on the fly from a select
statement. The biggest benefit of using derived tables over
using temporary tables is that they require fewer steps, and
everything happens in memory instead of a combination of
memory and disk

4) using DATEDIFF function

Ex: SELECT DATEDIFF(dd,"01 March 2010","18 March 2010")

What are instance fields in c#?

1002

---

Can you inherit multiple abstract classes in c#?

936

---

What are the Features in .net framework 1.1

995

---

Different between method overriding and method overloading?

992

---

What is session management in c#?

964

---

What are strings in c#?

943

---

Is c# different than c++?

894

---

Name some properties of array.

975

---

Is enum a class c#?

876

---

What is ienumerable and iqueryable?

920

---

Can a constructor have a return type?

872

---

What is as keyword in c#?

994

---

What happens if the inherited interfaces have conflicting method names?

993

---

What is the difference between ref and out in c#?

900

---

Describe the ways of cleaning up objects in c#.

909

---