Search Header Logo

SQL Questions Quiz

Authored by Dolores Justo

Information Technology (IT)

11th Grade

Used 1+ times

SQL Questions Quiz
AI

AI Actions

Add similar questions

Adjust reading levels

Convert to real-world scenario

Translate activity

More...

    Content View

    Student View

15 questions

Show all answers

1.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

¿Qué instrucción SQL se utiliza para crear una nueva tabla llamada "cars" con las columnas "brand" y "model"?

CREATE DATABASE cars (brand VARCHAR(255), model VARCHAR(255));

CREATE TABLE cars (brand VARCHAR(255), model VARCHAR(255));

CREATE cars TABLE (brand VARCHAR(255), model VARCHAR(255));

CREATE NEW TABLE cars (brand VARCHAR(255), model VARCHAR(255));

2.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

2️⃣ ¿Cómo seleccionarías todas las columnas de la tabla "customers"?

SELECT all FROM customers;

SELECT * FROM customers;

SELECT customers FROM *;

SELECT ALL COLUMNS FROM customers;

3.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

3️⃣ ¿Qué cláusula se utiliza para filtrar los resultados de una consulta en PostgreSQL?

ORDER BY

GROUP BY

WHERE

HAVING

4.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

4️⃣ ¿Cómo ordenarías los resultados de la tabla "products" por el campo "price" de menor a mayor?

SELECT * FROM products ORDER BY price DESC;

SELECT * FROM products ORDER BY price ASC;

SELECT * FROM products SORT BY price;

SELECT * FROM products GROUP BY price;

5.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

5️⃣ ¿Qué operador se utiliza para comparar si un valor está dentro de un conjunto específico de valores?

BETWEEN

LIKE

IN

EXISTS

6.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

6️⃣ ¿Cuál es la función de agregación que devuelve el número total de filas en un conjunto de resultados?

SUM()

COUNT()

AVG()

TOTAL()

7.

MULTIPLE CHOICE QUESTION

30 sec • 1 pt

7️⃣ ¿Qué instrucción SQL se utiliza para eliminar una tabla llamada "orders"?

DELETE TABLE orders;

DROP TABLE orders;

REMOVE TABLE orders;

TRUNCATE TABLE orders;

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?