Test SQL General

1. Para crear un procedimiento almacenado debemos emplear la sentencia:

• CREATE PROCEDES
• CREATE
• CREATE PROCEDURE
• CREATE PROCEDS

2. Escriba un query que regrese todos los departamentos en la table (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

3. Escriba una 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

4. Escriba un 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%';

5. Escriba una 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;

6. Comando DROP DATABASE se utiliza para crear una nueva base de datos vacía.

• Verdadero
• Falso

7. Sentencia para eliminar un Procedimiento Almacenado:

Delete nombre_procedimiento

• Verdadero
• Falso

8. Comando que se utiliza para ver campos vacíos o desconocidos.