SQL - Consultas sin JOIN
Quiz
•
Computers
•
Professional Development
•
Practice Problem
•
Hard
ALVARO RODRIGUEZ RUIZ
Used 5+ times
FREE Resource
Enhance your content in a minute
9 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Qué valor devuelve: Select titulo from PELICULAS where genero LIKE 'Comedia';
Hulk
Spider
300
Sohan
'Empty Set'
2.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Qué valor devuelve: Select direccion from COMPANIAS where id >3;
1
2
3
4
'Empty Set'
3.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consulta para obtener el nombre de la película más larga
Select titulo from PELICULAS where longitudMinutos = MAX(*);
Select titulo from PELICULAS order by longitudMinutos DESC limit 1;
Select titulo from PELICULAS order by longitudMinutos limit 1;
Select nombre from PELICULAS where longitudMinutos = 1100;
4.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consulta para obtener Alumnos matriculados en "Ingeniería civil informatica"
Select nombre from alumnos where id_Carrera = (Select id_carrera from carreras where carrera LIKE 'Ingeniería civil informatica')
Select nombre from alumnos where carrera LIKE 'Ingeniería civil informatica';
Select nombre from alumnos where id_carrera = C2100;
Select nombre from alumnos where id_Carrera = (Select avg(*) from carreras where carrera LIKE 'Ingeniería civil informatica')
5.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consulta para obtener el numero de cursos que tenemos registrados
Select numeroCursos from cursos;
Select numeroCursos from cursos where codigo IS NOT NULL;
Select count (*) from cursos;
Select count (*) from cursos group by curso;
6.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Consulta para obtener el numero de alumnos matriculados en cada carrera
Select count (*) from carreras group by id_carrera;
Select count (*) from alumnos group by id_carrera;
Select count (*), id_carrera from carreras group by id_carrera;
Select count (*), id_carrera from alumnos group by id_carrera;
7.
MULTIPLE CHOICE QUESTION
1 min • 1 pt
Qué valor devuelve: select numero-cuenta, max (saldo) from cuenta;
Un número de cuenta y su saldo
El número de cuenta con el saldo máximo
Un número de cuenta y el saldo máximo
Un número de cuenta y el saldo mínimo
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
Table relationships, SQL and Pandas joins
Quiz
•
Professional Development
10 questions
CyberCrime
Quiz
•
5th Grade - Professio...
10 questions
DP-100 Day 2
Quiz
•
University - Professi...
10 questions
MS-900 - Module 1 - Full quiz
Quiz
•
Professional Development
11 questions
ВебДиз4
Quiz
•
Professional Development
10 questions
Power BI Essentials
Quiz
•
Professional Development
11 questions
5. Echo - Query And ORM
Quiz
•
Professional Development
10 questions
Name that App/Site
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
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
20 questions
Figurative Language Review
Quiz
•
6th Grade
Discover more resources for Computers
10 questions
How to Email your Teacher
Quiz
•
Professional Development
6 questions
3RD GRADE DECLARATION OF INDEPENDENCE EXIT TICKET
Quiz
•
Professional Development
19 questions
Black History Month Trivia
Quiz
•
6th Grade - Professio...
22 questions
Multiplying Exponents with the Same Base
Quiz
•
9th Grade - Professio...
40 questions
Flags of the World
Quiz
•
KG - Professional Dev...
