Only One Person Gets the Job!
Give Yourself a Professional Edge and
Leave Everyone Else in the Dust

So how are you supposed to compete against hundreds of other job seekers?

You may have the most experience and education, are well-qualified and may be the best person for the job -- but even the best person still has to prove WHY they are the best.

Before you can prove you are perfect for the job, you need to understand the employers needs.

• What do they want?
• Why are they asking me this?
• What do they mean?
• How can I prove I'm the best?

Now imagine for just a minute -- what if you knew exactly what your interviewer was looking for? What if you could read their minds? What if you had an endless library of 'golden answers' at your fingertips and could dish them up at will?

How do you think you would do now?

Imagine walking into your next interview -- confident, well-prepared and ready to answer any question your interviewer asks while effortlessly rattling off perfect answers that leave your interviewer with an outstanding impression of you and your abilities.

Getting hired would be much easier, wouldn't it?

So how can you walk into your next interview feeling confident, prepared, ready to tackle any question your interviewer throws at you and improve your odds of getting hired?

The Only Thing Standing Between You and
Getting Hired is Giving the Right Answers to
Your Interviewer's Questions
Do You Know Them All?

Walking into an interview without knowing exactly what you are going to say is like trying to give a presentation without practice.

Have you ever been on a job interview where you knew you were right for the job, but you didn't get it? They may have told you they chose a more qualified candidate. In reality, you were probably the most qualified, but you failed to impress your interviewer.

If you don't impress your interviewer the first time, your chances for a second interview are ZERO!

I used to be nervous during interviews and usually ended each one by kicking myself the whole way home for blowing yet another interview.

I was always qualified, but early on in my career, I didn't always get the job. There were many times where I felt like throwing in the towel because NONE of the companies I interviewed at would offer me a job, no matter how hard I tried.

I've walked a mile in your shoes before, so I know how downright frustrating it is to 'try' and keep 'trying'.

JOB INTERVIEW QUESTIONS

Can You Correctly Answer Tough
Job Interview Questions Like These?

• Tell me about yourself
  I’ll show you what you MUST avoid saying.
• Why did you leave your last job?
  Everyone get's this one wrong. I'll help you give an answer that reveals your strengths.
• Do you know anything about our company?
  I’ll walk you through a few easy steps that shows you did your homework.
• What did you like about your last job?
  Most job seekers mess this one up, but I'll show you exactly what to say.
• What would you like to be doing five years from now?
  A well spoken answer shows how you make good use of goals and are perfect for the job.

• Can you work under pressure?
• Could you describe a difficult problem and how you dealt with it?
• Why do you want to work here?
• What were some of the things you did not like about your last job?
• What do you consider your most significant weaknesses?
• What are your biggest accomplishments?
• How do you accept criticism?
• What is the most difficult situation you have faced?
• What are some of the things that bother you?
• What do you consider your most significant strengths?
• Do you prefer working with others or alone?
• How do you get along with different types of people?
• Can you give me an example of a project that didn’t work out well?
• What are some of the things you and your supervisor have disagreed on?

Testing Interview Questions

Testing Interview Questions

What’s Ad Hoc Testing ?

A testing where the tester tries to break the software by randomly trying functionality of software.

What’s the Accessibility Testing ?

Testing that determines if software will be usable by people with disabilities.

What’s the Alpha Testing ?

The Alpha Testing is conducted at the developer sites and in a controlled environment by the end user of the software

What’s the Beta Testing ?

Testing the application after the installation at the client place.

What is Component Testing ?

Testing of individual software components (Unit Testing).

What’s Compatibility Testing ?

In Compatibility testing we can test that the software is compatible with other elements ofsystem.

What is Concurrency Testing ?

Multi-user testing geared towards determining the effects of accessing the same application code, module or database records. Identifies and measures the level of locking, deadlocking and use of single-threaded code and locking semaphores.

What is Conformance Testing ?

The process of testing that an implementation conforms to the specification on which it is based. Usually applied to testing conformance to a formal standard.

What is Context Driven Testing ?

The context-driven school of software testing is flavor of Agile Testing that advocates continuous and creative evaluation of testing opportunities in light of the potential information revealed and the value of that information to the organization right now.

What is Data Driven Testing ?

Testing in which the action of a test case is parameterized by externally defined data values, maintained as a file or spreadsheet. A common technique in Automated Testing.

What is Conversion Testing ?

Testing of programs or procedures used to convert data from existing systems for use in replacement systems.

What is Dependency Testing ?

Examines an application’s requirements for pre-existing software, initial states and configuration in order to maintain proper functionality.

What is Depth Testing ?

A test that exercises a feature of a product in full detail.

What is Dynamic Testing ?

Testing software through executing it. See also Static Testing.

What is Endurance Testing ?

Checks for memory leaks or other problems that may occur with prolonged execution.

What is End-to-End testing ?

Testing a complete application environment in a situation that mimics real-world use, such as interacting with a database, using network communications, or interacting with other hardware, applications, or systems if appropriate.

What is Exhaustive Testing ?

Testing which covers all combinations of input values and preconditions for an element of the software under test.

What is Gorilla Testing ?

Testing one particular module, functionality heavily.

What is Installation Testing ?

Confirms that the application under test recovers from expected or unexpected events without loss of data or functionality. Events can include shortage of disk space, unexpectedloss of communication, or power out conditions.

What is Localization Testing ?

This term refers to making software specifically designed for a specific locality.

What is Loop Testing ?

A white box testing technique that exercises program loops.

What is Mutation Testing ?

Mutation testing is a method for determining if a set of test data or test cases is useful, by deliberately introducing various code changes (‘bugs’) and retesting with the original test data/cases to determine if the ‘bugs’ are detected. Proper implementation requires large computational resources

What is Monkey Testing ?

Testing a system or an Application on the fly, i.e just few tests here and there to ensure the system or an application does not crash out.

What is Positive Testing ?

Testing aimed at showing software works. Also known as “test to pass”. See also Negative Testing.

What is Negative Testing ?

Testing aimed at showing software does not work. Also known as “test to fail”. See also Positive Testing.

What is Path Testing ?

Testing in which all paths in the program source code are tested at least once.

What is Performance Testing ?

Testing conducted to evaluate the compliance of a system or component with specified performance requirements. Often this is performed using an automated test tool to simulate large number of users. Also know as “Load Testing”.

What is Ramp Testing ?

Continuously raising an input signal until the system breaks down.

What is Recovery Testing ?

Confirms that the program recovers from expected or unexpected events without loss of data or functionality. Events can include shortage of disk space, unexpected loss of communication, or power out conditions.

What is the Re-testing testing ?

Retesting- Again testing the functionality of the application.

What is the Regression testing ?

Regression- Check that change in code have not effected the working functionality

What is Sanity Testing ?

Brief test of major functional elements of a piece of software to determine if its basically operational.

What is Scalability Testing ?

Performance testing focused on ensuring the application under test gracefully handles increases in work load.

What is Security Testing ?

Testing which confirms that the program can restrict access to authorized personnel and that the authorized personnel can access the functions available to their security level.

What is Stress Testing ?

Stress testing is a form of testing that is used to determine the stability of a given system or entity. It involves testing beyond normal operational capacity, often to a breaking point, in order to observe the results.

What is Smoke Testing ?

A quick-and-dirty test that the major functions of a piece of software work. Originated in thehardware testing practice of turning on a new piece of hardware for the first time and considering it a success if it does not catch on fire.

What is Soak Testing ?

Running a system at high load for a prolonged period of time. For example, running several times more transactions in an entire day (or night) than would be expected in a busy day, to identify and performance problems that appear after a large number of transactions have been executed.

What’s the Usability testing ?

Usability testing is for user friendliness.

What’s the User acceptance testing ?

User acceptance testing is determining if software is satisfactory to an end-user or customer.

What’s the Volume Testing ?

We can perform the Volume testing, where the system is subjected to large volume of data.

UML Interview Questions

UML Interview Questions

A Collection of UML interview questions and answers:

1. What is UML? UML is Unified Modeling Language. It is a graphical language for visualizing specifying constructing and documenting the artifacts of the system. It allows you to create a blueprint of all the aspects of the system, before actually physically implementing the system.
2. What is modeling? What are the advantages of creating a model? Modeling is a proven and well-accepted engineering technique which helps build a model. The model is a simplification of reality; it is a blueprint of the actual system that needs to be built. The model helps to visualize the system. The model helps to specify the structure and behavior of the system. The model helps make templates for constructing the system. The model helps document the system.
3. What are the different views that are considered when building an object-oriented software system? Normally there are 5 views. Use Case view – This view exposes the requirements of a system. Design View – Capturing the vocabulary. Process View – modeling the distribution of the systems processes and threads. Implementation view – addressing the physical implementation of the system. Deployment view – focus on the modeling the components required for deploying the system.
4. What are diagrams? Diagrams are graphical representation of a set of elements most often shown made of things and associations.
5. What are the major three types of modeling used? Major three types of modeling are structural, behavioral, and architectural.
6. Mention the different kinds of modeling diagrams used? Modeling diagrams that are commonly used are, there are 9 of them. Use case diagram, Class Diagram, Object Diagram, Sequence Diagram, statechart Diagram, Collaboration Diagram, Activity Diagram, Component diagram, Deployment Diagram.
7. What is Architecture? Architecture is not only taking care of the structural and behavioral aspect of a software system but also taking into account the software usage, functionality, performance, reuse, economic and technological constraints.
8. What is SDLC? SDLC is Software Development Life Cycle. SDLC of a system included processes that are Use case driven, Architecture centric and Iterative and Incremental. This Life cycle is divided into phases. Phase is a time span between two milestones. The milestones are Inception, Elaboration, Construction, and Transition. Process Workflows that evolve through this phase are Business Modeling, Requirement gathering, Analysis and Design, Implementation, Testing, Deployment. Supporting Workflows are Configuration and change management, Project management.
9. What are Relationships? There are different kinds of relationships: Dependencies, Generalization, and Association. Dependencies are relations ships between two entities that that a change in specification of one thing may affect another thing. Most commonly it is used to show that one class uses another class as an argument in the signature of the operation. Generalization is relationships specified in the class subclass scenario, it is shown when one entity inherits from another. Associations are structural relationships that are: a room has walls, Person works for a company. Aggregation is a type of association where there is a has a relationship, That is a room has walls, ño if there are two classes room and walls then the relationship is called a association and further defined as an aggregation.
10. How are the diagrams divided? The nine diagrams are divided into static diagrams and dynamic diagrams.
11. Static Diagrams (Also called Structural Diagram): Class diagram, Object diagram, Component Diagram, Deployment diagram.
12. Dynamic Diagrams (Also called Behavioral Diagrams): Use Case Diagram, Sequence Diagram, Collaboration Diagram, Activity diagram, Statechart diagram.
13. What are Messages? A message is the specification of a communication, when a message is passed that results in action that is in turn an executable statement.
14. What is an Use Case? A use case specifies the behavior of a system or a part of a system, óse cases are used to capture the behavior that need to be developed. It involves the interaction of actors and the system.

SQL Interview Questions and Answers

SQL Interview Questions and Answers

1. What is Normalization?

Normalization is the process of organizing the columns, tables of a database to minimize the redundancy of data. Normalization involves in dividing large tables into smaller tables and defining relationships between them. Normalization is used in OLTP systems.

2. What are the different types of Normalization Levels or Normalization Forms?

The different types of Normalization Forms are:

• First Normal Form: Duplicate columns from the same table needs to be eliminated. We have to create separate tables for each group of related data and identify each row with a unique column or set of columns (Primary Key)
• Second Normal Form: First it should meet the requirement of first normal form. Removes the subsets of data that apply to multiple rows of a table and place them in separate tables. Relationships must be created between the new tables and their predecessors through the use of foreign keys.
• Third Normal Form: First it should meet the requirements of second normal form. Remove columns that are not depending upon the primary key.
• Fourth Normal Form: There should not be any multi-valued dependencies.

Most databases will be in Third Normal Form

3. What is De-normalization?

De-normalization is the process of optimizing the read performance of a database by adding redundant data or by grouping data. De-normalization is used in OLAP systems.

4. What is a Transaction?

A transaction is a logical unit of work performed against a database in which all steps must be performed or none.

5. What are ACID properties?

A database transaction must be Atomic, Consistent, Isolation and Durability.

• Atomic: Transactions must be atomic. Transactions must fail or succeed as a single unit.
• Consistent: The database must always be in a consistent state. There should not be any partial transactions
• Isolation: The changes made by a user should be visible only to that user until the transaction is committed.
• Durability: Once a transaction is committed, it should be permanent and cannot be undone.

6. Explain different storage models of OLAP?

• MOLAP: The data is stored in a multi - dimensional cube. The storage is not in the relational database, but in proprietary formats.
• ROLAP: ROLAP relies on manipulating the data stored in the RDBMS for slicing and dicing functionality.
• HOLAP: HOLAP combines the advantages of both MOLAP and ROLAP. For summary type information, HOLAP leverages on cube technology for faster performance. For detail information, HOLAP can drill through the cube.

7. Explain one-to-one relationship with an example?

One to one relationship is a simple reference between two tables. Consider Customer and Address tables as an example. A customer can have only one address and an address references only one customer.

8. Explain one-to-many relationship with an example?

One-to-many relationships can be implemented by splitting the data into two tables with a primary key and foreign key relationship. Here the row in one table is referenced by one or more rows in the other table. An example is the Employees and Departments table, where the row in the Departments table is referenced by one or more rows in the Employees table.

9. Explain many-to-many relationship with an example?

Many-to-Many relationship is created between two tables by creating a junction table with the key from both the tables forming the composite primary key of the junction table.

An example is Students, Subjects and Stud_Sub_junc tables. A student can opt for one or more subjects in a year. Similarly a subject can be opted by one or more students. So a junction table is created to implement the many-to-many relationship.

10. Write down the general syntax of a select statement?

The basic syntax of a select statement is

SELECT Columns | *
FROM   Table_Name
[WHERE  Search_Condition]
[GROUP BY Group_By_Expression]
[HAVING Search_Condition]
[ORDER BY Order_By_Expression [ASC|DESC]]

This article is based on the free ebook "Graduate Employment"

Most interviewers like to hit you with the question: “What is your greatest strength? This is one of the most common interview questions and you should be prepared to answer it convincingly. That is why identifying your strengths before a job interview can be far more demanding, yet rewarding, than may initially seem to be the case. Whilst you may find the first list of skills and experiences comes easily, as it will be largely descriptive, the rich reward will come, if you can re-describe your same skills to highlight past successes.

Focus on actions

One of the first things to keep in mind when answering this typical interview question is to describe your achievements differently. For example, use terms such as work experience, group projects, techniques, skills, individual learning, clubs and societies, rather than job titles and course names. This will express concrete actions rather than plane descriptions.

Furthermore, try to use verbs, not adjectives in your interview answer. When showing what you have to offer, try to give brief examples that show what you actively ‘did’, rather than what you passively ‘were’.

About fully used and missed opportunities

Ask yourself: What opportunities have I used fully? For example, did you participate in sports or cultural societies at university?

Another interview question would be: What opportunities have I missed and what have I learned from this? When describing your work experience – be specific. Quantify, quantify, quantify. From the mundane, such as your attendance record, to any positive feedback you received from your employer.

Travelling achievements and voluntary work

When describing a group achievement in your interview answer, clearly identify what you contributed and be specific. Do not be afraid to include travelling achievements. Some of the most important life lessons are learned in a foreign context. Was it a good investment of time and money? What can I use in a job context?

Do not forget voluntary work and community involvement. Here it is important to ask yourself: What did I need to learn? What was difficult? What did you get praised for? And, for interests, pastimes and hobbies consider what you have done outside of study and work this week, this month, this year, or indeed while at university.

Besides your strengths, you should also think about your weaknesses and how to describe them in a positive way before a job interview to be prepared – just in case.