Interview Section

Interview Notes

A computer sciences professional is required to attain a certain level of expertise if he wants to be successful in a career in software development or programming. As there are a great deal of options for an individual interested in Information Technologies, this section provides a series of interview notes to prepare the IT professional for real-world interviews. In order for the computer sciences professional to be knowledgeable about various software, he must invest time and energy in educating himself.

The articles in the Interview Notes section of the tutorials will help to prepare the serious IT professional with a series of practice tests and interview questions he can expect to be confronted with when searching for employment. Practice tests in Java, C#, Quality Management, C, Customer Relationship Management (CRM), ASP.NET, VB.NET, Data Structures and other programming software and scripting languages are provided to train and instruct the developer and programmer.

In addition to practice tests, the tutorials also provide a series of interview questions that will help the programmer or developer study for future employment interviews. An IT professional should be well versed in the terminology and functions of software and scripting languages. Interview questions on a wide range of topics include C, C#, C++, Java, Core Java, JCL, Servlets, JSP, Software and Web Testing and Database Testing, among others.

for further info click here notes.html

Sample Resumes

Are you looking for sample resumes in your professional area of employment to help you create a successful document that will get you a job? A resume for an individual seeking employment is the summary of a person’s experience on-the-job, his qualifications and expertise in his area of specialization. It is important to have a current, up-to-date resume that highlights the skills and assets of the individual to represent himself in the most professional manner possible.

Your resume is your calling card and is one of the keys to creating a successful career. Creating a successful resume can be time-consuming and painstaking. Developing a top-notch resume to represent yourself in business is not only mandatory but is also the way a potential employer will select a potential employee out of hundreds or thousands of candidates on paper. Distinguishing yourself among the sea of competition is the trick to a successful resume. Using the sample resumes in this section, you can get an idea of how to structure your personal resume for success by reading example resumes made available here.

Possessing a good quality resume can make the difference between getting passed over and obtaining an interview for a dream job. Whether you are a Preschool Teacher, Civil Engineer or Business Analyst, these sample resumes will help you to write a coherent, well-developed resume that suitably describes your experiences.

for further info click here sample-resumes.html

Resume Tips

Every successful employee started off with a great resume and knowing as many resume tips as possible can help you get the dream job of your choice. Writing a good resume take time, energy and some critical thinking in order to produce a document that will get you noticed by your potential employer. A resume is used to get your foot in the door, beat out the competition and get you noticed on paper. A killer resume is the first step to having a successful career in your field or industry.

Through Resume Tips articles in this section, an individual looking for guidelines and helpful advice on creating or improving his resume will find what he is searching for. Resumes can be written in different styles and formats and possessing good resume writing skills will assist you in finding a job and representing yourself accurately to potential employers.

It’s never a good idea to lie on your resume but knowing how to describe your skills, qualifications and job experiences in an enthusiastic and descriptive manner is a skill in itself that can help you stand out in the sea of employment competition.

for further info click here resume-tips.html

HR Interviews

HR Interviews can be a source of stress and anxiety when you are looking for a job. So much can be riding on the success of the interview that an individual may become overwhelmed by the interviewing process itself, causing the individual to represent in a less-than flattering light. The HR Interview articles in this section of tutorials will assist you in preparing for one of the important interview process.

HR interview is your chance to make a good impression on your potential employer and ultimately, get the job. How you present yourself, what you wear, how you answer difficult questions and your general attitude all play key roles in HR interviews. Being prepared is the best way to gain employment in today’s competitive job market. Knowing relevant information about the company you are interviewing for, knowledge of the job and the industry surrounding the job can make or break an interview.

All interviews are not the same and HR interviews are often times a screening process that can earn you a follow-up or selection interview within the company. If an individual passes the selection interview, he may be required to participate in a group interview for final analysis. The key to success in HR interviews is to be yourself while respecting your employer.

for further info click here hr-interviews.html

Conversation Skills

An employee with expert technical skills, expertise and experience is considered valuable, whereas an employee with additional talents in conversation skills is an invaluable asset to the company. It is simply not enough in today’s job market to be good at what you do, you must also be able to communicate well with subordinates and authority and possess necessary skills in order to move towards next level within your career track. Your career growth is highly dependent on conversation skills. In fact, a person with less experience and fewer technical skills but who is adept at the art of conversation has a better chance of getting a promotion.

Communication is the key to any personal relationship and your professional relationships are no exception to this rule. There is a great deal of value in working with a person who listens well, processes information and expresses clearly. Since conversation and language are the base means by which we all communicate, having excellent conversation skills is a must for any serious professional, no matter what your field of interest is. The art of conversation is only limited by your imagination.

The articles in this section can help you teach yourself to maintain etiquette in conversation, encourage meaningful conversation and learn how to begin and sustain formal and informal conversation.

for further info click here conversation-skills.html

How to face an Interview Successfully??..

This is a small guide for any candidate who are willing to face on any interview. Personally i know how exciting and heart-smashing thing to face important interviews, specially when it comes to the very first interview in the life :) . So hope that these little set of instructions would really be useful to you, when your interview is ahead. Read it and comment on your own experience and other thoughts :)

The interviewer hopes that YOU are the right person for the job. They are under pressure to fill the position so that they can get back to their own work. Therefore you are in a greater position of strength than you think. Concentrate on what you have to offer in the way of qualifications and experience instead of feeling intimidated.

An interviewer has 3 aims:

1) To learn if you are the right person for the job.
2) To assess your potential for promotion
3) To decide whether you will fit into the company environment.

The key to a successful job interview is in preparation

* Be prepared: For the types of interview questions you will be asked
* Be prepared: To ask questions yourself
* Be prepared: To research the company
* Be prepared: To look the part
* Be prepared: To turn up on time

Job interview questions you may be asked

* Q- How would you describe yourself?
* A-You should describe attributes that will enhance your suitability for the position. Have some ready in advance.

* Q – What are your long-term goals?
* A – These should be career orientated. Make sure you have goals to discuss.

* Q – Why did you leave your last job?
* A – This could be for more responsibility; a better opportunity; increased income. Do not be detrimental to your previous employer. He could be the interviewer’s golfing partner.

* Q – Why do you want this job?
* A – Your answer should be: more responsibility or better opportunity or similar. Not: because it is closer to home or the gym.

* Q – What are your strengths?
* A – You should highlight accomplishments and experiences that relate to the position for which you are applying. Also, give examples of situations where your strengths have been demonstrated.

* Q – What are your weaknesses?
* A – This should not be a list of deficiencies. Don’t mention anything that could make the interviewer question your ability to do the job, for example “I am always late for everything.” Instead, discuss a weakness that could also be a strength such as “I am a workaholic!”

More Examples of Good Interview Questions

* Tell me a little bit about yourself.
* Describe your current / most recent position.
* What made you want to make this change?
* What do you most enjoy doing in your current /most recent position?
* Describe your future ambitions.
* How would you describe yourself?


Good interview questions for YOU to ask

* Asking questions at interview has a number of positive effects:
* It helps you find out more about the company and the position.
* It can be used to divert the interviewer away from a subject you may wish to avoid.
* It can help build a rapport with the interviewer.
* It demonstrates an interest in the job and the company.

The questions must be about the position and the company. Avoid questions about salary, benefits and facilities until after you have been offered the job.
You should already have researched the company and it’s products and services. Your questions should demonstrate knowledge of the company’s history, successes and problems. If the interviewer is a representative of the personnel department the questions should relate to the company and be general. Specific questions relating to the position should be kept for the line manager who will have a more detailed knowledge.


Example questions relating to the position

* What are the main responsibilities of the job?
* What are the most difficult aspects of the job?
* How did the vacancy arise?
* What is the career path relating to this position?
* How will my work be assessed?

Example questions relating to the company

* What is the company hoping to achieve in the next 12 months?
* What new products are the company planning to introduce in the future?
* Are any major changes planned for the department/company?
* Who are your biggest competitors?

Where to find company information

* Information relating to companies, financial data, industries and business trends is available in business magazines which often publish on the World Wide Web and allow you to order Annual Reports relating to specific companies.
* Companies often have their own web site.
* Newspapers – search on-line press reports including archived articles.
* Local library.


Interview Tips – Presentation

* Obviously you should be clean and smart in appearance but you should also dress appropriately for the position, for example: a student placement that is more expensively dressed than the Managing Director may have a negative impact.
* Clothes should be on the conservative side, which is more acceptable to people of all ages, cultures and backgrounds. After all, you are asking to be accepted into the company. Therefore always avoid extremes in hair, clothes, make-up and jewellery. Taking trouble over your appearance shows the employer that the job is important to you.

Interview Tips – Travel

* Arrive 15 minutes early.
* Make sure you have the correct address and know how you will get there:
* Parking? Public transport access?
* Do a dummy run if you are not sure.
* Make sure you have a mobile phone and a telephone number so that you can ring ahead if circumstances beyond your control are making you late.
* Be polite to everyone you speak to, it could be the Managing Director’s cousin! Have a copy of your CV with you.


- Summary -

* You should show interest in all aspects of the job and the company especially if shown around the premises.
* Do your homework on the company and the nature of its business.
* Take care in how you dress for the interview. First impressions still count!

Some of the main influences on the interviewer are:

* Your experience in other employment or life situations
* Your personal presentation. How your personality comes across in the interview
* Your background and references
* Your enthusiasm for both the job and the organisation.
* Relevant qualifications for the position.

Daily puzzle and Brain teasers

Get this widget!

Oracle Interview Questions

What is an Oracle Instance?

2. What information is stored in Control File?

3. When you start an Oracle DB which file is accessed first?

4. What is the Job of SMON, PMON processes?

5. What is Instance Recovery?

6. What is written in Redo Log Files?

7. How do you control number of Datafiles one can have in an Oracle database?

8. How many Maximum Datafiles can there be in an Oracle Database?

9. What is a Tablespace?

10. What is the purpose of Redo Log files?

11. Which default Database roles are created when you create a Database?

12. What is a Checkpoint?

13. Which Process reads data from Datafiles?

14. Which Process writes data in Datafiles?

15. Can you make a Datafile auto extendible. If yes, how?

16. What is a Shared Pool?

17. What is kept in the Database Buffer Cache?

18. How many maximum Redo Logfiles one can have in a Database?

19. What is difference between PFile and SPFile?

20. What is PGA_AGGREGRATE_TARGET parameter?

21. Large Pool is used for what?

22. What is PCT Increase setting?

23. What is PCTFREE and PCTUSED Setting?

24. What is Row Migration and Row Chaining?

25. What is 01555 - Snapshot Too Old error and how do you avoid it?

26. What is a Locally Managed Tablespace?

27. Can you audit SELECT statements?

28. What does DBMS_FGA package do?

29. What is Cost Based Optimization?

30. How often you should collect statistics for a table?

31. How do you collect statistics for a table, schema and Database?

32. Can you make collection of Statistics for tables automatic?

33. On which columns you should create Indexes?

34. What type of Indexes are available in Oracle?

35. What is B-Tree Index?

36. A table is having few rows, should you create indexes on this table?

37. A Column is having many repeated values which type of index you should create on this column, if you have to?

38. When should you rebuilt indexes?

39. Can you built indexes online?

40. Can you see Execution Plan of a statement.

41. A table is created with the following setting

storage (initial 200k
next 200k
minextents 2
maxextents 100
pctincrease 40)

What will be size of 4th extent?

42. What is DB Buffer Cache Advisor?

43. What is STATSPACK tool?

44. Can you change SHARED_POOL_SIZE online?

45. Can you Redefine a table Online?

46. Can you assign Priority to users?

47. You want users to change their passwords every 2 months. How do you enforce this?

48. How do you delete duplicate rows in a table?

49. What is Automatic Management of Segment Space setting?

50. What is the difference between DELETE and TRUNCATE statements?

51. What is COMPRESS and CONSISTENT setting in EXPORT utility?

52. What is the difference between Direct Path and Convention Path loading?

53. Can you disable and enable Primary key?

54. What is an Index Organized Table?

55. What is a Global Index and Local Index?

56. What is the difference between Range Partitioning and Hash Partitioning?

57. What is difference between Multithreaded/Shared Server and Dedicated Server?

58. Can you import objects from Oracle ver. 7.3 to 9i?

59. How do you move tables from one tablespace to another tablespace?

60. How do see how much space is used and free in a tablespace?

C interview questions

1. What does static variable mean?
2. What is a pointer?
3. What is a structure?
4. What are the differences between structures and arrays?
5. In header files whether functions are declared or defined?
6. What are the differences between malloc() and calloc()?
7. What are macros? What are the advantages and disadvantages?
8. Difference between pass by reference and pass by value?
9. What is static identifier?
10. Where are the auto variables stored?
11. Where does global, static, local, register variables, free memory and C Program instructions get stored?
12. Difference between arrays and linked list?
13. What are enumerations?
14. Describe about storage allocation and scope of global, extern, static, local and register variables?
15. What are register variables? What are the advantage of using register variables?
16. What is the use of typedef?
17. Can we specify variable field width in a scanf() format string? If possible how?
18. Out of fgets() and gets() which function is safe to use and why?
19. Difference between strdup and strcpy?
20. What is recursion?
21. Differentiate between a for loop and a while loop? What are it uses?
22. What are the different storage classes in C?
23. Write down the equivalent pointer expression for referring the same element a[i][j][k][l]?
24. What is difference between Structure and Unions?
25. What the advantages of using Unions?
26. What are the advantages of using pointers in a program?
27. What is the difference between Strings and Arrays?
28. In a header file whether functions are declared or defined?
29. What is a far pointer? where we use it?
30. How will you declare an array of three function pointers where each function receives two ints and returns a float?
31. What is a NULL Pointer? Whether it is same as an uninitialized pointer?
32. What is a NULL Macro? What is the difference between a NULL Pointer and a NULL Macro?
33. What does the error ‘Null Pointer Assignment’ mean and what causes this error?
34. What is near, far and huge pointers? How many bytes are occupied by them?
35. How would you obtain segment and offset addresses from a far address of a memory location?
36. Are the expressions arr and *arr same for an array of integers?
37. Does mentioning the array name gives the base address in all the contexts?
38. Explain one method to process an entire string as one unit?
39. What is the similarity between a Structure, Union and enumeration?
40. Can a Structure contain a Pointer to itself?
41. How can we check whether the contents of two structure variables are same or not?
42. How are Structure passing and returning implemented by the complier?
43. How can we read/write Structures from/to data files?
44. What is the difference between an enumeration and a set of pre-processor # defines?
45. What do the ‘c’ and ‘v’ in argc and argv stand for?
46. Are the variables argc and argv are local to main?
47. What is the maximum combined length of command line arguments including the space between adjacent arguments?
48. If we want that any wildcard characters in the command line arguments should be appropriately expanded, are we required to make any special provision? If yes, which?
49. Does there exist any way to make the command line arguments available to other functions without passing them as arguments to the function?
50. What are bit fields? What is the use of bit fields in a Structure declaration?
51. To which numbering system can the binary number 1101100100111100 be easily converted to?
52. Which bit wise operator is suitable for checking whether a particular bit is on or off?
53. Which bit wise operator is suitable for turning off a particular bit in a number?
54. Which bit wise operator is suitable for putting on a particular bit in a number?
55. Which bit wise operator is suitable for checking whether a particular bit is on or off?
56. Which one is equivalent to multiplying by 2?
* Left shifting a number by 1
* Left shifting an unsigned int or char by 1?
57. Write a program to compare two strings without using the strcmp() function.
58. Write a program to concatenate two strings.
59. Write a program to interchange 2 variables without using the third one.
60. Write programs for String Reversal. The same for Palindrome check.
61. Write a program to find the Factorial of a number.
62. Write a program to generate the Fibonacci Series?
63. Write a program which employs Recursion?
64. Write a program which uses command line arguments.
65. Write a program which uses functions like strcmp(), strcpy(), etc.
66. What are the advantages of using typedef in a program?
67. How would you dynamically allocate a one-dimensional and two-dimensional array of integers?
68. How can you increase the size of a dynamically allocated array?
69. How can you increase the size of a statically allocated array?
70. When reallocating memory if any other pointers point into the same piece of memory do you have to readjust these other pointers or do they get readjusted automatically?
71. Which function should be used to free the memory allocated by calloc()?
72. How much maximum can you allocate in a single call to malloc()?
73. Can you dynamically allocate arrays in expanded memory?
74. What is object file? How can you access object file?
75. Which header file should you include if you are to develop a function which can accept variable number of arguments?
76. Can you write a function similar to printf()?
77. How can a called function determine the number of arguments that have been passed to it?
78. Can there be at least some solution to determine the number of arguments passed to a variable argument list function?
79. How do you declare the following:
* An array of three pointers to chars
* An array of three char pointers
* A pointer to array of three chars
* A pointer to function which receives an int pointer and returns a float pointer
* A pointer to a function which receives nothing and returns nothing
80. What do the functions atoi(), itoa() and gcvt() do?
81. Does there exist any other function which can be used to convert an integer or a float to a string?
82. How would you use qsort() function to sort an array of structures?
83. How would you use qsort() function to sort the name stored in an array of pointers to string?
84. How would you use bsearch() function to search a name stored in array of pointers to string?
85. How would you use the functions sin(), pow(), sqrt()?
86. How would you use the functions memcpy(), memset(), memmove()?
87. How would you use the functions fseek(), freed(), fwrite() and ftell()?
88. How would you obtain the current time and difference between two times?
89. How would you use the functions randomize() and random()?
90. How would you implement a substr() function that extracts a sub string from a given string?
91. What is the difference between the functions rand(), random(), srand() and randomize()?
92. What is the difference between the functions memmove() and memcpy()?
93. How do you print a string on the printer?
94. Can you use the function fprintf() to display the output on the screen?
95. Gautam Pagedar adds this question: What is a linklist and why do we use it when we have arrays? - I feel the correct answer should be linklist is used in cases where you don’t know the memory required to store a data structure and need to allocate is dynamically on demand.
96. How do you detect a loop in linked list?
97. Sunil asks: What is the difference between main() in C and main() in C++?
98. ajz at his interviews asks what will be printed out when the following code is executed:

main()
{
printf("%x",-1<<4);
}