QA / QA Automation

You have a list of cases for automation. Which candidates are the top priority for automation, which are less suitable, and which are not suitable at all? How would you prioritize?

What can be transmitted in the body of a request?

In your opinion, what does a good test case mean? What are its characteristic features?

Have you worked with Allure? What annotations can you name? Is it possible to attach a screenshot and how? Where are the test run results stored? How to integrate Allure with CI/CD (Jenkins)?

What aggregate functions do you know? Which operator is used with aggregate functions instead of WHERE?

# 1. Python. Find duplicate numbers # Description: # Implement a function that searches for repeating numbers in a set # Numbers are initially recorded as a list. # Output the result to the screen. # Input data: # [1, 2, 3, 2, 4, 1, 5, 2] # Result: # [1, 2]

What is nonlocal in Python?

-- SQL -- Description: -- 1. Select the name and maximum balance for each payment system -- Input data:

What is CI/CD? What does the pipeline consist of?

What is the difference between iterators and generators? What is the relationship between them? What happens when an iterator reaches the end?

Tell me about the Page Object Pattern.

What libraries did you use for API test automation? How did you validate the responses?

Does a GET request have a body? How does GET transmit parameters? What are Content-Type and Accept, and how do they differ?

Tell me about idempotency. Which methods are idempotent?

What is a fixture in pytest? What is its scope? Can a fixture be called from another fixture? What is autouse? Can parameters be passed to a fixture?

What are message queues (Kafka) used for? What is offset? What is the structure: topic, partition, message?

-- 2. Select the client name, balance, and payment system name for each client in descending order of non-zero balance -- Input data: -- CREATE TABLE customers ( -- id INTEGER NOT NULL PRIMARY KEY, -- name VARCHAR(30) NOT NULL, -- cardNum INTEGER -- ); -- CREATE TABLE accounts ( -- id INTEGER NOT NULL PRIMARY KEY, -- customer_id INTEGER NOT NULL, -- balance INTEGER, -- payment_system VARCHAR(30) NOT NULL, -- FOREIGN KEY (customer_id) REFERENCES customers(id) -- ); -- INSERT INTO customers(id, name, cardNum) values(1, 'Ivan the Terrible', 4532); -- INSERT INTO customers(id, name, cardNum) values(2, 'Catherine Romanova', 7764); -- INSERT INTO customers(id, name, cardNum) values(3, 'Nikolai Romanov', 2323); -- INSERT INTO customers(id, name, cardNum) values(4, 'Vladimir Lenin', 9970); -- INSERT INTO customers(id, name, cardNum) values(5, 'Leonid Brezhnev', 1231); -- INSERT INTO customers(id, name, cardNum) values(6, 'Boris Yeltsin', NULL); -- INSERT INTO accounts(id, customer_id, balance, payment_system) values(1, 1, 123.00, 'VISA'); -- INSERT INTO accounts(id, customer_id, balance, payment_system) values(2, 2, 555.00, 'VISA'); -- INSERT INTO accounts(id, customer_id, balance, payment_system) values(3, 4, 222.00, 'MasterCard'); -- INSERT INTO accounts(id, customer_id, balance, payment_system) values(4, 3, 333.00, 'MasterCard'); -- INSERT INTO accounts(id, customer_id, balance, payment_system) values(5, 5, 444.00, 'UnionPay'); -- INSERT INTO accounts(id, customer_id, balance, payment_system) values(6, 6, 0.00, 'UnionPay');

What is a many-to-many relationship in SQL? How is it implemented?

What HTTP response codes do you know? How can they be grouped?

What are *args and **kwargs? How do they work?