Prueba SQL para Analista de CRM [IMCRUZ]
SQL Skills Assessment for CRM Analysts
Put your SQL knowledge to the test with our engaging quiz designed specifically for CRM Analysts! Discover how well you understand SQL queries, procedures, and fun
- Covering essential SQL concepts
- Multiple choice questions for easy comprehension
- Evaluate your skills and identify areas for improvement
Para crear un procedimiento almacenado debemos emplear la sentencia:
CREATE PROCEDES
CREATE
CREATE PROCEDURE
CREATE PROCEDS
Seleccione la query que regrese todos los departamentos en la tabla (sin duplicados)
SALARIES ( Professor_Name (TEXT), Department (TEXT), Salary (INT) )
SELECT ALL Department FROM Salary;
SELECT DISTINCT Department FROM SALARIES;
SELECT DISTINCT Professor_Name FROM *;
SELECT FROM Department
Seleccione la query que regrese el nombre y salario de el profesor con el salario mas alto.
SALARIES ( Professor_Name (TEXT), Department (TEXT), Salary (INT) )
SELECT Professor_Name, MAX(Salary) FROM Department;
SELECT Professor_Name, MAX(Salary) FROM SALARIES;
SELECT MIN(Salary),Professor_Name, FROM Department;
Ninguna de las anteriores
Seleccione la query que regrese todos los nombres de profesores que inicien con la letra "C".
SALARIES ( Professor_Name (TEXT), Department (TEXT), Salary (INT) )
SELECT Professor_Name FROM SALARIES WHERE Professor_Name LIKE 'C%';
SELECT Professor_Name FROM SALARIES FROM Professor_Name LIKE 'C';
SELECT Professor_Name FROM SALARIES WHERE Professor_Name LIKE Salary;
SELECT Professor_Name WHERE SALARIES FROM Professor_Name LIKE 'C%';
Seleccione la query que regrese el departamento con el salario promedio más alto junto con ese salario promedio.
SALARIES ( Professor_Name (TEXT), Department (TEXT), Salary (INT) )
SELECT Department, AVG(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary);
SELECT Department, AVG(Salary) FROM SALARIES ORDER BY AVG(Salary) DESC LIMIT 1;
SELECT Department, AVG(Salary) FROM SALARIES GROUP BY AVG(Salary) DESC LIMIT 1;
SELECT Department, AVG(Salary) FROM SALARIES GROUP BY DEPARTMENT ORDER BY AVG(Salary) DESC LIMIT 1;
Comando DROP DATABASE se utiliza para crear una nueva base de datos vacía.
Verdadero
Falso
Sentencia para eliminar un Procedimiento Almacenado:
DELETE nombre_procedimiento
Verdadero
Falso
{"name":"Prueba SQL para Analista de CRM [IMCRUZ]", "url":"https://www.quiz-maker.com/QPREVIEW","txt":"Put your SQL knowledge to the test with our engaging quiz designed specifically for CRM Analysts! Discover how well you understand SQL queries, procedures, and functions.Covering essential SQL conceptsMultiple choice questions for easy comprehensionEvaluate your skills and identify areas for improvement","img":"https:/images/course6.png"}