Interview Questions Answers in SQL Server, VB.NET

Questions / { sonia }

Questions Answers Category Views Company eMail

Can Somebody tell me the difference between Clustered & Non- Clustered Index??

Progressive,

5 SQL Server 7406

Question { 8109 }

Trace and Debug belongs to which namespaces?

Answer

It's Simply Syste.diagnostics

Not syste,process.diagnostics

Is This Answer Correct ?

8 Yes

0 No

Question { 7533 }

What is an abstract class?

Answer

We cannot create an object of object class. abstract Class
must be inherited.

Is This Answer Correct ?

4 Yes

0 No

Question { TCS, 89197 }

What is the Difference between Overriding and overloading?

Answer

OVERLOADING is the process of declaring the methods having
the same name but diff signatures. Signature means diff
types & number of arguments.

OVERRIDING is the process of overwriting the methods of
base class in Derived Class.

Is This Answer Correct ?

108 Yes

8 No

Question { Infosys, 14259 }

How do you declare static variable and how it is declared
and what is its lifetime?

Answer

Static variables retains their values even after the
termination of the procedure in which it is declared.

Is This Answer Correct ?

20 Yes

12 No

Question { Infosys, 21952 }

Is VB.NET object oriented? What are the inheritances does
VB.NET support ?

Answer

hey hari,i have faced the interview Question what are
interfaces?
I answer Vb.net doesn't supports multiple inheritance,but
it can be achieved in .net using interfaces. Interfaces are
silmilar to class,that contain methods.
but they do not provide any implementation for these
methods.

Then they asked WHY VB.NET DOESN't SUPPORTS MULTIPLE
INHERITANCE??
If u know Can u plz answer!!!!!!!!!

Is This Answer Correct ?

1 Yes

4 No

Question { Digital GlobalSoft, 46327 }

What is intermediate language in .NET ?

Answer

Correct Answer is MSIL and it is 100% sure.

Is This Answer Correct ?

9 Yes

13 No

Question { 8068 }

How to delete an attribute from the emp table

Answer

Using the DROP COMMAND-
See the eg below--

create table stup(roll int,name varchar,marks int)
insert into stup values(1,'A',10)
insert into stup values(2,'B',20)
select * from stup
Alter table stup drop column marks
select * from stup

Is This Answer Correct ?

9 Yes

2 No

Question { NIIT, 18505 }

sql satement for 2nd maximum value

Answer

Rohan answer given by you was not working.....

Is This Answer Correct ?

6 Yes

3 No

Question { 5357 }

Hi
I am planning to take interview in VB.net,can any one share
your interview Questions for a Entry-level job.
Regards
Lina

Answer

mam, I m engineer student but I faced interviews, if u want
I can tell u abt the questions I faced during the
interview. Reply.

Is This Answer Correct ?

1 Yes

0 No

Question { 6596 }

if user enters 1 or 2 or any other number in digit format in
next textbox it should show the answer in word reading
like if enters 12 answer should be twelve

Answer

Private Sub Button1_Click(ByVal sender As System.Object,
ByVal e As System.EventArgs) Handles Button1.Click
Me.TextBox3.Text = CInt(Me.TextBox1.Text) + CInt
(Me.TextBox2.Text)
End Sub

Is This Answer Correct ?

2 Yes

1 No

Question { ABC, 6391 }

1234
123
12
1
how to design above pic in vb.net?

Answer

Sub main()

Dim i, j As Integer
For i = 4 To 1 Step -1
For j = 1 To i
Console.Write(j)
Next
Console.WriteLine()
Next

Console.ReadLine()
End Sub
End Module

Is This Answer Correct ?

10 Yes

1 No

Question { Infosys, 67393 }

Write a query to delete duplicate records in SQL SERVER

Answer

Create table info(comp_id int identity(101,1),comp_name
varchar(50))
insert into info values('Progressive Ltd.')
insert into info values('Progressive Ltd.')
insert into info values('EliResearch')
insert into info values('Patni')
insert into info values('Accenture')
insert into info values('Accenture')
select * from info

DELETE FROM info
WHERE comp_name IN
(SELECT comp_name FROM info
GROUP BY comp_name HAVING COUNT(comp_name) > 1)

Is This Answer Correct ?

12 Yes

38 No

Question { Patni, 7141 }

Display a roll having miminum marks in two subjects?

Answer

create table student7(Roll int,English int,Hindi int,Maths
int)
insert into student7 values(1,12,15,9)
insert into student7 values(2,23,3,13)
insert into student7 values(3,15,12,4)

select roll from student7 where
maths=(select min(maths) from student7)
AND
English=(select min(english)from student7)

Rajesh, AND Operator is used b/w two conditions . Answer
given by you is limted to two subjects, if there are three
or more subjects then

Is This Answer Correct ?

5 Yes

2 No

Question { Satyam, 49253 }

how to get sum of two numbers in vb.net?

Answer

Sub Main()
Dim x, y, sum As Integer
Console.WriteLine("Enter two numbers")
x = Console.ReadLine()
y = Console.ReadLine()
sum = x + y
Console.WriteLine("Sum = " & sum)
Console.ReadLine()
'& is used for concatenation
End Sub

Is This Answer Correct ?

75 Yes

19 No

Question { 5828 }

when we will use console ?

Answer

Console is used if u want to Create a Windows Based
application. First Ans is correct.Second is wrong.

Is This Answer Correct ?

4 Yes

4 No