30 Data Science & SQL Quiz Questions & Answers

Warm-up questions on the basics of data science & sql, good for beginners and younger players.

1. 1

   What does SQL stand for in data management?

   ✅ Structured Query Language

   SQL (Structured Query Language) is the standard domain-specific language used to manage and query relational databases.

2. 2

   Which SQL keyword is used to extract data from a database table?

   ✅ SELECT

   The `SELECT` statement is used to fetch data from one or more database tables.

3. 3

   In Data Science, which Python library is most famous for dataframe manipulation and tabular data analysis?

   ✅ Pandas

   Pandas provides high-performance DataFrames and tools for analyzing structured numerical and categorical tables.

4. 4

   Which SQL clause is used to filter query results based on specified conditions?

   ✅ WHERE

   The `WHERE` clause filters rows before any grouping or aggregation takes place.

5. 5

   What type of chart is best suited for demonstrating trends over continuous time intervals?

   ✅ Line Chart

   Line charts effectively illustrate continuous trends and fluctuations over time.

6. 6

   In statistics, how is the 'Mean' of a numerical dataset calculated?

   ✅ The sum of all values divided by the count of values

   The mean (arithmetic average) equals the total sum divided by the number of observations.

7. 7

   What does CSV stand for in tabular data files?

   ✅ Comma-Separated Values

   CSV files store tabular data in plain text, with each line representing a record separated by commas.

8. 8

   In statistics, what is the 'Median' of a dataset?

   ✅ The middle score when values are arranged in ascending numerical order

   The median represents the exact 50th percentile mark separating the higher half from the lower half of data.

9. 9

   What is Data Cleaning (or Data Wrangling)?

   ✅ Detecting and correcting corrupt, incomplete, inaccurate, or duplicate data entries

   Data cleaning prepares raw data for analysis by addressing missing values, outliers, structural errors, and duplicates.

10. 10

    What is A/B Testing in data science and experimentation?

    ✅ A randomized experiment comparing two variants (A and B) to test statistical significance of a change

    A/B testing uses hypothesis testing to measure whether a variant produces a statistically significant change in user behavior.

Questions that go beyond the basics. A good test for regular quiz players.

11. 11

    What is Machine Learning?

    ✅ A branch of AI where systems learn pattern rules from data without explicit programming

    Machine Learning uses algorithms that discover patterns in historical data to make automated predictions.

12. 12

    Which core Python library provides fast multi-dimensional array operations and matrix math?

    ✅ NumPy

    NumPy (Numerical Python) is the foundational package for scientific computing in Python, providing n-dimensional arrays.

13. 13

    Which SQL clause sorts the returned records in ascending or descending order?

    ✅ ORDER BY

    The `ORDER BY` clause sorts result sets by specified columns (ASC by default, or DESC).

14. 14

    In SQL, which clause is required alongside aggregate functions like COUNT(), SUM(), or AVG() to group results by column?

    ✅ GROUP BY

    The `GROUP BY` statement groups rows that have the same values in specified columns into summary rows.

15. 15

    What is 'Overfitting' in machine learning models?

    ✅ When a model memorizes training data noise and fails to generalize on new unseen data

    Overfitting occurs when a model learns training data details and noise so closely that it negatively impacts new test data performance.

16. 16

    Which machine learning paradigm groups unlabeled data points together based on inherent feature similarities?

    ✅ Unsupervised Learning (Clustering)

    Unsupervised learning (e.g., K-Means clustering) analyzes unlabeled data to uncover hidden patterns or natural groupings.

17. 17

    What is a Confusion Matrix used for in classification data science?

    ✅ A table showing True Positives, False Positives, True Negatives, and False Negatives to evaluate model accuracy

    A confusion matrix reports performance of a classification model, calculating precision, recall, and F1-score.

18. 18

    Which SQL database constraint uniquely identifies each row in a table and cannot contain NULL values?

    ✅ PRIMARY KEY

    A PRIMARY KEY constraint enforces unique identification for table records and strictly prohibits NULL values.

19. 19

    What is a Box Plot (Box-and-Whisker plot) useful for in exploratory data analysis?

    ✅ Visualizing median, quartiles, interquartile range (IQR), and identifying data outliers

    Box plots provide a 5-number visual summary (Min, Q1, Median, Q3, Max) and highlight extreme outliers.

20. 20

    What is Gradient Descent in machine learning optimization?

    ✅ An algorithm that iteratively adjusts model parameters to minimize a cost/loss function

    Gradient descent calculates the gradient of the loss function to update model weights in the direction of steepest descent.

21. 21

    What is a Random Forest in machine learning?

    ✅ An ensemble learning method that constructs a multitude of decision trees and merges their predictions

    Random Forest combines decision trees trained on random data subsets (bagging) to improve accuracy and control overfitting.

22. 22

    What is Normalization (Min-Max Scaling) in feature engineering?

    ✅ Rescaling numerical feature values into a fixed range, typically between 0 and 1

    Min-Max scaling transforms features so that all values fit within [0, 1], preventing features with larger scales from dominating algorithms.

The toughest data science & sql questions in our bank, for experts and quiz-night finalists.

23. 23

    What is the difference between INNER JOIN and LEFT JOIN in SQL?

    ✅ INNER JOIN returns only matching rows; LEFT JOIN returns all rows from the left table plus matched rows

    INNER JOIN selects records with matching values in both tables. LEFT JOIN retains all records from the left table even if unmatched.

24. 24

    What is the key difference between WHERE and HAVING clauses in SQL?

    ✅ WHERE filters individual rows before grouping; HAVING filters aggregate groups after GROUP BY

    WHERE filters rows before aggregation occurs. HAVING filters summary rows after GROUP BY aggregations are calculated.

25. 25

    What is the Bias-Variance Tradeoff in machine learning models?

    ✅ Balancing underfitting caused by high bias against overfitting caused by high variance

    High bias causes underfitting (over-simplified models), while high variance causes overfitting (sensitivity to noise); tuning balances both.

26. 26

    In advanced SQL analytics, what is a Window Function (e.g., `ROW_NUMBER() OVER(PARTITION BY...)`)?

    ✅ A function performing calculations across a set of table rows related to the current row without collapsing them into a single row

    SQL Window functions compute values over row partitions while preserving individual row identity in the output.

27. 27

    What does the p-value represent in statistical hypothesis testing?

    ✅ The probability of obtaining results at least as extreme as observed, assuming the null hypothesis is true

    A low p-value (typically ≤ 0.05) indicates that the observed data is unlikely under the null hypothesis, leading to rejection of the null.

28. 28

    What is Principal Component Analysis (PCA)?

    ✅ A linear dimensionality reduction technique that transforms correlated features into uncorrelated principal components

    PCA reduces high-dimensional data feature spaces while retaining maximum variance across principal orthogonal axes.

29. 29

    In SQL databases, what does the `COALESCE()` function evaluate to?

    ✅ The first non-NULL value among its argument list

    `COALESCE(val1, val2, val3)` inspects arguments in order and returns the first argument that is not NULL.

30. 30

    In SQL, what is a Common Table Expression (CTE) defined using the `WITH` clause?

    ✅ A temporary named result set existing only within the execution scope of a query

    CTEs simplify complex queries by creating temporary named result sets that can be referenced within SELECT, INSERT, or UPDATE statements.