Consults Postgres I

Consults Postgres I

Professional Development

7 Qs

quiz-placeholder

Similar activities

TCH_Induction

TCH_Induction

Professional Development

12 Qs

1 - Introducing SCRUM in SAFe

1 - Introducing SCRUM in SAFe

Professional Development

10 Qs

Pre Test CTIA

Pre Test CTIA

Professional Development

10 Qs

online sharing

online sharing

Professional Development

10 Qs

Types of Mass Media

Types of Mass Media

10th Grade - Professional Development

11 Qs

Gamefication in Learning

Gamefication in Learning

Professional Development

10 Qs

SQL Commands - SELECT Statements

SQL Commands - SELECT Statements

Professional Development

10 Qs

Tema 2 Unidades funcionales

Tema 2 Unidades funcionales

Professional Development

10 Qs

Consults Postgres I

Consults Postgres I

Assessment

Quiz

Computers

Professional Development

Practice Problem

Hard

Created by

Daniel Beffermann

Used 1+ times

FREE Resource

AI

Enhance your content in a minute

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

7 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

¿Qué consulta seleccionaría todos los registros cuya columna C4 sea true?

SELECT * FROM tabla WHERE C4 = true;
SELECT * FROM tabla WHERE C4 = 1;
c) SELECT * FROM tabla WHERE C4 = 'true';
d) SELECT * FROM tabla WHERE C4 = '1';

2.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

¿Qué consulta seleccionaría los 2 primeros registros?

SELECT * FROM tabla LIMIT 2;
SELECT * FROM tabla WHERE rownum <= 2;

SELECT * FROM tabla WHERE rownum < 2;

SELECT * FROM tabla WHERE rownum = 2;

3.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

¿Qué consulta ordenaría todos los registros por orden decreciente en la columna c2?

SELECT * FROM tabla ORDER BY c2 DESC;
SELECT * FROM tabla ORDER BY c2 ASC;

SELECT * FROM tabla ORDER BY c2 DESCENDING;

SELECT * FROM tabla ORDER BY c2 ASCENDING;

4.

MULTIPLE CHOICE QUESTION

45 sec • 1 pt

¿Qué sucede si ejecutamos el comando UPDATE SET C2 = 0;?

Se actualiza la columna C2 de todos los registros a 0.
Se actualiza la columna C2 de todos los registros a NULL.

Se produce un error porque no se especifica la condición de actualización.

Se produce un error porque no se especifica la tabla a actualizar.

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

¿Qué consulta actualizaría el valor de la columna C5 a 'NuevoValor' para todos los registros?

UPDATE tabla SET C5 = "NuevoValor";

UPDATE tabla SET C5 = NuevoValor;

UPDATE * SET C5 = NuevoValor;

UPDATE tabla SET C5 = 'NuevoValor';

6.

MULTIPLE SELECT QUESTION

45 sec • 1 pt

¿Qué consulta eliminaría todos los registros de la tabla?

DELETE * FROM tabla;

DELETE FROM tabla WHERE 1=1;

c) DELETE FROM tabla;

d) DELETE FROM tabla WHERE true;

7.

MULTIPLE CHOICE QUESTION

1 min • 1 pt

¿Qué consulta borraría los 2 registros con c1 más altos de la tabla?

DELETE FROM tu_tabla where c1 in (1, 2)
DELETE FROM tu_tabla WHERE c1 ORDER BY c1 DESC LIMIT 2;

SELECT c1 FROM tu_tabla ORDER BY c1 DESC LIMIT 2;

DELETE FROM tu_tabla where c1 in (SELECT c1 FROM tu_tabla ORDER BY c1 DESC LIMIT 2)