Question { Semantic Space, 12488 }

what is the difference between lifecycle model and v-model

Answer

left side rightside
BRS/Verification->Acceptence testcases preparaton validation

SRS/Verification----->System testcases preparions/Validation

Design/Verification-->Integratin tcases preparation/Validati

Buildlevel/Verificat--> unit test cases prepa/Validation

Simultanious approach in V model

Question { TCS, 56552 }

What is a self join? Explain it with an example?

Answer

For this Answer 1 is incorrect.

CREATE TABLE candytest
(kidId char(2),
candycolor varchar(10)
)
GO

INSERT INTO candytest SELECT 'K1', 'Yellow'
INSERT INTO candytest SELECT 'K1', 'Red'
INSERT INTO candytest SELECT 'K2', 'Red'
INSERT INTO candytest SELECT 'K2', 'Blue'
INSERT INTO candytest SELECT 'K3', 'White'
INSERT INTO candytest SELECT 'K3', 'Red'
INSERT INTO candytest SELECT 'K3', 'Yellow'
Go
--Now to find those kidid's which has both yellow and red
colored candies, we can write query as:

Select c1.candytest from
candytest c1,candytest c2
where c1.candycolor=c2.candycolor
and c1.kidid=c2.kidid

Question { IBM, 28229 }

Why we go for automated tesing?

Answer

we can go for the automation
1.when we want to consume the time
2.when application has so many repeatable functionalities
3.when there are so many functionalities with tedious
processes
4.when we can expect the no of verssions of that software
5.when the application has enough time to testing with
enough budjet

Question { 4762 }

What Questions Project Manager will be aske?

Answer

he will ask basic concepts and overall process and projects
overview. its like a management round.

Question { 8813 }

What is Severity and Priority and who will decide what?

Answer

Seviority:defines impact of the bug or how a bad bug is
called Seviority.
Priority:importance to fix that bug

seviority will be decided by the testers and priority will
be dicided by PM or TL in some companies by testers also.
This is the practise following in the company. if the
deadlines r very short tester needs to assign the priority.

Question { CybAge, 6024 }

What are the different Joins in SQL Server???
What are the types of indexes???

Answer

left outer join
right outer join
equi join
self join

indexes
clustered
nonclustered
indexes with columns
indexes with views
unique

Question { CybAge, 8201 }

Write a query to find the number of employees who got more
that 20,000/- and 50,000/- sal

Write a query to find the number of sudents in each course

Answer

here they want number of employees not empno.
select count(empid),sal from emp where sal between 20000
and 50000;