SQL Quiz 01

Which SQL clause is used to group rows that have the same values into summary rows?

1. GROUP BY
2. HAVING
3. WHERE
4. SELECT

Which command would you use to modify the structure of an existing table?

1. CREATE
2. ALTER
3. UPDATE
4. DROP

Which SQL keyword would you use to retrieve data from a specific table?

1. WHERE
2. SELECT
3. GROUP BY
4. HAVING

Which clause in SQL restricts the result set to meet specific conditions before grouping?

1. GROUP BY
2. WHERE
3. HAVING
4. SELECT

BigQuery is typically used for what purpose?

1. Data Modeling
2. Data Storage
3. Large-scale data analysis
4. Real-time data collection

Model evaluation involves which of the following activities?

1. Selecting a model based on intuition
2. Validating the model with testing data
3. Presenting results to stakeholders
4. Collecting business requirements

In SQL, which of the following keywords is used to arrange query results in a specific order?

1. ORDER
2. SORT
3. ORDER BY
4. SEQUENCE

In SQL, which of the following data types would you use to store large text data like a paragraph?

1. Integer
2. VARCHAR
3. Text
4. Float

Which SQL clause is used to filter records after aggregating data?

1. WHERE
2. GROUP BY
3. HAVING
4. SELECT

Which of the following steps is most critical for ensuring the integrity of a model’s predictions?

1. Prepare Data
2. Data Visualization
3. Model Evaluation
4. Understanding Business

Which data analysis type is used to provide recommendations for actions based on predictive data?

1. Diagnostic Analysis
2. Prescriptive Analysis
3. Predictive Analysis
4. Descriptive Analysis

To find the average salary of employees in each department, which combination of clauses is most appropriate?

1. SELECT, WHERE
2. GROUP BY, ORDER BY
3. SELECT, GROUP BY
4. HAVING, ORDER BY

Which statement about BigQuery Sandbox is accurate?

1. It requires a paid subscription
2. It offers limited free usage for students and researchers
3. It does not allow any form of data analysis
4. It is only available to corporate users

In SQL, which data type would you use to store a name like “John Doe”?

1. Integer
2. Float
3. Text
4. Object

Which type of data analysis is primarily focused on identifying what happened based on historical data?

1. Diagnostic Analysis
2. Descriptive Analysis
3. Predictive Analysis
4. Prescriptive Analysis

The GRANT command is part of which SQL category?

1. Data Query Language
2. Transaction Control Language
3. Data Control Language
4. Data Definition Language

Which feature of BigQuery allows users to analyze data without loading it directly into a database?

1. Data Pipeline
2. Data Transfer Service
3. Federated Queries
4. Sandbox Mode

Which SQL type is used to define, alter, or delete data structures?

1. Data Query Language
2. Data Control Language
3. Data Definition Language
4. Transaction Control Language

Which SQL command is used to permanently remove all rows from a table without logging individual row deletions?

1. DELETE
2. TRUNCATE
3. DROP
4. ALTER

In SQL, which command permanently removes a table from a database?

1. DROP
2. DELETE
3. TRUNCATE
4. CLEAR

Which clause is used to sort the results of a query in ascending or descending order?

1. GROUP BY
2. ORDER BY
3. HAVING
4. SELECT

Which type of analysis seeks to understand the root cause of a specific data outcome?

1. Descriptive Analysis
2. Diagnostic Analysis
3. Predictive Analysis
4. Prescriptive Analysis

In SQL, which command is used to remove duplicate rows from the result set?

1. DISTINCT
2. UNIQUE
3. COUNT
4. FILTER

Which phase of the data analytics lifecycle involves cleaning and transforming raw data?

1. Data Modeling
2. Model Evaluation
3. Data Visualization
4. Prepare Data

Which SQL clause would you use to specify the source table in a query?

1. WHERE
2. SELECT
3. FROM
4. HAVING