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 wants to combine first and last names into a single field in a dataset. Which SQL function would they use?
Correct answer: A) CONCATENATE
Explanation: The CONCATENATE function joins two or more text strings into one, making it suitable for combining first and last names. Other functions such as COUNT, SUM, and AVERAGE are used for numerical data processing.
Question 2 of 50
Which SQL clause would you use to filter data based on a specific condition in a query?
Correct answer: C) WHERE
Explanation: The WHERE clause is used in SQL to filter records that meet a specific condition. ORDER BY sorts the result, GROUP BY aggregates data, and HAVING filters grouped data.
Question 3 of 50
In a database, what is the purpose of a foreign key?
Correct answer: B) To link records between two tables
Explanation: A foreign key in a relational database links records in one table to the primary key in another table, establishing a relationship between the two tables.
Question 4 of 50
Which SQL clause is used to extract data from a specific column in a database?
Correct answer: A) SELECT
Explanation: The SELECT clause is used to extract specific columns of data from a database. WHERE filters data, ORDER BY sorts data, and INSERT INTO adds new data.
Question 5 of 50
What type of data represents true/false values?
Correct answer: A) Boolean
Explanation: Boolean data is used for values that can only be true or false, while strings, integers, and floats represent other types of data.
Question 6 of 50
Which SQL function can be used to count non-null entries in a column?
Correct answer: B) COUNT
Explanation: The COUNT function in SQL counts all non-null entries in a specified column. COUNTA is used in spreadsheets, and COUNTIF is for conditional counting in spreadsheets.
Question 7 of 50
What is the primary purpose of normalization in a database?
Correct answer: B) To eliminate data redundancy
Explanation: Normalization in databases is aimed at organizing data to reduce redundancy and dependency, ensuring consistency and efficiency.
Question 8 of 50
A data analyst is tasked with cleaning a dataset by removing duplicate entries. Which SQL keyword would they use?
Correct answer: A) DISTINCT
Explanation: The DISTINCT keyword is used in SQL to return only unique values, eliminating duplicates in the result set.
Question 9 of 50
In a dataset, what term is used to describe a value that falls significantly outside the expected range of values?
Correct answer: C) Outlier
Explanation: An outlier is a data point that differs significantly from the other values in a dataset, often due to errors or variability in the data.
Question 10 of 50
What is the difference between primary and foreign keys in a database?
Correct answer: B) A primary key uniquely identifies a record, while a foreign key links two tables
Explanation: A primary key uniquely identifies records within a table, while a foreign key is used to establish a link between two tables by referencing the primary key in another table.
Question 11 of 50
Which function would you use to return the number of cells in a range that contain a specific value in a spreadsheet?
Correct answer: A) COUNTIF
Explanation: The COUNTIF function is used to count cells in a range that meet a given condition, making it ideal for filtering specific data points.
Question 12 of 50
In data visualization, what type of chart is best suited for showing proportions of a whole?
Correct answer: C) Pie chart
Explanation: Pie charts are effective at displaying proportions or percentages of a whole by dividing a circle into slices, with each slice representing a category.
Question 13 of 50
What does a SQL CASE statement do?
Correct answer: C) Allows conditional logic in queries
Explanation: The CASE statement in SQL allows conditional logic to be applied within queries, such as returning different values based on a condition.
Question 14 of 50
Which function in a spreadsheet will add the values of a selected range of cells?
Correct answer: A) SUM
Explanation: The SUM function in spreadsheets adds together all the numerical values in a specified range of cells.
Question 15 of 50
Which SQL keyword is used to update records in a table?
Correct answer: C) UPDATE
Explanation: The UPDATE statement in SQL modifies existing records in a table, while SELECT retrieves data, DELETE removes records, and INSERT adds new records.
Question 16 of 50
A data analyst needs to store and organize large datasets across multiple departments. What tool should they use?
Correct answer: B) Database
Explanation: A database is a structured system designed to store, manage, and organize large datasets efficiently, especially across multiple departments.
Question 17 of 50
In a dataset, what does the term "continuous data" refer to?
Correct answer: B) Data that can take any value within a range
Explanation: Continuous data refers to numerical data that can take any value within a specified range, such as weight or height.
Question 18 of 50
Which spreadsheet function is used to count non-empty cells in a range?
Correct answer: C) COUNTA
Explanation: COUNTA is used to count the number of non-empty cells in a range, while COUNT counts only numeric values.
Question 19 of 50
Which term refers to a small piece of data stored on a user’s computer by a web browser?
Correct answer: B) Cookie
Explanation: A cookie is a small file stored on a user’s computer that holds data related to their browsing activity, such as login information or site preferences.
Question 20 of 50
What is a primary key's main function in a database?
Correct answer: C) It uniquely identifies each record
Explanation: A primary key is a unique identifier for each record in a table, ensuring that no two records have the same primary key value.
Question 21 of 50
Which SQL function removes leading and trailing spaces from a text string?
Correct answer: C) TRIM
Explanation: The TRIM function is used to remove any extra spaces from the beginning or end of a text string in SQL.
Question 22 of 50
Which data type is used to store whole numbers in a database?
Correct answer: B) Integer
Explanation: An integer is a data type that stores whole numbers, whereas floats store decimal numbers, strings store text, and Booleans store true/false values.
Question 23 of 50
A company's data analyst is analyzing sales over time. Which type of chart would be most effective?
Correct answer: B) Line chart
Explanation: Line charts are most effective for showing changes over time, such as sales trends or stock prices.
Question 24 of 50
What SQL clause is used to aggregate data by a specific field in a query?
Correct answer: B) GROUP BY
Explanation: The GROUP BY clause groups rows that have the same values in specified columns into summary rows, often used with aggregate functions like COUNT or SUM.
Question 25 of 50
What is the result of using the DISTINCT keyword in SQL?
Correct answer: A) It removes duplicates from the result set
Explanation: The DISTINCT keyword is used in SQL to return only unique values, eliminating any duplicate entries in the result set.
Question 26 of 50
Which SQL function calculates the number of records in a dataset?
Correct answer: B) COUNT
Explanation: The COUNT function is used to return the total number of records in a dataset.
Question 27 of 50
What is the purpose of a CSV file in data management?
Correct answer: C) To organize data in a table-like structure
Explanation: A CSV (Comma-Separated Values) file is a common format for storing tabular data, where each value is separated by a comma.
Question 28 of 50
What type of data is described as "nominal"?
Correct answer: B) Data that represents categories without a specific order
Explanation: Nominal data refers to categories that do not have a specific order or ranking, such as colors or types of animals.
Question 29 of 50
In a dataset, which term refers to the middle value when the data is arranged in order?
Correct answer: D) Median
Explanation: The median is the middle value of a dataset when the data is arranged in order. If the dataset has an even number of values, the median is the average of the two middle values.
Question 30 of 50
What type of error occurs when data is incorrectly processed due to an invalid assumption or bias?
Correct answer: C) Confirmation bias
Explanation: Confirmation bias occurs when an individual favors information that confirms their pre-existing beliefs, leading to errors in data interpretation.
Question 31 of 50
A company collects feedback from customers about their satisfaction with a product. What type of data is being collected?
Correct answer: C) Qualitative
Explanation: Qualitative data is descriptive and non-numerical, often used to gather information about opinions or experiences, such as customer feedback.
Question 32 of 50
In the context of data ethics, what is the principle of "ownership"?
Correct answer: B) Data is owned by the individual who provides it
Explanation: The principle of ownership in data ethics states that individuals have control over their own data and its usage, unless they provide consent otherwise.
Question 33 of 50
Which SQL function is used to convert data from one type to another?
Correct answer: B) CAST
Explanation: The CAST function is used in SQL to convert data from one datatype to another, such as converting a string to an integer.
Question 34 of 50
What is the role of a data analyst in ensuring data integrity?
Correct answer: B) Ensure data is accurate, complete, and consistent
Explanation: Data integrity refers to maintaining and ensuring the accuracy, consistency, and completeness of data throughout its lifecycle.
Question 35 of 50
What does the SQL function SUM do?
Correct answer: B) Adds all the values in a column
Explanation: The SUM function in SQL is used to calculate the total sum of a column's values.
Question 36 of 50
In data analysis, what is an "outlier"?
Correct answer: C) A value that lies significantly outside the range of other values
Explanation: An outlier is a data point that differs significantly from other observations, possibly indicating an error or a special case.
Question 37 of 50
Which of the following statements is true about relational databases?
Correct answer: C) They organize data into tables
Explanation: Relational databases organize data into tables (also called relations), where each table consists of rows and columns, making it easy to manage and retrieve information.
Question 38 of 50
Which spreadsheet tool is used to create visual summaries of large datasets?
Correct answer: A) Pivot table
Explanation: A pivot table is used to summarize large datasets by grouping, sorting, and filtering data, allowing for easy analysis and visualization.
Question 39 of 50
What SQL function is used to return the minimum value from a set of values?
Correct answer: C) MIN
Explanation: The MIN function in SQL returns the smallest value from a specified column in a dataset.
Question 40 of 50
What does the term "data governance" refer to?
Correct answer: B) Managing the people, processes, and tools used in data analysis
Explanation: Data governance is the framework for managing data, ensuring that it is accurate, secure, and used in compliance with organizational and legal standards.
Question 41 of 50
What spreadsheet function can be used to find the average of a specified range of values?
Correct answer: C) AVERAGE
Explanation: The AVERAGE function calculates the mean of a range of numerical values in a spreadsheet.
Question 42 of 50
In a relational database, what term refers to a unique identifier for each record in a table?
Correct answer: C) Primary key
Explanation: The primary key is a unique identifier for each record in a table, ensuring that no duplicate records exist.
Question 43 of 50
Which type of bias occurs when a sample is not representative of the entire population?
Correct answer: A) Sampling bias
Explanation: Sampling bias occurs when a sample is collected in such a way that it is not representative of the population being studied, leading to skewed results.
Question 44 of 50
What does the SQL keyword INSERT do?
Correct answer: B) Adds new records to a table
Explanation: The INSERT statement in SQL is used to add new rows (records) to a table.
Question 45 of 50
In the context of data ethics, what is the principle of "consent"?
Correct answer: B) Users should be informed about how their data will be used before it is collected
Explanation: The principle of consent in data ethics ensures that individuals are informed about how their personal data will be used and that they provide permission before the data is collected.
Question 46 of 50
What is the primary function of the COUNT function in SQL?
Correct answer: B) To return the total number of rows in a table
Explanation: The COUNT function in SQL returns the total number of rows that match a specified condition in a query.
Question 47 of 50
A company collects data about employee turnover. What type of data is this?
Correct answer: C) Quantitative
Explanation: Quantitative data is numerical and can be measured, such as employee turnover rates.
Question 48 of 50
What does a pivot table do in a spreadsheet?
Correct answer: B) Summarizes and reorganizes data for analysis
Explanation: A pivot table is a data summarization tool used in spreadsheets that allows for the quick organization, filtering, and analysis of large datasets.
Question 49 of 50
What is the key difference between first-party and third-party data?
Correct answer: A) First-party data is collected directly by the user, while third-party data is bought from external sources
Explanation: First-party data is collected by the organization or individual who will use it, while third-party data is typically purchased from external sources.
Question 50 of 50
What is the purpose of conditional formatting in a spreadsheet?
Correct answer: A) To change the appearance of cells based on specific conditions
Explanation: Conditional formatting in spreadsheets allows users to apply different formatting (such as color changes) to cells that meet specific criteria, improving data readability.
Set 1 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).