Examen BBDD SQL

Examen BBDD SQL

Professional Development

30 Qs

quiz-placeholder

Similar activities

Google Level 1 Certification

Google Level 1 Certification

Professional Development

32 Qs

WJEC Image Editing

WJEC Image Editing

KG - Professional Development

25 Qs

NETWORKS

NETWORKS

Professional Development

25 Qs

CAMP_CODING_SIMKESKHANZA

CAMP_CODING_SIMKESKHANZA

University - Professional Development

25 Qs

CNS_Semi-Final Quiiiz

CNS_Semi-Final Quiiiz

Professional Development

25 Qs

Quiz 3 REMEDIAL Selling HPE AI & As-a-Service Solutions Module 4

Quiz 3 REMEDIAL Selling HPE AI & As-a-Service Solutions Module 4

Professional Development

25 Qs

Principles of coding

Principles of coding

Professional Development

25 Qs

Excel Certification Practice test

Excel Certification Practice test

Professional Development

30 Qs

Examen BBDD SQL

Examen BBDD SQL

Assessment

Quiz

Computers

Professional Development

Practice Problem

Medium

Created by

Carlos López

Used 30+ times

FREE Resource

AI

Enhance your content in a minute

Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...

30 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Las únicas claúsulas OBLIGATORIAS en una query de SQL son,

SELECT, FROM, WHERE

SELECT, FROM, WHERE, ORDER BY

SELECT, FROM, WHERE, GROUP BY, ORDER BY

SELECT, FROM

2.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Indica cuándo puede existir la cláusula GROUP BY en SQL.

Siempre

Solamente cuando haya una cláusula HAVING previa

Solamente cuando haya una cláusula HAVING posterior

Solamente cuando haya una cláusula WHERE

3.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Para añadir una expresión como columna en la SELECT pondremos el texto,

Entre comillas simples

Entre comillas dobles

Sin comillas de ningún tipo

En mayúsculas

4.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Selecciona la forma correcta de usar un alias de columna en las SELECT

Con la palabra AS

Con comillas dobles

Con la palabra AS y con comillas dobles

Todas las anteriores son correctas

5.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Indica las cláusulas dónde se pueden sustituir valores/campos por SELECT

SELECT, FROM, WHERE

SELECT, FROM, WHERE, GROUP BY

SELECT, FROM, WHERE, HAVING

SELECT, FROM, WHERE, ORDER BY

6.

FILL IN THE BLANK QUESTION

1 min • 1 pt

Completa la query para reducir el salario un 25%.

SELECT SAL*0.__ FROM EMP;

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

Para convertir los nulos en SQL usamos la función,

NVL

NULL

ROUND

AVG

Access all questions and much more by creating a free account

Create resources

Host any resource

Get auto-graded reports

Google

Continue with Google

Email

Continue with Email

Classlink

Continue with Classlink

Clever

Continue with Clever

or continue with

Microsoft

Microsoft

Apple

Apple

Others

Others

Already have an account?