Pergunta de entrevista da empresa Kinertia

What does ALTER TABLE do? Moves a table from one database to another. Transposes the rows and columns in a table ***Modifies a table When there are multiple conditions and we need to choose something on the basis of these conditions, what function can we use? CASEBY ***WHEN IFTHEN JUMP What does the following SQL code do? SELECT name, MAX(salary) FROM Employees WHERE salary < (SELECT MAX(salary) FROM employees); (Notice the mistake in the question here... idiots testing us on concepts they don't know well) ***Returns all the rows that are less than the max salary Returns the row with the highest salary Returns the row with the second highest salary How do you execute a stored procedure in SQL? EXECUTE procedure_name PROCEDURE procedure_name RUN_PROC procedure_name ***EXEC procedure_name Which JOIN does the following: returns all the values from the right table, plus matched values from the left table or NULL in case of no matching join predicate. FULL OUTER JOIN LEFT JOIN INNER JOIN ***RIGHT JOIN In Google Analytics, what does the metric "Bounce Rate" represent? ***The percentage of visitors to your website who navigate away from the site after viewing only one page. The total number of times visitors returned to your website after their first visit. The number of new visitors to your website compared to the total number of visitors. answer (great, can't even have proper answer choices... the smartest people around) The average amount of time visitors spend on your website during a single session.