SQL SERVER AVANZADO - CLASE 1
Quiz
•
Science
•
3rd Grade
•
Medium
Alma Robles
Used 5+ times
FREE Resource
7 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Setencia que te permitirá agrupar los registros del resultado de un query
having
count
Group by
Select
2.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Selecciona la sintaxis correcta
Select select_list
from table_name
having condition
group by column_name1, column_name2
Select select_list
from
Table_name
Group by column_name1, column_name2
Select *
group by
from table_name
3.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Que función nos presenta el total de registros de un grupo
sum()
count()
AVG()
MIN() & MAX()
4.
MULTIPLE CHOICE QUESTION
45 sec • 1 pt
Que función, nos permite obtener el promedio de las cantidades de grupos
SUM()
AVG()
MIN()
MAX()
5.
MULTIPLE CHOICE QUESTION
45 sec • 2 pts
Sentencia de SQL que se utiliza con el group by para hacer filtrado de los grupos, basados en condiciones que se especifiquen
Where
Having
Distinct
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Operador que une 2 tablas y remueve todos aquellos registros duplicados entre dicha unión.
JOIN
UNION ALL
UNION
WHERE
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
OPERADOR que me sirve para unir 2 tablas y me presenta todos los registros de ambas sin eliminar duplicados.
UNION
UNION ALL
HAVING
JOIN
Similar Resources on Wayground
10 questions
Formação das Rochas - Sexto ano
Quiz
•
1st - 12th Grade
8 questions
TABLA PERIODICA
Quiz
•
1st - 12th Grade
10 questions
Estudo do Meio - 4º ano - 1
Quiz
•
3rd - 5th Grade
10 questions
Frecuencia Cardíaca
Quiz
•
2nd - 6th Grade
10 questions
Los estados de la materia
Quiz
•
1st - 7th Grade
10 questions
BAHAGI NG BALAT
Quiz
•
3rd Grade
10 questions
El ciclo del carbono
Quiz
•
1st - 3rd Grade
10 questions
Nutrición celular
Quiz
•
1st - 12th Grade
Popular Resources on Wayground
10 questions
Ice Breaker Trivia: Food from Around the World
Quiz
•
3rd - 12th Grade
20 questions
Halloween Trivia
Quiz
•
6th - 8th Grade
25 questions
Multiplication Facts
Quiz
•
5th Grade
4 questions
Activity set 10/24
Lesson
•
6th - 8th Grade
22 questions
Adding Integers
Quiz
•
6th Grade
10 questions
How to Email your Teacher
Quiz
•
Professional Development
15 questions
Order of Operations
Quiz
•
5th Grade
30 questions
October: Math Fluency: Multiply and Divide
Quiz
•
7th Grade
Discover more resources for Science
18 questions
Forms of Energy
Quiz
•
3rd Grade
18 questions
Pushes & Pulls
Quiz
•
1st - 4th Grade
20 questions
Force and Motion
Quiz
•
2nd - 5th Grade
20 questions
Force and Motion
Quiz
•
3rd - 4th Grade
10 questions
Exploring the Law of Conservation of Mass
Interactive video
•
1st - 5th Grade
25 questions
Forms of Energy MELTS
Quiz
•
3rd - 4th Grade
10 questions
Light Energy
Interactive video
•
3rd Grade
20 questions
Simple Machines
Quiz
•
3rd Grade
