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
Y12 1.03 Types of Samples
Quiz
•
12th Grade
11 questions
Ecuaciones
Quiz
•
University
10 questions
CALDIF_S5YS6_2024B
Quiz
•
11th Grade
12 questions
Ch 7 Trigonometric functions
Quiz
•
11th - 12th Grade
12 questions
equação exponencial
Quiz
•
3rd Grade - University
10 questions
Susulan
Quiz
•
University
12 questions
The Greatest Math Quiz On the Planet!
Quiz
•
8th Grade - Professio...
6 questions
Operaciones Básicas y Ecuaciones
Quiz
•
University
Popular Resources on Wayground
20 questions
Brand Labels
Quiz
•
5th - 12th Grade
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
20 questions
ELA Advisory Review
Quiz
•
7th Grade
15 questions
Subtracting Integers
Quiz
•
7th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
Multiplication and Division Unknowns
Quiz
•
3rd Grade
10 questions
Exploring Digital Citizenship Essentials
Interactive video
•
6th - 10th Grade
Discover more resources for Mathematics
29 questions
CCG 2.2.3 Area
Quiz
•
9th - 12th Grade
9 questions
Geometry and Trigonometry Concepts
Interactive video
•
9th - 12th Grade
17 questions
Analyze Real-World Inequalities and Graphs
Quiz
•
9th - 12th Grade
20 questions
Integer Operations
Quiz
•
6th - 12th Grade
18 questions
Solve Absolute Value Inequalities
Lesson
•
9th - 11th Grade
15 questions
Exterior Angle Theorem
Quiz
•
9th - 12th Grade
20 questions
Solving Absolute Value Equations
Quiz
•
11th - 12th Grade
9 questions
Proving lines are parallel using angles
Quiz
•
9th - 11th Grade