first interview
manisha13 said:
Hi,
I am looking consulting company who can sponser my h1b. I have more than three year experience in India. Currently I live in Japan but these days I am in USA (Bay Area) and I have valid b1/b2 visa for next 10 years. Please help me if you can process my h1b .
My Area where I worked ,
XML/SGML Programmer, UNIX, C, C++, JAVA and SQL server 6.5 & Oracle 9i
Thanks
Manisha
In order to check how good you are in the sphere you posted here, there are some initial questions on Oracle,
I would like to ask you:
1. What is the difference between cold and hot backup?
2. What would you do if you need to save the dump of some scheme?
3. How many kinds of files Oracle database has?
4. Where will you check the problems if something will happen with Oracle Server?
5. Where will you check the problems if something will happen with Oracle client?
6. What is SGA?
7. What is PGA?
8. Have you ever tuned SGA?
8.2) What is buffer cash?
9. What is large pool?
10. What is shared pool?
11. Explain the scheme of how Oracle clients connects to Oracle Server the first time?
12. What is the reserved port of Oracle listener?
13. How many listeners can you have?
14. Which modes of Oracle Server do you know? What is the difference?
15. What would you do if you need to code the traffic between Oracle client and server?
16. What is tablespace?
17. How would you increase tablespace? How would you change the quota on tablespace for some user?
18. What is the profile?
19. Have you ever used V$ tables? if yes, for what purpose?
20. Do you know what is X$ tables?
21. How do you monitor the user sessions?
22. How to run Oracle Enterprise Manager under Unix?
23. How to run Oracle Server under Unix?
24. Can you install Oracle in Unix under root?
25. What is the meaning of redo logs?
26. What would you do if you need to keep the part of your database on ip#1 and another part on ip#2?
Upon your reply I will ask you some questions related to Java, C++, Unix.
Also, please detail: did you develop anything on C++ under Unix? Or what are your Unix skills?
