Are you familiar with the concepts of primary and secondary keys in a database?
QA / QA Automation
What is black box testing?
If you could use built-in Java libraries, what would you use?
HTTP request composition
When can testing be considered complete?
What types of JOIN do you know?
Sorting passengers by the number of flights Display the identifier, name, and number of flights for each passenger who has made at least one flight. The result should be sorted by the number of flights (descending) and by name (ascending). Use the "as count" construct for the aggregate function counting the number of flights. This is necessary for correct verification. Fields in the resulting table: id, name, count Code from the script: SELECT Passenger.name AS name, COUNT(Pass_in_trip.id) AS count FROM Passenger JOIN Pass_in_trip ON Passenger.id = Pass_in_trip.passenger GROUP BY Passenger.name ORDER BY count DESC, name ASC;
What is the difference between LEFT JOIN and INNER JOIN?
At what point in the testing pyramid is manual testing located?
Given a sorted array of numbers, return a sorted array of their squares. Example: Input: nums = [0, 1, 1, 6, 12, 20] Output: squares = [0, 1, 1, 36, 144, 400]
Why did you choose this solution (two pointers)?
What testing design techniques do you know?
How would a stream help you?
Tell about the testing pyramid.
What types of testing are you familiar with and which ones have you applied?
Why choose these specific browsers?
Have you had experience implementing tests in Go?
What other ways are there to solve this problem?
Can parameters be passed in the body of a GET request?
What techniques of test design have you worked with and specifically apply?