Test Your Knowledge On Using SQL With Large Datasets

.docx

School

Kaplan University *

*We aren’t endorsed by this school

Course

IN224

Subject

Electrical Engineering

Date

Jan 9, 2024

Type

docx

Pages

1

Uploaded by LieutenantTroutPerson859

Test Your Knowledge On Using SQL With Large Datasets 1. In MySQL, what is acceptable syntax for the SELECT keyword? Select all that apply. select (Correct) "SELECT" SELECT (Correct) 'SELECT' 2. A database table is named blueFlowers. What type of case is this? Lowercase Snake case Camel case (Correct) Sentence case 3. In BigQuery, what optional syntax can be removed from the following FROM clause without stopping the query from running? FROM 'bigquery-public-data.sunroof_solar.solar_potential_by_postal_code' Dashes Underscores Backticks (Correct) Dots 4. In the following FROM clause, what is the table name in the SQL query? FROM bigquery-public-data.sunroof_solar.solar_potential_by_postal_code public-data.sunroof solar.solar sunroof solar solar potential b postal code (Correct)
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help