Clase 30-12-2024
Authored by DAPHNE YASMIN ORIHUELA ARANGUREN
Other
Professional Development
Used 1+ times
AI Actions
Add similar questions
Adjust reading levels
Convert to real-world scenario
Translate activity
More...
Content View
Student View
10 questions
Show all answers
1.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Qué instrucción selecciona todas las columnas de la tabla bigquery-public-data.crypto_bitcoin.transactions?
SELECT all FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT columns FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT ALL COLUMNS FROM bigquery-public-data.crypto_bitcoin.transactions
2.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cómo seleccionas únicamente las columnas size y block_number de la tabla?
SELECT size AND block_number FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT size, block_number FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT {size, block_number} FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT size OR block_number FROM bigquery-public-data.crypto_bitcoin.transactions
3.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Qué consulta renombra la columna size como transaction_size?
SELECT size AS transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT size RENAME transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT size, transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT transaction_size FROM bigquery-public-data.crypto_bitcoin.transactions
4.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cómo calculas el promedio del tamaño de las transacciones (size) en la tabla?
SELECT AVERAGE(size) FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT AVG(size) FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT MEAN(size) FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT AVG OF size FROM bigquery-public-data.crypto_bitcoin.transactions
5.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cuál consulta devuelve el número total de transacciones en la tabla?
SELECT COUNT(*) FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT SUM(*) FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT TOTAL(*) FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT COUNT(ALL) FROM bigquery-public-data.crypto_bitcoin.transactions
6.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cómo ordenas las transacciones por tamaño (size) de forma descendente?
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions ORDER BY size
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions SORT BY size DESC
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions ORDER BY size DESC
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions SORT DESC BY size
7.
MULTIPLE CHOICE QUESTION
30 sec • 1 pt
¿Cómo seleccionas las transacciones con un tamaño mayor a 500 bytes?
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions WHERE size > 500
SELECT * FROM bigquery-public-data.crypto_bitcoin.transactions FILTER size > 500
SELECT size > 500 FROM bigquery-public-data.crypto_bitcoin.transactions
SELECT * WHERE size > 500 FROM bigquery-public-data.crypto_bitcoin.transactions
Access all questions and much more by creating a free account
Create resources
Host any resource
Get auto-graded reports
Continue with Google
Continue with Email
Continue with Classlink
Continue with Clever
or continue with
Microsoft
%20(1).png)
Apple
Others
Already have an account?
