Interview faced by one of my friend

1st Technical 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

Asked test plan and its 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 test cases 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 he 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 i 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???