New game
Download
SCORM download
To be used in an LMS (Moodle, Blackboard...)
Regular download
To be published on a website or blog.
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.
Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.
Get Academic Plan
If you wish, you can download a demo game here and test its integration:
Share game
Quiz
Quiz

Quiz JAVA 8 - SQL

Integrate it into your platform
G. Classroom M. Teams
You can integrate the game into an LMS compatible with LTI 1.1 or LTI 1.3 such as Canvas, Moodle, or Blackboard. This way, the scores will be automatically saved into the platform’s gradebook.
Download
You have exceeded the maximum number of games you can integrate into Google Classroom with your current Plan.

To integrate as many games as you want in Google Classroom, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
You have exceeded the maximum number of games you can integrate into Microsoft Teams with your current Plan.

To integrate as many games as you want in Microsoft Teams, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Downloading games is an exclusive feature for users with an Academic Plan or a Commercial Plan.

Get your Academic Plan or your Commercial Plan now and start integrating your games into your LMS, website or blog.

If you wish, you can download a demo game here and test its integration:

Get Academic Plan

Quiz JAVA 8 - SQL

Quiz

(15)
Played 36 %Accuracy 80 Average time 11:10
Create copy

About this activity

JAVA 8 - SQL

Created by

HR Mexico
HR Mexico
Mexico

Download the paper version to play

Make your own free game from our game creator
Compete against your friends to see who gets the best score in this game
Make challenge

Top Games

 %
Anonymous
Anonymous
 %
%
%
You have exceeded the maximum number of games you can print with your current Plan.

To print as many games as you want, you need an Academic Plan or a Commercial Plan.

Get Academic Plan
Print your game
Quiz JAVA 8 - SQL
 

Quiz JAVA 8 - SQLOnline version

JAVA 8 - SQL

by HR Mexico
1

¿Cuál es el resultado de una subconsulta correlacionada?

2

Dada la tabla Ventas(fecha, producto_id, cantidad, total), ¿cómo obtienes el producto más vendido en cada mes? ¿Qué tipo de subconsulta se está utilizando?

3

¿Cuál es la principal ventaja del uso de índices en SQL?

4

¿Qué hace la siguiente consulta?

5

¿Cuál es la diferencia entre RANK() y DENSE_RANK()?

6

¿Cuál de las siguientes consultas elimina registros duplicados?

7

¿Qué significa este fragmento?

8

¿Qué tipo de JOIN devuelve solo los registros coincidentes en ambas tablas?

9

¿Qué efecto tiene el índice en una columna con muchos valores repetidos (baja cardinalidad)?

10

¿Para qué se usa una CTE (Common Table Expression)?

11

¿Qué valor devuelve LAG(salario, 1) en una función de ventana?

12

¿Qué hace esta consulta?

13

¿Qué resultado produce un FULL OUTER JOIN?

14

¿Cuál es la ventaja de usar EXISTS frente a IN en subconsultas correlacionadas?

15

¿Qué devuelve esta consulta?

16

¿Cuál es la diferencia entre UNION y UNION ALL?

17

¿Cómo puedes optimizar esta consulta si la tabla ventas es muy grande?

18

¿Cuál sería el uso correcto de LEAD()?

19

¿Qué hace esta consulta con CTE recursiva?

20

¿Qué hace ROW_NUMBER()?

 
Are you sure you want to leave the page?

If you leave, you will lose the game in progress.