i need the ans for the these qus??

anjali khan

10y836

Hi frnds,

I need the ans for below the qus which asked me the interview

I gave the ans but he is not satisfied pl share the ans which u explained infont of the interviewer??

1. Why we use constructor in our application ?? wt is the need?

2. What is destructor??

3. What is finalize and dispose methods with example and what is the use for this?

4. Expalin garbage collector taking with some example??

5. Explain the scenario where u used for and foreach loop and why ??

6. Why we use asp.net?

7. Simple example for the implement interface?

8. Suppose I hv an example

Class class1

{

Public void add (inta,intb)

{

Return (a+b);

}

Public void add (inta,floatb)

{

Return (a+b);

}

My qus is we can change void or not???

9. How to remove the duplicate rows from the table in sql?

10. Why we use enable view state in asp.net?

11. How many non clustered index we can create a table?

My ans is –more then 1

So how much the limie??

12. I have a table like employee

name	City
A	Bangalore
B	UP
C	Bangalore
D	UP
E	Bangalore
F	Chennai

I wants to wrire a query for the below op

Name	ID
Bangalore	3
UP	2
Chennai	1

13. I have a list

List list = new List();

list.Add(“Bangalore”);

list.Add(“UP”);

list.Add(“Bangalore”);

list.Add(“UP”);

list.Add(“Bangalore”);

list.Add(“Chennai”);

}

Here I wants to use another list and wants to display records only Bnagalore City ?? how??

14.Write the program for without using virtual key in overriding??

15.I have a 2 query

a> Select * from Employee

b> Select col1,col2,col3 from Employee

My qus is which is the better and why?

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Joginder Banger10y ago
Accepted answer
HI,
I think that is not possible all answer but I will trying to cover three or more submission. I cover bottom to Up.

Question 15: -
Bad way: Select * from Employee
Best Way: Select col1,col2,col3 from Employee
I am not 100 % sure but as per my knowledge second is best way. Let's with example I assume have one table with Fifty column.
when I used this query "select * from tablename" then this query before display data get the all column name in table stracture and then displayed it.
If I passed above Query with column Name no need get the column name. Compiler just display the data with any refine column Name.

Question 14:

No, you cannot override a non-virtual method. The closest thing you can do is hide the method by creating a new method with the same name but this is not advisable as it breaks good design principles.
But even hiding a method won't give you execution time polymorphic dispatch of method calls like a true virtual method call would. Consider this example:
using System;
class Example
{
static void Main()
{
Foo f = new Foo();
f.M();
Foo b = new Bar();
b.M();
}
}
class Foo
{
public void M()
{
Console.WriteLine("Foo.M");
}
}
class Bar : Foo
{
public new void M() //Override base class method M here.
{
Console.WriteLine("Bar.M");
}
}

Question 13 :
First please check question 13 statement I correct statement. Please check answer below.

List list = new List();
list.Add("Bangalore");
list.Add("UP");
list.Add("Bangalore");
list.Add("UP");
list.Add("Bangalore");
list.Add("Chennai");
List HoldBangaloreCity =( from aa in list where (aa.Contains("Bangalore")) select aa).ToList();

Question : 12
As per look your question you need a group by query like below.
create table Employee (name varchar(max),city varchar(max))
insert into Employee values('A','Bangalore'),('B','UP'),('C','Bangalore'),
('D','UP'),('E','Bangalore'),('F','Chennai')
select city,COUNT(*)ID from Employee group by city

output :
city ID
Bangalore 3
Chennai 1
UP 2

Question : 11

1 Clustered Index + 999 Nonclustered Index = 1000 Index per table in 2008 sql server may be sql upper version have more then 999 non clustered.

I hope some question is clear ...left question will be solve .

Thanks
JSB
anjali khan10y ago
hi Joginder thanks for the update.....