Sobes.tech

QA / QA Automation

Are you familiar with the concepts of primary and secondary keys in a database?

413

If you could use built-in Java libraries, what would you use?

262

When can testing be considered complete?

259

What types of JOIN do you know?

240

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;

237

What is the difference between LEFT JOIN and INNER JOIN?

232

At what point in the testing pyramid is manual testing located?

231

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]

220

Why did you choose this solution (two pointers)?

214

What testing design techniques do you know?

208

Tell about the testing pyramid.

205

What types of testing are you familiar with and which ones have you applied?

204

Why choose these specific browsers?

198

Have you had experience implementing tests in Go?

191

What other ways are there to solve this problem?

175

Can parameters be passed in the body of a GET request?

174

What techniques of test design have you worked with and specifically apply?

171
/2