
Examen Final SQL 101

Quiz
•
Professional Development
•
Professional Development
•
Easy
e delgadillo
Used 5+ times
FREE Resource
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Por favor indica que Linea de Código proporciona todos los resultados posibles de una columna sin repetición y/o filas duplicadas
SELECT JUST()
SELECT UNIQUE()
SELECT ONLY()
SELECT DISTINCT()
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Comando utilizado para añadir una restricción y/o para filtrar filas
WHERE Columna = 'restricción'
GROUP BY Columna = 'restricción'
AND Columna = 'restricción'
FROM Columna = 'restricción'
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Selecciona la información de ciertas columnas ordenando los resultados de forma ascendente o descendente:
ORDER BY Columna ASC/DESC
GROUP BY Columna ASC/DESC
SELECT BY Columna ASC/DESC
ORDER FROM Columna ASC/DESC
4.
MULTIPLE CHOICE QUESTION
3 mins • 1 pt
Indica cuál es el código correcto: "Proporciona todos los modelos de automóvil disponibles sin repetición" (Hint: usa la base de datos "bd_registro")
SELECT DISTINCT(Automovil)
FROM bd_registro
SELECT UNIQUE(Automovil)
FROM bd_registro
SELECT Automovil
FROM bd_registro
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Indica el código que proporciona el promedio GENERAL del precio observado. (HINT la respuesta contiene 1 dato)
SELECT AVG(Precio) AS promedio
FROM bd_registro
SELECT Automovil,AVG(Precio) AS promedio
FROM bd_registro
GROUP BY Automovil
SELECT Marca,AVG(Precio) AS promedio
FROM bd_registro
GROUP BY Marca
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
Indica el código que proporciona el promedio del precio por Modelo de Automóvil. (HINT: la respuesta contiene varios datos)
SELECT AVG(Precio) AS promedio
FROM bd_registro
SELECT Automovil,AVG(Precio) AS promedio
FROM bd_registro
GROUP BY Automovil
SELECT Marca,AVG(Precio) AS promedio
FROM bd_registro
GROUP BY Marca
7.
MULTIPLE SELECT QUESTION
45 sec • 1 pt
Menciona TODAS las opciones que sean funciones de SQL .
MIN()
AVG()
NEXT()
BEFORE()
COUNT()
SUM()
ONE()
POINT()
Create a free account and access millions of resources
Similar Resources on Wayground
7 questions
PLATAFORMAS APRENDIZAJE

Quiz
•
Professional Development
10 questions
Tema 6 AHV

Quiz
•
Professional Development
15 questions
EXAMEN DE NIVELACION

Quiz
•
Professional Development
6 questions
Capacitación coordinaciones proyecto PREAD

Quiz
•
Professional Development
15 questions
La Creación de la Empresa

Quiz
•
Professional Development
12 questions
¿ERES UN AUTÉNTICO REPUBLICANO?

Quiz
•
1st Grade - Professio...
10 questions
QUIZ 26/07/2023

Quiz
•
Professional Development
10 questions
SEGUNDO PARCIAL - CONTABILIDAD

Quiz
•
Professional Development
Popular Resources on Wayground
10 questions
Video Games

Quiz
•
6th - 12th Grade
10 questions
Lab Safety Procedures and Guidelines

Interactive video
•
6th - 10th Grade
25 questions
Multiplication Facts

Quiz
•
5th Grade
10 questions
UPDATED FOREST Kindness 9-22

Lesson
•
9th - 12th Grade
22 questions
Adding Integers

Quiz
•
6th Grade
15 questions
Subtracting Integers

Quiz
•
7th Grade
20 questions
US Constitution Quiz

Quiz
•
11th Grade
10 questions
Exploring Digital Citizenship Essentials

Interactive video
•
6th - 10th Grade