I have made every effort in writing this post to ensure the accuracy of the information. In this section you can find commonly asked SQL interview questions with their answers. This post surely helps you a lot at the interview. Best of Luck!
Q1: What is SQL?
A1: SQL stands for 'Structured Query Language'. SQL is used for accessing and manipulating database.
Q2: What is COUNT keyword in SQL?
A2: COUNT keyword is used to find the total number of records in a table.
Example: SELECT COUNT (*) FROM emp WHERE Sal>10000; returns all the records of the TABLE ‘emp’ where Salary is less than 10000.
Q3: What is GROUP BY clause?
A3: GROUP BY clause is used to group rows that have the same value.
Q4: What is the difference between a "WHERE" clause and a "HAVING" clause?
A4: The WHERE clause places conditions on the selected columns, whereas the HAVING clause places conditions on groups created by the GROUP BY clause.
Q5: What is SELECT statement?
A5: The SELECT statement is used to select a set of values from a table in a database.
For example: SELECT *FROM emp WHERE Sal>10000
In this post you can find General / Easy HR Interview questions for Freshers as well as experienced professionals. I am sure it will help you a lot.
Some of the general tips that a candidate must keep in mind before going for a HR interview are:
- You must be fully up-to-date about the company in which you are going to attend the interview, so do some research.
- Highlight the positive aspect of the company and make the interviewer feel that you have researched well about the company.
- Know about the company thoroughly, and match your goals and objectives with company’s goals and objectives.
- Clearly state when you will be joining the organization, industry always looks for responsible and honest employees.
- Be specific and to the point. You don’t have to start with your high school percentages. Instead highlight on the recent past qualification.
Q1: Tell me about yourself.
A1: It is normally the most asked question in the interview. Answer the question by simply talking about your relevant experience and education. Don’t put forward your personal profile.
Q2: What do you know about the organization?
A2: This is the question where your prior research and homework about the company will work. Highlight the positive aspect of the company. Keep your answer short and noteworthy.
Q3: Why should I hire you?
A3: Answer the question by talking about your talents and skills that match the job profile. Give examples of related work experiences that you have accomplished.
Q4: What is important for you money or work/Position?
A4: You may answer this question by saying that money is very important, yet it’s not everything, there’s something beyond it, which is job satisfaction!
Q5: Why did you resign from your previous job?
A5: Do not criticize your previous employer or coworkers. You may say that you are looking for a more challenging role, you may also mention problem like buy out, merger etc.
Q6: How do you handle pressure? Do you like or dislike these situations?
A6: If you do perform well under pressure then give a descriptive example. At last you may say that high achievers tend to perform well in pressure situations.
I have made every effort in writing this post to ensure accuracy of the information. In this section you can find all commonly asked Java interview question with their answers. I am sure it will help you a lot. If you have any suggestion about these Java Question & Answer please write to us.
Here Questions and their Answers are arranged in a systematic manner so that you can learn it with ease.
Q1: What is Abstract Class?
A1: A class that contains one or more abstract methods, and therefore can never be instantiated, but rather inherited by other classes.
Q2: What is Abstract Method?
A2: A method that has no implementation.
Q3: What do you mean by Encapsulation?
A3: Encapsulation refers to keeping all the variables and methods together in an object. Because objects encapsulate data and implementation, the user of an object can view the object as a black box that provides services.
Q4: Give a few reasons for using Java?
A4: 1) Java is Object Oriented, 2) Platform independent, 3) Built in support for multi-threading, socket communication, memory management, 4) Supports web based applications like Applet, Servlet and JSP.
Q5: What is an Argument?
A5: A data item specified in a method call. An argument can be a literal value, a variable, or an expression.
Q6: What is difference between C++ and Java?
A6: 1) Java does not support pointer, 2) Java does not support multiple inheritance, 3) Java does not support global variables or functions as all the Java program is encapsulated within class while C++ supports global variables and functions and 4) Java includes automatics garbage collection while C++ requires explicit memory management.
Q7: What is Polymorphism?
A7: Polymorphism means the ability of a single variable of a given type to be used to reference objects of different types, and automatically call the method that is specific to the type of object the variable reference.
Q8: What is Exception in Java?
A8: An event during program execution that prevents the program from continuing normally. Exceptions are conditions that occur because of bad input etc. e.g. FileNotFoundException will be thrown if the specified file does not exist.
