Answer / 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 is the need of using interface in program ex:if we have a program like this interface1() { void method1(); void method(); } class a1 : interface1 { a1 b = new b(); b.method1(); b.method2(); } so without using interface also we can achieve this then wat is the need to use the interface? plz give me the answer

1 Answers  

---

What are the differences between system.string and system.text.stringbuilder classes?

0 Answers  

---

What is an object pool in .net?

0 Answers  

---

What are collection classes?

0 Answers  

---

Difference between multi-level and multiple inheritance?

17 Answers   Microsoft,

---

How much time will it take to learn unity?

0 Answers  

---

Explain the term inheritance in C#.

0 Answers   Deloitte, JPMorgan Chase,

---

If we write a goto or a return statement in try and catch block will the finally block execute?

6 Answers  

---

How is a string immutable?

0 Answers  

---

Explain ACID rule of thumb for transactions.

1 Answers  

---

How long does a loop recorder procedure take?

0 Answers  

---

Can multiple catch blocks be executed?

4 Answers  

---