Some Imp FAQ's

Hi all,

This is my first post rergarding testing questions that i have faced in some compnay( sorry i dont want to reveal the company)

1st Tech round questions:
1) About my self
2) Questions on my current project
3) asked my role in the project
4) testing process in my company
5) Asked about V-Model
6) Asked about use cases
7) Asked which comes first test strategy or test plan

Ans) Test strategy comes first

8) Asked test plan and it contents
9) Asked how do u do risk analysis
10) Asked about smoke, sanity and regression testing.
11) Asked where u connect URL of database connection for the application

ans) it depends upon the framework and web server using for J2EE applications, we are using struts framework
and web server-tomcat, in tomcat folder, go to webapps folder, u can see ur application build, open ur application folder, open web-inf, u can see struts conf.xml file( file depends),
open with text pad, am pasting a sample one....
property="driverClassName"
value="oracle.jdbc.driver.OracleDriver" />
property="url"
value="jdbc:oracle:thin:@hostname:1521:servicename" />

here hostname=ur company's server name like IP address
Servicename= ur company's service name of oracle test database( if any questions on these feel free to contact me will explain in detail as am Oracle certified professional)

12) Asked URL for application to open on web browser

Ans) it depends on server that ur using....i said http://localhost:8080/applcationname.
This is for struts framework

13) asked difference between 8080 and 8081
14) Asked is test cases are necessary?
15) Diff between testcases and use cases
16) asked abt VSS--->configuration management tool-->version control-->control and documents the current changes in the life cycle of project.( if any queries on this please revert me back)

After one week i got call for 2nd tech round, the questions are like these:

1) Questions on my present project.
2) Test plan and it contents
3) what is 'i' in oracle 9i ----> i refers internet
4) current version of internet explorer that am using---> now a days they r asking these questions, so job seekers please
have a look on the versions that we r using...okay
5) diff between web server and application server..
6) questions on sql...
. types of joins
. what is a join
. Primary key
. what is referential integrity
. second highest salary from employee tab
. what is normalization
. diff kinds of normalization
. top 5 salaries from emp table
7) Asked on HTTP error codes---404, 500 ( keep an eye..okay..these are very important)
8) what is acceptance testing???

thats it for now.......am waiting for my result..............okay bye

Cheers
anand

am giving some answers for my questions:-

Query for top 5 salaries from employee tab:

select name,salary from (select name,salary from employee order by salary desc) employee where rownum<=5;

Query for 2 nd highest salary from emp tab:

select max(salary) from employee where salary < (select max(salary) from employee);

N th highest salary from emp tab:

SELECT * FROM Employee E1 WHERE
(N-1) = (SELECT COUNT(DISTINCT(E2.Salary)) FROM Employee E2 WHERE
E2.Salary > E1.salary)

Note: With the above Correlated query, we can get any nth salary...so practice this query...

Cheers
anand

[Spoorthi]

hi anand,
thank u very much for sharing ur exp.
hope u'll get call frm tht company.
wish u all the best.

Hi spoorthi,

thanks for wishing me......i got a call for 3rd tech round...........yesterday..

will share my exp tomorrow....

Bye

Cheers
anand

[kiran2710]

Hi anand,

Nice post man,,

All da best...

[sharan_757]

Hi,
Thanks a lot Anand and best of luck for ur next interview.
it was very nice to know the fact that realtime questions are very different from the FAQs we generally go through.
I sincerely request all the members to take some of ur valuable time to post such realtime experiences which will make this forum really worth visiting.

TC

Bye

[binu_george78]

hello

[subramanyamt]

Hi anand,

All the best for ur last round :). Can u brief on 8080 and 8081.

Cheers,
Subbu.

Hi Anand,

i have got the difference for 8080 and 8081, 8080 is for local host and 8081 for Admin.

cheers,
subbu.

[vjsreevs]

hey its really so wonderfull that u shared ur exps here ....
hope 2 c ur nxt rnd exp also ...
wising u all the best !
hope all the members ll come out to post such realtime experiences which will make this forum really worth visiting.

[subramanyamt]

Originally Posted by subramanyamt

Hi anand,

All the best for ur last round :). Can u brief on 8080 and 8081.

Cheers,
Subbu.

Hi Anand,

i have got the difference for 8080 and 8081, 8080 is for local host and 8081 for Admin.

cheers,
subbu.

[subramanyamt]

Hi anand,

i got the difference between 8080 and 8081. 8080 is for local host and 8081 is for Admin.

Cheers,
subbu.

[slinkanand]

Hi subbu,

u can give any port, change the port whatever u like, just open conf folder in tomcat folder, in conf folder open server.xml, serch with 8080,
Pasting here the sample-
port="8080" maxThreads="150" minSpareThreads="25" maxSpareThreads="75"
enableLookups="false" redirectPort="8443" acceptCount="100"
debug="0" connectionTimeout="20000"
disableUploadTimeout="true" />

and change the port in the file, and try with modified port..
For Example: http://localhost:8080/projectname ---> http://localhost:8081/projectname
or http://localhost:8082/projectname

Cheers,
Anand

[subramanyamt]

Hi Anand,

Thank you for clarifying me. For one of my friend, the interviewer asked
Q. how many types of defects are there?

If u know the answer for this, pleas send me the reply.

cheers,
subbu.

[slinkanand]

Hi Subbu,

defects can be many types, first of all what is a defect?
A defect is due to error in coding, so testers will get mismatches while testing the application.

A defect can be incorrect operation, cosmetic flow, implementation issue, Syntax, Environment(design, compile, test), Interface(procedure calls nad refs, I/O), Build, package(Change management, version control), checking(error messages, inadequate checks)...

Cheers
anand

[subramanyamt]

Hi anand,

Thanks for the reply. But the interviewer had specifically asked how many defects are there, so i thought that there may be some defects which are common. I mean the defects which are common, atleast we have to mention them. :)

Cheers,
Subbu.