QA Automation Interview

Get Started. It's Free
or sign up with your email address
QA Automation Interview by Mind Map: QA Automation Interview

1. Topics

1.1. Scrum

1.1.1. What's Scrum? It's a methodology to work in a team. Used to solve complex problems. Effective collaboration Agile is similar, but is more flexible and promotes leadership teams

1.1.2. What's Agile? Agile scrum methodology is a project that depends on incremental development Each iteration consists of two- to four-week sprints Each sprint's goal is to build the most important features first and come out with a potentially deliverable product. More features are built and adjusted based on customer feedback Advantages Products are built faster Requires frequent planning and goal setting Gets feedback faster from the client

1.1.3. Roles Core Roles Scrum master: Dev facilitator, leads daily meetings. Remove blockers Product Owner: Represents stakeholders (customers). Knows business requirements and their details. Prioritize tasks Scrum Team: Work group, developers, testers, automation engineers, designers Ancillary Roles Customers, Managers and Executives Not involved in the development Report progress and get feedback

1.1.4. Ceremonies Sprint Planning: Define User Stories that the team will work on in the next Sprint. Sprint Review: End of Sprint, team does a Demo of the new functionality in the project. Get Feedback Sprint Retrospective: What went well, and not well during the sprint -> Define actions Daily Scrum Meeting: 15min meeting. What's complete? what are you going to work today?, Any Blockers?

1.1.5. Artifacts Product Backlog Sprint Backlog

1.2. SQL

1.2.1. Basics SELECT * FROM table_name; SELECT DISTINCT column1, column2, ... return only distinct WHERE condition1 AND condition2 OR condition3 AND NOT condition3 ...; ORDER BY column1, column2, ... ASC|DESC; Group By SELECT COUNT(CustomerID), Country FROM Customers GROUP BY Country; App App

1.2.2. Medium SELECT TOP number|percent column_name(s) SELECT MIN | MAX (column_name) SELECT COUNT(column_name) ... SELECT AVG(column_name) SELECT SUM(column_name) ... WHERE columnN LIKE pattern; WHERE CustomerName LIKE 'a%'; WHERE column_name IN (value1, value2, ...);

1.2.3. Actions INSERT INTO table_name (column1, column2, column3, ...) VALUES (value1, value2, value3, ...); UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; DELETE FROM table_name WHERE condition;

1.2.4. Joins Combine rows from two or more tables Types S Inner SELECT Orders.OrderID, Customers.CustomerName, Orders.OrderDate FROM Orders INNER JOIN Customers ON Orders.CustomerID=Customers.CustomerID; Left FROM table1 LEFT JOIN table2 ON table1.column_name = table2.column_name; Right FROM table1 RIGHT JOIN table2 ON table1.column_name = table2.column_name; Outer FULL OUTER JOIN table2 ON table1.column_name = table2.column_name WHERE condition; Self Join Table is joined with itself. SELECT A.CustomerName AS CustomerName1, B.CustomerName AS CustomerName2, A.City FROM Customers A, Customers B WHERE A.CustomerID <> B.CustomerID AND A.City = B.City ORDER BY A.City;

1.3. API

1.3.1. Codigos de respuesta S 100 100 Continue 101 Switching Protocols 102 Processing 200 Client’s request was successfully received, understood, and accepted 200 OK 201 Created 204 No Content 202 - Accepted 203 - Non-authoritative Information 205 - Reset Content 300 Redirection: Further action needs to be taken by the client in order to fulfill the request 301 Moved Permanently 302 Found - Temporarily under different URI 304 Not Modified 305 Use Proxy 400 4×× Client Error 400 Bad Request 401 Unauthorized 403 Forbidden 404 Not Found 500 5×× Server Error 500 Internal Server Error 502 Bad Gateway 503 Service Unavailable 504 Gateway Timeout

1.3.2. API GET & POST (has Body) Include Headers Paramters: Double curly brackets: {{sample}} Methods GET POST PUT (Replace) PATCH(Update) DELETE

1.3.3. Postman Advantages Accessibility Collections Collaboration Environments | Parameters Creation of Tests Automation Testing - Newman Debugging Continuous Integration Creation of Tests Javascript code, compare expected responses codes Can use Environments and Parameters pm.test("Status is Success", function(){; } )

1.4. Testing

1.4.1. Basics Test Case: Step by step on how to perform a test Test Plan: Testing Plan Covers testing Scope, Approach, Resources and Schedule Test Scenario: Describe a functionality that can be tested Test Strategy: High-level

1.4.2. Requirements Traceability Matrix (RTM) Make sure all requieremets are covered Matrix Requiremet Vs Test Cases, set if TC cover all of them

1.4.3. Verify Vs Validation Verification: Are we building the system properly? System has all requirements Validation: Are we building the proper system? Satisfies needs and expectaions

1.5. Selenium

1.5.1. Type of Waits

1.5.2. Assert Vs Verify Assert: If FALSE, execution is stopped Verify: Execution continues

1.5.3. Quizz

1.6. Java

1.6.1. Variables

1.6.2. Classes, Interfaces

1.6.3. Compiler

2. App