Test SQL General - Test Examen - Examen - Test SQL General - Test OnLine

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.