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
In SQL, which clause is used to combine rows from two or more tables based on a related column?
Correct answer: A) JOIN
Explanation: The JOIN clause combines rows from two or more tables based on a related column, allowing for data retrieval from multiple tables in a single query.
Question 2 of 50
Which Excel function is used to retrieve a value from a table, searching by a value in the first column and returning a value in the same row from another column?
Correct answer: A) VLOOKUP
Explanation: The VLOOKUP function searches for a value in the first column of a table and returns a value from the same row in a different column.
Question 3 of 50
In R, which function would you use to generate a sequence of repeated values?
Correct answer: A) rep()
Explanation: The rep() function in R is used to generate a sequence of repeated values.
Question 4 of 50
In SQL, which clause is used to specify the condition for filtering grouped rows?
Correct answer: A) HAVING
Explanation: The HAVING clause is used to filter grouped rows in SQL, usually in combination with the GROUP BY clause.
Question 5 of 50
Which Excel function counts the number of cells that meet a specific condition?
Correct answer: A) COUNTIF
Explanation: The COUNTIF function counts the number of cells in a range that meet a specific condition.
Question 6 of 50
In R, which function would you use to randomly select elements from a vector?
Correct answer: A) sample()
Explanation: The sample() function is used to randomly select elements from a vector in R.
Question 7 of 50
In SQL, which clause is used to limit the number of rows returned by a query?
Correct answer: A) LIMIT
Explanation: The LIMIT clause is used to limit the number of rows returned by a query in SQL.
Question 8 of 50
Which Excel function returns the number of numeric entries in a range of cells?
Correct answer: A) COUNT
Explanation: The COUNT function returns the number of cells in a range that contain numeric values.
Question 9 of 50
In R, which function would you use to calculate the standard deviation of a numeric vector?
Correct answer: A) sd()
Explanation: The sd() function calculates the standard deviation of a numeric vector in R.
Question 10 of 50
Which SQL function returns the first non-null value in a list of expressions?
Correct answer: A) COALESCE
Explanation: The COALESCE function returns the first non-null value from a list of expressions in SQL.
Question 11 of 50
Which Excel function is used to sum the values in a range that meet a specified condition?
Correct answer: A) SUMIF
Explanation: The SUMIF function sums the values in a range that meet a specific condition.
Question 12 of 50
In R, which function would you use to create a histogram?
Correct answer: A) hist()
Explanation: The hist() function in R creates a histogram from numeric data.
Question 13 of 50
In SQL, which operator is used to check if a value matches any value in a list?
Correct answer: A) IN
Explanation: The IN operator checks if a value matches any value in a specified list in SQL.
Question 14 of 50
Which Excel function would you use to count the number of non-empty cells in a range?
Correct answer: A) COUNTA
Explanation: The COUNTA function counts the number of non-empty cells in a specified range.
Question 15 of 50
In R, which function would you use to calculate the mean of a numeric vector?
Correct answer: A) mean()
Explanation: The mean() function in R calculates the arithmetic mean of a numeric vector.
Question 16 of 50
In SQL, which clause is used to group rows that have the same values into summary rows?
Correct answer: A) GROUP BY
Explanation: The GROUP BY clause is used to group rows that have the same values into summary rows in SQL.
Question 17 of 50
Which Excel function would you use to return the minimum value in a range of cells?
Correct answer: A) MIN
Explanation: The MIN function returns the smallest numeric value in a range of cells.
Question 18 of 50
In R, which function would you use to combine two dataframes by columns?
Correct answer: A) cbind()
Explanation: The cbind() function in R combines two dataframes by adding their columns together.
Question 19 of 50
Which SQL keyword is used to remove duplicate values from a result set?
Correct answer: A) DISTINCT
Explanation: The DISTINCT keyword ensures that only unique values are returned in a SQL query result.
Question 20 of 50
Which Excel function would you use to calculate the average of a range of values?
Correct answer: A) AVERAGE
Explanation: The AVERAGE function calculates the arithmetic mean of a range of values in Excel.
Question 21 of 50
In R, which function is used to create a boxplot?
Correct answer: A) boxplot()
Explanation: The boxplot() function in R creates a boxplot, which is used to display the distribution of data based on a five-number summary.
Question 22 of 50
In SQL, which function would you use to calculate the total sum of a numeric column?
Correct answer: A) SUM
Explanation: The SUM function calculates the total sum of a numeric column in SQL.
Question 23 of 50
Which Excel function returns the remainder when one number is divided by another?
Correct answer: A) MOD
Explanation: The MOD function returns the remainder when one number is divided by another in Excel.
Question 24 of 50
In R, which function is used to return the unique values of a vector?
Correct answer: A) unique()
Explanation: The unique() function returns the distinct values of a vector in R, excluding duplicates.
Question 25 of 50
In SQL, which statement is used to delete a specific row from a table?
Correct answer: A) DELETE
Explanation: The DELETE statement is used to remove specific rows from a table in SQL.
Question 26 of 50
Which Excel function would you use to round a number to a specified number of decimal places?
Correct answer: A) ROUND
Explanation: The ROUND function in Excel rounds a number to a specified number of decimal places.
Question 27 of 50
In R, which function would you use to create a scatter plot?
Correct answer: A) plot()
Explanation: The plot() function in R is used to create scatter plots and other types of visualizations.
Question 28 of 50
In SQL, which function is used to find the number of rows in a result set?
Correct answer: A) COUNT
Explanation: The COUNT function returns the number of rows in a result set in SQL.
Question 29 of 50
Which Excel function would you use to find the maximum value in a range of cells?
Correct answer: A) MAX
Explanation: The MAX function returns the highest numeric value in a range of cells in Excel.
Question 30 of 50
In R, which function is used to calculate the variance of a numeric vector?
Correct answer: A) var()
Explanation: The var() function calculates the variance of a numeric vector in R.
Question 31 of 50
In SQL, which keyword is used to combine the results of two SELECT statements into a single result set?
Correct answer: A) UNION
Explanation: The UNION keyword in SQL combines the results of two SELECT statements into a single result set.
Question 32 of 50
Which Excel function would you use to count the number of cells that contain numbers?
Correct answer: A) COUNT
Explanation: The COUNT function in Excel counts the number of cells in a range that contain numbers.
Question 33 of 50
In R, which function is used to bind dataframes by rows?
Correct answer: A) rbind()
Explanation: The rbind() function in R binds dataframes by adding rows.
Question 34 of 50
In SQL, which function returns the current date and time?
Correct answer: A) NOW()
Explanation: The NOW() function returns the current date and time in SQL.
Question 35 of 50
Which Excel function would you use to return the position of a value in a range of cells?
Correct answer: A) MATCH
Explanation: The MATCH function returns the relative position of a value in a range of cells in Excel.
Question 36 of 50
In R, which function would you use to calculate the median of a numeric vector?
Correct answer: A) median()
Explanation: The median() function in R calculates the median value of a numeric vector.
Question 37 of 50
In SQL, which function is used to remove leading and trailing spaces from a string?
Correct answer: A) TRIM
Explanation: The TRIM function removes leading and trailing spaces from a string in SQL.
Question 38 of 50
Which Excel function would you use to retrieve a value from a table by specifying a row and column number?
Correct answer: A) INDEX
Explanation: The INDEX function returns the value of a cell in a specified row and column within a table in Excel.
Question 39 of 50
In R, which function is used to sort a vector or dataframe?
Correct answer: A) sort()
Explanation: The sort() function in R sorts the elements of a vector or the rows of a dataframe.
Question 40 of 50
In SQL, which function is used to round a number to a specified number of decimal places?
Correct answer: A) ROUND
Explanation: The ROUND function rounds a number to a specified number of decimal places in SQL.
Question 41 of 50
Which Excel function is used to replace specific text in a string?
Correct answer: A) REPLACE
Explanation: The REPLACE function in Excel replaces specific text within a string.
Question 42 of 50
In R, which function is used to rename the columns of a dataframe?
Correct answer: A) colnames()
Explanation: The colnames() function in R is used to rename the columns of a dataframe.
Question 43 of 50
In SQL, which clause is used to filter the results of a query based on a specified condition?
Correct answer: A) WHERE
Explanation: The WHERE clause filters the results of a SQL query based on a specified condition.
Question 44 of 50
Which Excel function would you use to return a specific number of characters from a text string, starting from the left?
Correct answer: A) LEFT
Explanation: The LEFT function returns a specified number of characters from the left side of a text string in Excel.
Question 45 of 50
In R, which function is used to create a line plot?
Correct answer: A) plot()
Explanation: The plot() function is used to create line plots and other types of visualizations in R.
Question 46 of 50
In SQL, which function is used to return the largest value in a numeric column?
Correct answer: A) MAX
Explanation: The MAX function returns the largest numeric value in a specified column in SQL.
Question 47 of 50
Which Excel function would you use to join two or more text strings into one?
Correct answer: A) CONCATENATE
Explanation: The CONCATENATE function joins two or more text strings into one in Excel.
Question 48 of 50
In R, which function is used to select specific columns from a dataframe?
Correct answer: A) select()
Explanation: The select() function in R is used to select specific columns from a dataframe.
Question 49 of 50
In SQL, which statement is used to create a new table in a database?
Correct answer: A) CREATE TABLE
Explanation: The CREATE TABLE statement is used to create a new table in a SQL database.
Question 50 of 50
Which Excel function is used to return the position of a substring within a text string?
Correct answer: A) FIND
Explanation: The FIND function returns the position of a substring within a text string in Excel.
Set 4 complete
You scored 0%
0 correct out of 0 answered (50 questions in this set).