Quick Check 4.6 – Data 100, Summer 2020

JavaScript isn't enabled in your browser, so this file can't be opened. Enable and reload.

Which of the following are true? *

Databases are highly optimized for storage efficiency.

Databases are limited by memory size while Python is limited by disk size.

You can use the IN operator to test whether a value in a list.

You can cast strings to integers in SQL using the CAST keyword.

You can use the LIKE keyword in a WHERE clause.

Required

For which text values x below would this LIKE expression be true? x LIKE 'dog%' *

dog named cat

dogs and cats

cats and dogs

cat and dog

dog

Required

(Summer 2019 Midterm) For the following question consider the following tables. The trfc table contains one row per sensor recording of hourly average car speed in mph. The time column contains strings that encode the hour of day and whether the time occurred during rush hour. The dates table contains one row for all dates in 2019 with their days of the week.

Which of the following SQL queries would calculate the average speed during rush hour? *

SELECT AVG(spd) FROM trfc WHERE time LIKE '%yes';

SELECT AVG(spd) FROM trfc WHERE time LIKE 'yes%';

SELECT AVG(spd) FROM trfc WHERE time LIKE 'yes';

SELECT AVG(spd) FROM trfc WHERE time LIKE '%no';

Submit

Clear form

This form was created inside of UC Berkeley. Report Abuse

Forms