Mysql consola - Operadores de comparación
Quiz
•
Mathematics
•
11th Grade
•
Medium
Standards-aligned
CARLOS CHELONI
Used 6+ times
FREE Resource
8 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
¿Cuál de las siguientes consultas te mostrará los empleados que trabajan menos de 180 horas al mes?
SELECT * FROM Empleados WHERE Horas_Mes > 180;
SELECT * FROM Empleados WHERE Horas_Mes = 180;
SELECT * FROM Empleados WHERE Horas_Mes BETWEEN 160 AND 200;
SELECT * FROM Empleados WHERE Horas_Mes < 180;
2.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
¿Qué consulta te mostrará los empleados que ganan más de 100,000?
SELECT * FROM Empleados WHERE Salario > 100000;
SELECT * FROM Empleados WHERE Salario < 100000;
SELECT * FROM Empleados WHERE Salario = 100000;
SELECT * FROM Empleados WHERE Salario BETWEEN 90000 AND 110000;
Tags
CCSS.6.SP.B.4
CCSS.HSS.ID.A.1
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
¿Cómo listarías los empleados cuyo puesto no es 'Técnico'?
SELECT * FROM Empleados WHERE Puesto != 'Técnico';
SELECT * FROM Empleados WHERE Puesto = 'Técnico';
SELECT * FROM Empleados WHERE Puesto LIKE 'Técnico';
SELECT * FROM Empleados WHERE Puesto IN ('Técnico');
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Qué consulta te mostrará los empleados que trabajan hasta 160 horas al mes (inclusive)?
SELECT * FROM Empleados WHERE Horas_Mes > 160;
SELECT * FROM Empleados WHERE Horas_Mes = 160;
SELECT * FROM Empleados WHERE Horas_Mes BETWEEN 140 AND 180;
SELECT * FROM Empleados WHERE Horas_Mes <= 160;
Tags
CCSS.6.SP.B.4
CCSS.HSS.ID.A.1
5.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
¿Cómo listarías los empleados que ganan al menos 120,000?
SELECT * FROM Empleados WHERE Salario >= 120000;
SELECT * FROM Empleados WHERE Salario < 120000;
SELECT * FROM Empleados WHERE Salario = 120000;
SELECT * FROM Empleados WHERE Salario BETWEEN 100000 AND 130000;
Tags
CCSS.6.SP.B.4
CCSS.HSS.ID.A.1
6.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
¿Qué consulta te permitiría listar a los empleados que trabajan entre 160 y 200 horas al mes (inclusive)?
SELECT * FROM Empleados WHERE Horas_Mes BETWEEN 160 AND 200;
SELECT * FROM Empleados WHERE Horas_Mes > 160 AND Horas_Mes < 200;
SELECT * FROM Empleados WHERE Horas_Mes = 160 OR Horas_Mes = 200;
SELECT * FROM Empleados WHERE Horas_Mes <= 160 OR Horas_Mes >= 200;
7.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
¿Cómo listarías los empleados cuyo nombre comienza con 'E'?
SELECT * FROM Empleados WHERE Nombre = 'E';
SELECT * FROM Empleados WHERE Nombre > 'E';
SELECT * FROM Empleados WHERE Nombre < 'E';
SELECT * FROM Empleados WHERE Nombre LIKE 'E%';
8.
MULTIPLE SELECT QUESTION
45 sec • 2 pts
¿Qué consulta te mostrará los empleados cuyo puesto es 'Técnico' o 'Administrativo'?
SELECT * FROM Empleados WHERE Puesto IN ('Técnico', 'Administrativo');
SELECT * FROM Empleados WHERE Puesto = 'Técnico' OR Puesto = 'Administrativo';
SELECT * FROM Empleados WHERE Puesto LIKE 'Técnico' OR Puesto LIKE 'Administrativo';
SELECT * FROM Empleados WHERE Puesto > 'Técnico' AND Puesto < 'Administrativo';
Similar Resources on Wayground
10 questions
MATEMÁTICAS FINANCIERAS
Quiz
•
University
11 questions
Gráficos
Quiz
•
University
10 questions
Finding the Gradient - given the function and x
Quiz
•
11th Grade - University
13 questions
Matematica para niños
Quiz
•
KG - 12th Grade
10 questions
Standard Form(Quiz)
Quiz
•
11th Grade
10 questions
Unilateral Bilateral
Quiz
•
University
10 questions
AULÃO
Quiz
•
9th - 12th Grade
13 questions
Evaluación de Matemáticas grado Once_4P
Quiz
•
11th Grade
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
11 questions
NEASC Extended Advisory
Lesson
•
9th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
10 questions
Boomer ⚡ Zoomer - Holiday Movies
Quiz
•
KG - University
25 questions
Multiplication Facts
Quiz
•
5th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
20 questions
Multiplying and Dividing Integers
Quiz
•
7th Grade
Discover more resources for Mathematics
15 questions
CCA 2 Ch 3 Review EV #1
Quiz
•
9th - 12th Grade
15 questions
TSI Math Practice Questions
Quiz
•
8th - 12th Grade
20 questions
Complete Geometric Angle Proofs
Quiz
•
9th - 12th Grade
10 questions
Angle Relationships with Parallel Lines and a Transversal
Quiz
•
9th - 12th Grade
20 questions
Midpoint & Distance Formula
Quiz
•
10th - 11th Grade
29 questions
DUA Review
Quiz
•
9th - 12th Grade
18 questions
083 - Corresponding, Alternate Interior, Alternate Exterior
Quiz
•
9th - 12th Grade
9 questions
Identify Angle Pairs With Parallel Lines And Transversals
Quiz
•
8th - 12th Grade