To select clients from the Customers table who have at least one order in the Orders table, which query will do this correctly? SELECT * FROM Customers WHERE id = (SELECT customer_id FROM Orders); SELECT * FROM Customers c JOIN Orders o ON c.id = o.customer_id; SELECT * FROM Customers, Orders WHERE Customers.id = Orders.id; SELECT * FROM Customers WHERE id IN (SELECT customer_id FROM Orders);
You mentioned mega services responsible for something. What exactly?
What does the HAVING operator do?
Have you used Requirements Yogi in Confluence?
Tell about your experience with integrations. Provide examples.
Have you worked with C4 before?
According to which standard did you describe the REST API? How to make POST idempotent?
Task: you are a marketplace analyst for selling tables. You need to implement a backend for a detailed information page for a specific table. What integration would you use and what should the analytics contain for the developer and tester?
What architectural components should a guitar tuning system consist of?
Have you ever faced a situation where the business insisted on a solution you considered wrong? How did you handle it?
Why are the warehouse, manufacturer, and supplier stored in separate tables rather than in the Table table?
Is a Jira project a tool or a project?
What types of data are there in JSON?
Employees work partly on hourly pay and partly on piecework pay. Their weekend pay formulas are different. Can they be combined into one calculation method or are two needed?
How do you understand the task of creating a unified technical database for a product?
What is the main problem of the chosen solution structure - Lack of semantic tags reduces accessibility and SEO effectiveness - No <h1> header on the page - Absence of <section> tag for block logic - Lack of structure in page sections - Buttons are not semantically grouped - Excessive nesting of <div> elements
How did requirements come? From the product side or other analysts?
Does your sales experience help you in your current role as an analyst?
Have you worked on projects from scratch or did you join an already running project?
Have you participated in analyzing and troubleshooting industrial environment (production) incidents?
