QA / QA Automation

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

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

-- 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');

We have a tuple where all elements are lists. If one of the lists is modified (append), will the tuple change?

What data types are immutable in Python?

Tell me about idempotency. Which methods are idempotent?

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

What is the 'element not found' error in UI automation tests? Where to look for the problem?

# 2. Python. Call a class function # Description: # Implement calling the print function of 2 classes: Parent, Child. # With two restrictions: 1 - cannot call Parent class directly by name. 2 - cannot change the behavior of Parent class # You can change the behavior of Child class # Output the result. # Input data: # class Parent: # def __init__(self): # print("Parent") # class Child(Parent): # def __init__(self): # print("Child") # Result: # Parent # Child

What are the main types of authentication you can name?

Boundary value task: the field accepts integers from -10 inclusive to 100 inclusive. What test cases would you write?

What types of expectations are there in UI autotests? What is the difference between explicit and implicit?