As far as the database administration is concerned, this is definitely one of the very important positions in any company. Some of the responsibility which you will possess as a DBA is data modeling, design, data warehousing and business intelligence software. You will also have to build the database schemes, tables, permissions and procedures. The data sharing as well as the data participation is also to be handled.

Some of the interview questions which can be asked from you are as follows:

1. What is data redundancy?
Redundancy is done when same data is stored in the database more than once. For example there can be two children with same name in a class. However they need to be differentiated. You can do that with the help of ID. However two same rows are very harmful for the database. It is called database redundancy.

2. Is data redundancy helpful or harmful for the database?
It is quite risky for the database. In fact it is the first thing which is being reduced during normalization.

3. Name two kinds of keys?
Primary key and unique key are two examples of key.

4. What is first normal form?
When the database is free from the data redundancy then the database is said to be in first normal form.

5. Name one other normal form other than the 3 normal forms.
Boyce Codd normal form is that normal form.

6. What do you know about the Boyce Codd Normal Form?
It is the key heavy derivation of the third normal form. A relation is in Boyce Codd normal form if and only if all the determinants are a candidate key.

7. What do you know about the third normal form?
A relation is in third normal form if it is in second normal form and every non key attribute is Non-transitively dependent upon the primary key.

8. Define database normalization.
Data base normalization is a series of step with the help of which efficient access and storage of database is made possible. There are four types of normal form.

9. What is SQL stands for?
SQL stands for structured query language.

10. What does DDL and DML stands for?
DDL stands for Data definition language as well as DML stands for data manipulation language.

11. Name two or three database software.
Some of the database software’s are Oracle 9i, oracle 10g, SQL server and so on.

These are some of the questions which can be asked from you when you will give the interview of the database administrator. You will definitely have to prepare hard and keep your mind cool because lots of tricks are involved in this field.

As far as the business system analyst are concerned. Let me tell you that these are the persons who are responsible for deciding that which type of information system is required for the organization. It is they who decide that what should be the features of the information system which is being implemented in the organization. Generally SAP is being implemented in most of the company. Hence a good business system analyst should have good knowledge of SAP.

Some of the interview questions which can be asked from you are as follows:

1. What is a business system? How will you implement it?
You will be a very unlucky person if you are being asked this question so early. However a little bit of research will make you powerful and knowledgeable enough to answer this question. Actually business system is software with the help of which we store useful information of the top management as well as all the other information and then process it according to the requirement. SAP is one such business system. Hence you can implement a business system with the help of SAP or Oracle, BAAN, PeopleSoft and so on.

2. What is the most important thing about business system?
The most important thing about business system is security. Just think of the situation where some information from the top management is leaked. This will definitely be a major setback. Let me tell you that this is kept in mind while making a business system.

3. What is information system?
Actually the information technology is the interaction between people, processes and technology. This interaction might occur inside the boundary of the organization or outside as well.

4. How many types of information system are there?
As the new information technologies are taking shape and hence the different kinds of information system are also coming to the vicinity. Some of them are transaction process system, management information system, decision support system, expert system and business intelligence.

5. Do you feel confident about this job?
Yes, I am confident enough that I will be selected.

6. What is compression?
Compression is a technique with the help of which lots of data are being stored at much reduced memory space.

7. Do you feel that it is applied in business systems?
Yes it is definitely applied in the business system as well.

8. Do you know that what you will have to do as a business system analyst?
Yes I will have to look after the whole process related to the business system of the organization. I will have to guide the juniors if something wrong did happen.

These are some of the interview questions which can be asked from you. Let me tell you that you will have to work very hard if you want to beat the interview.

Investment analysis is one of the posts which require extensive knowledge. Investment can be of any type. You can talk about the investment in real estate, or stock market or insurance. However you will definitely like to get some tips from an expert. Hence I do feel that the investment analysts are quite busy person.

Some of the interview questions which can be asked from you are as follows:

1. Which investment is more profitable? Real estate or Stock investment.
Let me tell you this is a very tricky question. But the correct answer is real estate. With a little bit of research you will be able to find out that real estate is definitely the best choice for investment.

2. Tell us about yourself.
You should keep in mind that the sequence of interview questions which can be asked from you is not constant. The sequence of the question will depend upon your response. I really feel that if you will give one wrong answer then it will be followed by a series of wrong answers. Hence make sure that you answer all the questions correctly. As far as this question is concerned just briefly say that you are so and so and you work in XYZ Company. This much introduction is more than enough.

3. Why have you selected our company?
This is because your offer looks quite great for my future. This is definitely the best answer.

4. What do you know about real estate investment?
I have been working as a real estate agent for six years. Hence I have deep knowledge about the real estate.

5. Are you confident enough that you will be selected?
I am more than hundred percent sure that I will be selected. My educational qualification as well as my work experience makes me the front runner for this post.

6. What will you do for the company if you will be selected?
I will definitely use all of my talent as well as the past experience for the benefit of the company. I am quite sure that I will be a profit for the company.

7. Have you any educational qualification related to investment?
Yes, I have done my MBA with Finance as the major subject. Let me tell you one more thing that you should tell your highest qualification. However if you have won any major prize then you can speak about it.

These are some of the questions which can be asked from you. I assure you that if you will practice hard then you will definitely be selected.

A Technical Engineer is a person who helps the organization by using his technical skills in order to achieve the goals and targets of the firm. Their work is to search for new clients who might benefit the company’s product and services. They should possess skills like installation, troubleshooting, consulting, project planning, training and technical support. They should also possess the ability to work on all chief hardware, software and server platforms.

So, now let me tell you about some interview questions that are frequently asked in a Technical Engineer Interview.

1. Tell us something about your computer programming skills?
It is very essential for a technical engineer to know various computer skills. I am very well versed in operating systems like Windows9X, Windows2000, Windows ME, Windows XP, Windows Vista, Linux, UNIX and MS DOS. I also have the knowledge of Programming Languages like Pascal, Turbo Pascal, C, C++, Java, Java Swing and Python.

2. Can you elaborate about the responsibilities that you had in your previous job?
In my previous position as a technical engineer I was responsible for a wide variety of tasks. I was responsible for supporting marketing activities by attending trade shows, conferences and other marketing events. I also had to make technical presentations in order to demonstrate how a product meets client needs. In addition to all this I also had to handle all the technical responsibilities and authorities of my organization.

3. What kind of technical skills do you possess that can help our organization?
I am sure my technical skills would really prove to be asset for your firm. My Information Technology and management skills include strategic planning, risk management, data management, decision support and mentoring. I can also help the firm in technical recruiting policy development, sales, advertising, screening and qualification.

4. In your previous jobs, have you ever had any supervisory or training duties?
I am fully qualified to full fill any training duties as I possess skills like software design and configuration, business intelligence, database management, quality assurance, research and IT training. In my previous job I had to provide training to the new members and I also delegated authorities to the staff.

5. Tell us about your experience as a Technical Engineer?
My experience as a technical engineer has always been very good, I formulated valuable service schedules and programs for ensuring quality delivery and cost effective technical jobs and also provided proper analytical methods for various client equipments and determining service and supply requirements.

Well these are some very popular questions that might be asked in a Technical Engineer Interview.

A Network Administrator holds a very respectable position in the firm, they are responsible for day to day maintenance, documentation, troubleshooting, and monitoring of information systems. He or she also has to provide Help Desk support and installing, documenting, maintaining and troubleshooting on all information technology assets. A network administrator’s work usually depends on the size of the network for which he or she is responsible.

So, if you are also preparing for a Network Administrator Interview, let me now tell you about some questions that are most frequently asked.

1. Tell us about the education and training required to become a Network Administrator?
A network administrator should have a strong background in math, sciences, and computer science, as well as experience working with computers. He or she should also hold a college degree in computer science, systems science, math, or engineering. They should be familiar with a variety of network operating systems, including Microsoft, Novell, and UNIX.

2. Can you tell us about the skills that are required for this position?
A network administrator should be well versed in the integration of network and telecommunications systems including network routers deployment, server configuration, RAID storage installation, backup system implementation, phone support and full software/hardware support. They also have to constantly see the working of the network to ensure that it is running smoothly. They should also possess good communication, interpersonal, technical, management and organization skills.

3. Can you highlight on the duties that you performed in your previous jobs?
In my previous position as a network administrator I had to perform various duties. I was responsible for customizing the network to the company’s needs by connecting the necessary hardware and software to the network. Once the network was configured I had to install programs, such as e-mail, that the company’s employees use on a daily basis. My main task included to monitor the performance of the network and to troubleshoot any problems such as slow performance or network crashes.

4. What you known about the Global Catalog Server?
A global catalog server is a domain controller it is a master searchable database that contains information about every object in every domain in a forest. The global catalog contains a complete replica of all objects in Active Directory for its host domain, and contains a partial replica of all objects in Active Directory for every other domain in the forest.

Well these are some very interesting questions that are asked by the interviewer during the Network Administrator Interview.

A Windows System Administrator is a person who manages the computer systems in an organization. He or she supports, monitors, tests and troubleshoots hardware and software problems. They install new software releases, upgrade the system, evaluate and install patches and resolve software related problems.

An interview is a two way communication process in which an interviewer asks questions from an interviewee. In this article, I would like to provide you some important interview questions that are frequently asked to the windows system administrator.

1. Tell me something about Active Directory schema?
Well, it is purely technical question. An Active Directory is a technology created by Microsoft that provides a variety of network services such as LDAP directory services, Kerberos-based authentication, DNS-based naming and other network information. Active Directory schema contains formal definitions of every object class that can be created in an Active Directory forest it also contains formal definitions of every attribute that can exist in an Active Directory object.

2. What do you understand by Global Catalog and Global Catalog Server?
The global catalog is a distributed data repository that contains a searchable, partial representation of every object in every domain in a multidomain Active Directory forest. It provides the ability to locate objects from any domain without having to know the domain name.

A global catalog server is a domain controller. It is a master searchable database that contains information about every object in every domain in a forest. The global catalog contains a complete replica of all objects in Active Directory for its host domain, and contains a partial replica of all objects in Active Directory for every other domain in the forest. It is responsible for providing group membership information during logon and authentication and helps users in locating resources in Active Directory.

3. Please tell us something about subnet mask?
Subnet mask divides an IP address into network mask and an address of a host in the network. It is used to identify the network within the large network. It helps in identifying which part of an IP address is reserved for the network, and which part is available for host use.

4. Please tell us something about your past experience?
Well, I have 7 years of professional computer administration and service experience. I have installed, maintained, and upgraded systems running Windows 95/NT/98/ME/2000/XP/Server. I have configured computers for both personal and commercial applications in an OEM environment.

These are some of the important interview questions that are frequently asked. Do not forget to say “thank you” to the person or people who interviewed you.

System Programming is the activity of programming system software. A system programmer is a technical person who writes programs and performs many technical tasks that integrate vendors’ software. He or she also acts as technical advisors to systems analysts, application programmers and operations personnel. A system programmer is also called a Software Engineer.

Listed below are some common interview questions that come up again and again during interviews for the post of System Programmer:

1. Write a function that returns the factorial of a number.
It is a very basic technical question asked by the interviewer to check the fundamental knowledge of the programmer. The probable answer to this question is as under:

#include<iostream>
using namespace std;

/* factorial function –recursive*/
int fact(int n){
if (n==0)
return 1;
n=n*fact(n-1);
return n;
}

int main() {
int n=5;
cout << “Factorial of number ” << n << ” is : ” << fact(n) << endl;
return 0;
}

2. How will you reverse a singly linked list recursively? The function prototype is node * reverse (node *)
The probable answer to this question is as under:

node * reverse (node * n) { node * m ; if (! (n && n -> next)) return n ;
m = reverse (n -> next) ;
n -> next -> next = n ;
n -> next = NULL ; return m ; }

3. You are given only putchar. How will you write a routine putlong that prints out an unsigned long in decimal?
It is another technical question. You can answer this question in following way:

void putlong(unsigned long x)
{
// we know that 32 bits can have 10 digits. 2^32 = 4294967296
for (unsigned long y = 1000000000; y > 0;
y /= 10)
{
putchar( (x / y) + ‘0′);
x = x % y;
}
}

4. Why did you left your previous job?
This is a very sensitive question. Never abuse or disregard your previous employer. You can politely answer this question by saying that there was no growth scope in my previous company that’s why I left it. I am looking for a company with long term growth opportunities. You have a brand name and I think I will get an excellent growth opportunity in your company.

These are some of the frequently asked interview questions. I hope now you will not face any problem in answering the above questions.

A system analyst is an important person who is responsible for researching, planning, coordinating and recommending software and system choices to meet an organization’s business requirements. They guide businesses and other organizations in selecting computers and software. He or she tells how to use computers to get things done. They play a vital role in system development process.

An interview is a two way communication process in which an interviewer asks question from a prospective candidate. Listed below are some of the questions that come up again and again in interviews for the post of System Analyst.

1. Briefly state some of the job specific tasks that you have performed in your previous company?
The job specific tasks that I performed in my previous organization include interacting with the customers to know their requirements and interacting with designers to convey the possible interface of the system. I had to guide the coder and developer to keep the track of system development. I also performed system testing with sample data and implemented various new systems.

2. Please tell us something about your technical and non technical skills?
I have handsome experience in this field. I have acquired many skills in my 7 year career. I have obtained excellent communication, organizational and team building skills. I have sufficient knowledge in project management, planning and complete project life cycle.  I am highly skilled in system testing, conversion, implementation and quality assurance. I can easily analyze client’s existing system and I can provide logical and innovative solutions to various system related problems.

3. Please elaborate some of the qualities of a good System Analyst?
This is a very important job hence it requires excellent communication and organizational skills to support overall system. People who hold this position should be able to function productively in both team and independent work environments. He or she must be able to manage multiple projects simultaneously.

4. Why are you interested in this position?
Well, a good interviewer is one who does his homework before an interview. Just make a thorough research of the respective company. Tell the interviewer that you see adequate opportunity in their company where you can apply your experience in a positive manner.

5. Why should we select you for the post of system analyst?
I am the right person for this job. I will bring to your organization my technical know-how as well as my functional expertise which will bring success to your organization.

These are some of the frequently asked interview questions. Do not forget to say ‘Thank You’ to the person or people who interviewed you.

A subcontractor is a person who has a contract with a contractor to provide some portion of the work or services on a project which the contractor has agreed to perform. He or she works under a Contractor. The typical activities of a subcontractor include plumbing, electrical, roofing, cement work and plastering. A subcontractor can be an individual, a partnership firm, a corporation, or an association.

In this article I would mainly provide you some interview questions that are frequently asked to a Subcontractor.

1. Please tell us something about your past experience?
I have performed numerous important activities in my previous organization. I have ample experience in providing the entire development features for designing and developing procedure for working in new construction projects. I had to plan and execute work procedures, prepare layouts for residential and commercial projects, and interact with clients on project details, work status and alterations.

2. What are some of the aspects that you like about the job?
This question is basically planned to know your comfort and satisfaction levels with the job. You have to tell various positive aspect which you like about this job. Just state adequate reasons as to why this job appeals you.

3. How many subcontracts have you undertaken successfully?
Well, the interviewer wants to check your capability through this question. Answer this question sincerely and tell the specific number of projects that you have undertaken. Don’t exaggerate or inflate your subcontracts. Employers check your references to confirm your work history.

4. Tell us something about the skills that are required to become a good subcontractor?
This is a very crucial position hence it requires outstanding customer service and organizational skills to support contractors, subordinates, and clients. People who hold this position should also have the ability to function successfully in both team and independent work environments. A good subcontractor should be able to provide solutions to client’s grievances.

5. What salary range are you looking for?
You can provide the specific range for salary. However, tell that you are willing to negotiate and compromise. You can also say that lets first talk about the job requirements and expectations, so I can get a sense of what you need, then decide the salary.

Well, these are some of the important questions that are frequently asked in a subcontractor interview and I am very certain that my article would surely help you to answer them with great confidence.

A statistician is a person who works with theoretical and applied statistics. He or she is responsible for measuring, interpreting, and describing the world and human activity patterns. They apply their knowledge in production, research, finance, medicine, insurance and government industry.

Nowadays statisticians are in great demand in both public and private sector. In this article I would like to provide you some important interview questions that are frequently asked to the statisticians.

1. Tell us something about the skills that are required to become a good statistician?
According to me a good statistician is that person who is confidant, structured, fast learner, hard working and goal oriented. They should be capable of meeting deadlines and working under pressure. He or she must be able to function successfully in both team and independent work environments. It is very important that they should have good communication, interpersonal and organizational skills.

2. Elaborate your educational qualifications, experience and skills?
I have handsome experience in this field. I have worked in windows, UNIX, DOS and other systems. I have deep knowledge of multivariate calculus, linear algebra, probability and statistics. I am also familiar to software such as SAS, STATA, SPSS, SPLUS, Excel and many more. Apart from this, I possess excellent communication, interpersonal, analytical and problem solving skills.

3. Please tell us something about the job specific tasks that you have performed?
The profession specific tasks that I have performed in my previous organization include defining analysis endpoints and statistical methodology, executing analysis and interpreting statistical results. I had to provide accurate, statistically appropriate outputs and plan statistical activities including work of other statisticians, programmer and contract research organizations. I also performed quality data analysis using relevant tools and techniques.

4. What do you think it takes to be successful in an organization like this?
I think willpower, leadership qualities, eagerness to work, excellent communication skills, and team spirit are key attributes required for this kind of job. I carry all those attributes that will make me successful in my job.

5. Tell me about your educational background?
Just give a short detail of your academic background. I have done Ph.D. in statistics from a well known university, MS in mathematics and BS in Mathematics.

It is very important to be prepared for an interview. During the course of an interview, you may be asked various questions. Just one bad answer can stand out and cost you the job. So prepare well before appearing for an interview.