Search Header Logo

Consults Postgres I

Authored by Daniel Beffermann

Computers

Professional Development

Used 1+ times

Consults Postgres I
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

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)

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?