50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.
0/50 answered0 correct
Question 1 of 50
A data analyst is tasked with finding all entries in a dataset where the values in the "price" column are above $50. Which SQL clause would they use?
Correct answer: C) WHERE
Explanation: The WHERE clause is used in SQL to filter records based on a specific condition, such as values above $50 in the "price" column.
Question 2 of 50
In data ethics, what does the principle of "transaction transparency" ensure?
Correct answer: B) Individuals must understand how their data is processed
Explanation: Transaction transparency ensures that data-processing activities are explainable and understood by the individual providing the data.
Question 3 of 50
A company wants to find out how many customers purchased a specific product. Which SQL function would they use to count these occurrences?
Correct answer: A) COUNT
Explanation: The COUNT function in SQL is used to return the total number of records that meet a specified condition, such as customers purchasing a specific product.
Question 4 of 50
Which SQL keyword would you use to remove duplicate records in a result set?
Correct answer: C) DISTINCT
Explanation: The DISTINCT keyword is used in SQL to remove duplicate records from the result set, returning only unique values.
Question 5 of 50
Which type of data is described as "discrete"?
Correct answer: B) Data that can only take specific values
Explanation: Discrete data can only take specific values, such as the number of students in a class, where fractional values are not possible.
Question 6 of 50
What does the term "data integrity" refer to?
Correct answer: A) The completeness, accuracy, and consistency of data
Explanation: Data integrity ensures that data is accurate, complete, and consistent throughout its lifecycle.
Question 7 of 50
What is the purpose of the SQL INSERT INTO statement?
Correct answer: C) To insert new records into a table
Explanation: The INSERT INTO statement in SQL is used to add new records to a specified table.
Question 8 of 50
A data analyst needs to calculate the total revenue from a sales dataset. Which SQL function should they use?
Correct answer: B) SUM
Explanation: The SUM function is used to calculate the total sum of values in a specified column, such as revenue in a sales dataset.
Question 9 of 50
Which spreadsheet function can count cells that meet a specific condition?
Correct answer: C) COUNTIF
Explanation: The COUNTIF function is used in spreadsheets to count cells that meet a specific condition, such as counting how many values are greater than a specified number.
Question 10 of 50
What type of chart is best suited for displaying changes over time?
Correct answer: C) Line chart
Explanation: Line charts are ideal for displaying trends or changes over time, such as monthly sales or stock prices.
Question 11 of 50
In a relational database, what is the role of a foreign key?
Correct answer: B) To link two tables
Explanation: A foreign key is used in a relational database to establish a relationship between two tables by referencing the primary key in another table.
Question 12 of 50
What type of SQL function is used to retrieve only non-null values from a list?
Correct answer: A) COALESCE
Explanation: The COALESCE function in SQL returns the first non-null value in a list of values.
Question 13 of 50
Which SQL keyword is used to remove records from a table?
Correct answer: A) DELETE
Explanation: The DELETE statement is used in SQL to remove records from a table based on a specified condition.
Question 14 of 50
What does the acronym CSV stand for in the context of data files?
Correct answer: C) Comma-Separated Values
Explanation: A CSV file stores tabular data in plain text where each value is separated by a comma.
Question 15 of 50
What is the purpose of the SQL SELECT statement?
Correct answer: C) To retrieve data from a table
Explanation: The SELECT statement is used in SQL to retrieve data from one or more tables in a database.
Question 16 of 50
Which spreadsheet function would you use to find the largest value in a range of cells?
Correct answer: A) MAX
Explanation: The MAX function returns the largest value in a specified range of cells in a spreadsheet.
Question 17 of 50
In the context of data ethics, what is the principle of "consent"?
Correct answer: C) Individuals must agree to the collection and use of their data
Explanation: The principle of consent in data ethics ensures that individuals are informed about how their data will be used and must provide permission before it is collected.
Question 18 of 50
What is the purpose of normalization in a database?
Correct answer: B) To reduce redundancy and improve data integrity
Explanation: Normalization reduces data redundancy and improves data integrity by organizing data into related tables.
Question 19 of 50
Which SQL function is used to return the average of a set of values?
Correct answer: D) AVG
Explanation: The AVG function calculates the average of a set of values in a specified column in SQL.
Question 20 of 50
Which SQL clause is used to sort the result set of a query?
Correct answer: C) ORDER BY
Explanation: The ORDER BY clause in SQL is used to sort the result set of a query by one or more columns.
Question 21 of 50
In data analysis, what is a "pivot table" used for?
Correct answer: A) To create a summary report of data
Explanation: A pivot table is used to summarize, group, and filter data, making it easier to analyze large datasets.
Question 22 of 50
Which SQL function returns the number of non-null records in a dataset?
Correct answer: A) COUNT
Explanation: The COUNT function returns the number of non-null records in a dataset, making it useful for counting the total number of entries.
Question 23 of 50
What is the purpose of the TRIM function in SQL?
Correct answer: B) To remove leading and trailing spaces from a text string
Explanation: The TRIM function is used to remove any leading or trailing spaces from a text string in SQL.
Question 24 of 50
What is the benefit of using first-party data in an analysis?
Correct answer: B) It is collected directly by the organization
Explanation: First-party data is collected directly by an organization from its own sources, making it more reliable for specific business insights.
Question 25 of 50
Which SQL statement would you use to modify existing data in a table?
Correct answer: C) UPDATE
Explanation: The UPDATE statement is used in SQL to modify existing records in a table based on specified conditions.
Question 26 of 50
In a dataset, what is an "outlier"?
Correct answer: B) A value that lies significantly outside the range of most other values
Explanation: An outlier is a data point that differs significantly from other values in the dataset, often indicating an anomaly.
Question 27 of 50
In a relational database, what is a "primary key"?
Correct answer: B) A unique identifier for each record in a table
Explanation: The primary key is a unique identifier for each record in a relational database table, ensuring that no two records are identical.
Question 28 of 50
What is the role of data governance in an organization?
Correct answer: B) To manage the people, processes, and tools for effective data management
Explanation: Data governance ensures the proper management of data within an organization, including data quality, security, and compliance.
Question 29 of 50
In a dataset, which type of data is classified as "qualitative"?
Correct answer: B) Data that represents categories or characteristics
Explanation: Qualitative data is descriptive and represents categories or characteristics, such as colors or types of products.
Question 30 of 50
What does the SQL JOIN operation do?
Correct answer: A) Combines rows from two or more tables
Explanation: The SQL JOIN operation is used to combine rows from two or more tables based on a related column between them.
Question 31 of 50
Which SQL clause is used to filter records based on specific conditions?
Correct answer: C) WHERE
Explanation: The WHERE clause is used in SQL to filter records based on specific conditions, such as values greater than a certain amount.
Question 32 of 50
What is the function of the COUNTIF spreadsheet function?
Correct answer: B) To count cells that meet a specific condition
Explanation: COUNTIF counts the number of cells in a range that meet a specific condition, such as cells containing values above a threshold.
Question 33 of 50
What type of bias occurs when a survey includes only specific groups, leaving others out?
Correct answer: C) Sampling bias
Explanation: Sampling bias occurs when certain groups in a population are overrepresented or underrepresented, leading to inaccurate survey results.
Question 34 of 50
In data ethics, what is the principle of "privacy"?
Correct answer: B) Individuals have the right to control how their data is used
Explanation: Privacy in data ethics refers to an individual’s right to control how their personal data is collected, stored, and used.
Question 35 of 50
Which of the following data types is classified as "continuous"?
Correct answer: B) Height of a person
Explanation: Continuous data can take any value within a range, such as height or temperature, whereas discrete data can only take specific values.
Question 36 of 50
What is the purpose of a VLOOKUP function in a spreadsheet?
Correct answer: C) To look up a value in a column and return corresponding data from another column
Explanation: VLOOKUP is used to search for a value in one column of a table and return corresponding data from another column.
Question 37 of 50
A data analyst wants to find the total number of non-empty cells in a range. Which function should they use?
Correct answer: B) COUNTA
Explanation: COUNTA counts the number of non-empty cells in a specified range, unlike COUNT, which counts only numeric cells.
Question 38 of 50
Which SQL function would you use to combine two or more text strings into one?
Correct answer: A) CONCAT
Explanation: The CONCAT function is used to concatenate, or join, two or more text strings into one string in SQL.
Question 39 of 50
What does the term "metadata" refer to in data management?
Correct answer: A) Data about data
Explanation: Metadata is descriptive information about data, such as the source, format, and creation date of the data.
Question 40 of 50
In a relational database, which term refers to a field in one table that refers to the primary key in another table?
Correct answer: A) Foreign key
Explanation: A foreign key in a relational database is a field in one table that refers to the primary key in another table, creating a relationship between the two tables.
Question 41 of 50
What does a confidence interval represent in statistical analysis?
Correct answer: A) The range within which the true population parameter is expected to lie
Explanation: A confidence interval provides a range of values that is likely to contain the true population parameter based on a sample from the population.
Question 42 of 50
What does the term "structured data" refer to?
Correct answer: A) Data that is organized in a specific format, such as rows and columns
Explanation: Structured data is highly organized and easily searchable, often stored in a tabular format like rows and columns in a database.
Question 43 of 50
Which SQL clause is used to combine records from two or more tables?
Correct answer: B) JOIN
Explanation: The JOIN clause in SQL is used to combine records from two or more tables based on a related column between them.
Question 44 of 50
In a data analysis project, why is it important to use reliable data sources?
Correct answer: B) To ensure that the analysis results are accurate and unbiased
Explanation: Using reliable data sources is crucial to ensuring the accuracy and objectivity of the analysis, leading to trustworthy results.
Question 45 of 50
What type of chart is best for comparing parts of a whole?
Correct answer: B) Pie chart
Explanation: Pie charts are effective for showing proportions and comparing parts of a whole, such as market share or budget distribution.
Question 46 of 50
In the context of data analysis, what does "bias" refer to?
Correct answer: B) A tendency to favor certain outcomes or interpretations
Explanation: Bias refers to a systematic tendency in data collection or analysis that can skew results in favor of a particular outcome or interpretation.
Question 47 of 50
What type of data is typically stored in a .csv file?
Correct answer: C) Tabular data
Explanation: CSV (Comma-Separated Values) files are used to store tabular data, where each value is separated by a comma.
Question 48 of 50
Which SQL function is used to return a substring from a string variable?
Correct answer: A) SUBSTR
Explanation: The SUBSTR function is used to extract a portion of a string variable, such as returning the first few characters of a text string.
Question 49 of 50
What does a pivot chart do in a spreadsheet?
Correct answer: B) Creates a visual representation of data summarized in a pivot table
Explanation: A pivot chart is a visual representation of the data that is summarized and organized in a pivot table, making it easier to identify trends and patterns.
Question 50 of 50
In the context of SQL, what is a "schema"?
Correct answer: B) A way of describing how data is organized in a database
Explanation: A schema is a structured description of how data is organized in a database, including the tables, columns, and relationships between them.
Set 2 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).