In SQL, which clause is used to filter records that meet a specified condition after aggregating data?
Correct answer:
B) HAVING
Explanation: The HAVING clause is used to filter records after the data has been aggregated in SQL.
In SQL, which clause is used to filter records that meet a specified condition after aggregating data?
Correct answer:
B) HAVING
Explanation: The HAVING clause is used to filter records after the data has been aggregated in SQL.
Which Excel function is used to return the middle part of a text string, starting at a specific position?
Correct answer:
A) MID
Explanation: The MID function returns a specific number of characters from the middle of a text string.
In R, which function is used to apply a function over a list or vector and return a list?
Correct answer:
A) lapply()
Explanation: The lapply() function applies a function to each element of a list or vector and returns a list in R.
In SQL, which function is used to return the first value in a set of records?
Correct answer:
D) FIRST_VALUE()
Explanation: The FIRST_VALUE() function returns the first value in a set of records in SQL.
Which Excel function would you use to remove unwanted spaces from a text string?
Correct answer:
A) TRIM
Explanation: The TRIM function removes extra spaces from a text string, except for single spaces between words.
In R, which function is used to merge two dataframes by matching rows based on one or more columns?
Correct answer:
A) merge()
Explanation: The merge() function in R merges two dataframes by matching rows based on one or more columns.
In SQL, which keyword is used to sort the results of a query in descending order?
Correct answer:
A) DESC
Explanation: The DESC keyword is used to sort the results of a query in descending order in SQL.
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 in Excel.
In R, which function is used to return a subset of rows from a dataframe based on logical conditions?
Correct answer:
A) filter()
Explanation: The filter() function in R returns a subset of rows from a dataframe based on specific conditions.
In SQL, which function is used to calculate the total number of rows that meet a specified condition?
Correct answer:
A) COUNT()
Explanation: The COUNT() function in SQL calculates the total number of rows that meet a specified condition.
Which Excel function is used 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 Excel.
In R, which function is used to apply a function to each column of a dataframe?
Correct answer:
A) apply()
Explanation: The apply() function applies a function to each column or row of a dataframe in R.
In SQL, which clause is used to combine rows from multiple tables while showing all records from both, including unmatched rows?
Correct answer:
A) FULL JOIN
Explanation: The FULL JOIN clause combines rows from multiple tables, showing all records from both, including unmatched rows.
Which Excel function is used to sum the values in cells based on multiple criteria?
Correct answer:
A) SUMIFS
Explanation: The SUMIFS function sums values in a range based on multiple criteria in Excel.
In R, which function is used to return a logical vector indicating whether each element is NA?
Correct answer:
A) is.na()
Explanation: The is.na() function in R checks whether each element of a vector is NA and returns a logical vector.
In SQL, which statement is used to remove an entire table from a database?
Correct answer:
A) DROP TABLE
Explanation: The DROP TABLE statement removes an entire table and all its data from the database in SQL.
Which Excel function would you use to round a number up to the nearest integer?
Correct answer:
A) CEILING
Explanation: The CEILING function rounds a number up to the nearest integer in Excel.
In R, which function is used to return the number of rows in a dataframe?
Correct answer:
A) nrow()
Explanation: The nrow() function returns the number of rows in a dataframe in R.
In SQL, which clause is used to select rows that do not meet a specified condition?
Correct answer:
A) NOT
Explanation: The NOT operator is used to exclude rows that do not meet a specified condition in SQL.
Which Excel function would you use to calculate the product of two or more numbers?
Correct answer:
A) PRODUCT
Explanation: The PRODUCT function multiplies two or more numbers in Excel and returns the result.
In R, which function is used to calculate the quantiles of a numeric vector?
Correct answer:
A) quantile()
Explanation: The quantile() function calculates the quantiles (percentiles) of a numeric vector in R.
In SQL, which function is used to combine multiple strings into one?
Correct answer:
A) CONCAT
Explanation: The CONCAT function is used to combine multiple strings into one in SQL.
Which Excel function would you use to return the smallest value in a range of cells?
Correct answer:
A) MIN
Explanation: The MIN function returns the smallest numeric value in a specified range of cells in Excel.
In R, which function would you use to create a bar plot?
Correct answer:
A) barplot()
Explanation: The barplot() function creates a bar plot in R using the values of a numeric vector.
In SQL, which keyword is used to limit the results returned by a query to unique values?
Correct answer:
A) DISTINCT
Explanation: The DISTINCT keyword ensures that only unique values are returned by a SQL query.
Which Excel function is used to calculate the sum of an array of numbers multiplied by another array of numbers?
Correct answer:
A) SUMPRODUCT
Explanation: The SUMPRODUCT function multiplies corresponding elements in two arrays and then sums the result.
In R, which function is used to sample random numbers or elements from a vector?
Correct answer:
A) sample()
Explanation: The sample() function returns a random sample of numbers or elements from a vector in R.
In SQL, which clause is used to filter rows that have matching values in two tables?
Correct answer:
A) INNER JOIN
Explanation: The INNER JOIN clause returns rows that have matching values in both tables in SQL.
Which Excel function would you use to return the position of a specific value within a range of cells?
Correct answer:
A) MATCH
Explanation: The MATCH function returns the relative position of a value within a specified range in Excel.
In R, which function is used to compute a cumulative sum of a vector?
Correct answer:
A) cumsum()
Explanation: The cumsum() function computes the cumulative sum of a numeric vector in R.
In SQL, which operator is used to check if a value exists within a range of values?
Correct answer:
A) BETWEEN
Explanation: The BETWEEN operator is used to check if a value exists within a specified range in SQL.
Which Excel function is used to return the largest value in a range that meets a specific condition?
Correct answer:
A) MAXIFS
Explanation: The MAXIFS function returns the largest value in a range that meets a specific condition in Excel.
In R, which function is used to plot a scatter plot?
Correct answer:
A) plot()
Explanation: The plot() function in R creates a scatter plot to visualize the relationship between two variables.
In SQL, which clause is used to specify the source table for a query?
Correct answer:
A) FROM
Explanation: The FROM clause specifies the source table or tables for a SQL query.
Which Excel function would you use to return the average of cells that meet multiple criteria?
Correct answer:
A) AVERAGEIFS
Explanation: The AVERAGEIFS function calculates the average of cells that meet multiple criteria in Excel.
In R, which function is used to combine vectors by columns?
Correct answer:
A) cbind()
Explanation: The cbind() function combines two or more vectors into columns in R.
In SQL, which function is used to extract a substring from a string?
Correct answer:
A) SUBSTRING
Explanation: The SUBSTRING function extracts a portion of a string from a specified start position and length in SQL.
Which Excel function is used to return the remainder after dividing two numbers?
Correct answer:
A) MOD
Explanation: The MOD function returns the remainder after dividing two numbers in Excel.
In R, which function is used to create a histogram?
Correct answer:
A) hist()
Explanation: The hist() function in R creates a histogram to visualize the distribution of data.
In SQL, which operator is used to search for a specific pattern in a column?
Correct answer:
A) LIKE
Explanation: The LIKE operator is used in SQL to search for a specified pattern in a column.
Which Excel function would you use to search for a value in the first column of a table and return a value from the same row in 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 another column.
In R, which function is used to return the number of columns in a dataframe?
Correct answer:
A) ncol()
Explanation: The ncol() function returns the number of columns in a dataframe in R.
In SQL, which clause is used to group rows that have the same values in specified columns?
Correct answer:
A) GROUP BY
Explanation: The GROUP BY clause is used to group rows that have the same values in specified columns in SQL.
Which Excel function would you use to replace part of a text string with a new string?
Correct answer:
A) SUBSTITUTE
Explanation: The SUBSTITUTE function replaces occurrences of a specific text in a string with a new string in Excel.
In R, which function is used to compute the logarithm of a number?
Correct answer:
A) log()
Explanation: The log() function computes the natural logarithm of a number in R.
In SQL, which statement is used to add a new column to an existing table?
Correct answer:
A) ALTER TABLE
Explanation: The ALTER TABLE statement is used to add a new column to an existing table in SQL.
Which Excel function would you use to return the rank of a number in a list of numbers?
Correct answer:
A) RANK
Explanation: The RANK function returns the rank of a number in a list of numbers in Excel.
In R, which function is used to replace NA values in a vector with a specified value?
Correct answer:
A) replace()
Explanation: The replace() function replaces NA values in a vector with a specified value in R.
In SQL, which function is used to calculate the average of a numeric column?
Correct answer:
A) AVG()
Explanation: The AVG() function calculates the average value of a numeric column in SQL.
Which Excel function would you use to calculate the number of days between two dates?
Correct answer:
A) DATEDIF
Explanation: The DATEDIF function calculates the number of days, months, or years between two dates in Excel.
If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.