
Preguntas sobre SQL
Quiz
•
Computers
•
Professional Development
•
Practice Problem
•
Hard
María Sánchez
Used 1+ times
FREE Resource
Enhance your content in a minute
15 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Qué hace la función COUNT(*) en una consulta SQL?
Suma los valores de una columna.
Cuenta la cantidad de filas en una tabla.
Filtra los datos duplicados.
Ordena los resultados alfabéticamente.
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuál consulta muestra el número total de registros en la tabla clientes?
SELECT COUNT(*) FROM clientes;
SELECT SUM(*) FROM clientes;
SELECT TOTAL(*) FROM clientes;
SELECT NUM(*) FROM clientes;
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cómo se obtiene la suma de todos los salarios en la tabla empleados?
SELECT COUNT(salario) FROM empleados;
SELECT TOTAL(salario) FROM empleados;
SELECT SUM(salario) FROM empleados;
SELECT ADD(salario) FROM empleados;
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuál consulta devuelve los empleados con salario entre 30,000 y 50,000?
SELECT * FROM empleados WHERE salario = 30000 AND 50000;
SELECT * FROM empleados WHERE salario BETWEEN 30000 AND 50000;
SELECT * FROM empleados WHERE salario > 30000 40000 = 10 AND precio 100 ORDER BY precio ASC;
SELECT * FROM productos WHERE precio > 100 ORDER BY precio DESC;
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cómo contar cuántos clientes hay en la tabla clientes?
SELECT SUM(*) FROM clientes;
SELECT COUNT(*) FROM clientes;
SELECT TOTAL(*) FROM clientes;
SELECT NUM(*) FROM clientes;
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuál consulta devuelve los pedidos realizados entre '2023-01-01' y '2023-06-30'?
SELECT * FROM pedidos WHERE fecha BETWEEN '2023-01-01' AND '2023-06-30';
SELECT * FROM pedidos WHERE fecha > '2023-01-01' AND fecha 40000 ORDER BY salario ASC;
SELECT * FROM empleados WHERE salario >= 40000 ORDER BY salario DESC;
SELECT * FROM empleados WHERE salario BETWEEN 40000 AND 50000 ORDER BY salario ASC;
7.
MULTIPLE SELECT QUESTION
30 sec • 1 pt
¿Cómo obtener los clientes que realizaron compras en el año 2023?
SELECT * FROM compras WHERE fecha = '2023';
SELECT * FROM compras WHERE YEAR(fecha) = 2023;
SELECT * FROM compras WHERE fecha BETWEEN '2023-01-01' AND '2023-12-31';
SELECT * FROM compras WHERE fecha LIKE '2023%';
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports

Continue with Google

Continue with Email

Continue with Classlink

Continue with Clever
or continue with

Microsoft
%20(1).png)
Apple
Others
Already have an account?
Similar Resources on Wayground
10 questions
Operation Reliability
Quiz
•
Professional Development
11 questions
Computer Network Test
Quiz
•
University - Professi...
10 questions
UDC 2022
Quiz
•
Professional Development
17 questions
Rol del INFOTEP
Quiz
•
Professional Development
17 questions
Introduction to Computer Systems: Basic elements
Quiz
•
University - Professi...
10 questions
Git & Github
Quiz
•
Professional Development
11 questions
KOE034: Sensors and Instruments
Quiz
•
Professional Development
10 questions
Cloud computing 2
Quiz
•
Professional Development
Popular Resources on Wayground
15 questions
Fractions on a Number Line
Quiz
•
3rd Grade
20 questions
Equivalent Fractions
Quiz
•
3rd Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
54 questions
Analyzing Line Graphs & Tables
Quiz
•
4th Grade
22 questions
fractions
Quiz
•
3rd Grade
20 questions
Main Idea and Details
Quiz
•
5th Grade
20 questions
Context Clues
Quiz
•
6th Grade
15 questions
Equivalent Fractions
Quiz
•
4th Grade
Discover more resources for Computers
20 questions
Black History Month Trivia Game #1
Quiz
•
Professional Development
100 questions
Screening Test Customer Service
Quiz
•
Professional Development
20 questions
90s Cartoons
Quiz
•
Professional Development
10 questions
Reading a ruler in Inches
Quiz
•
4th Grade - Professio...
16 questions
Parallel, Perpendicular, and Intersecting Lines
Quiz
•
KG - Professional Dev...
12 questions
Valentines Day Trivia
Quiz
•
Professional Development
