Sobes.tech

System Analyst

It would be incorrect: - You can send a body in a GET request - POST requests can be sent without a body - PUT completely overwrites the existing resource or creates a new one if absent - The UPDATE method partially updates the resource's state - DELETE is idempotent

216

There is a SOAP service. Which of the edits will not cause errors in existing clients? - Rename the existing element phone → msisdn - Change the type from string to int for an existing element - Change the namespace of the schema/operations - Add a new optional element (minOccurs="0") to an existing type - None of the options will avoid errors

215

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

185

Condition: NUMBER is a positive number and should not fall within the range from 5 to 10 inclusive. Expression: NOT (NUMBER < 0) AND ((NUMBER > 10) AND (NUMBER < 5))

183
/3