D465 Data Applications - Set 4 - Part 1

Test your knowledge of technical writing concepts with these practice questions. Each question includes detailed explanations to help you understand the correct answers.

Question 1: In SQL, which clause is used to combine rows from two or more tables based on a related column?

JOIN

GROUP BY

WHERE

ORDER BY

Question 2: 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?

VLOOKUP

HLOOKUP

INDEX

MATCH

Question 3: In R, which function would you use to generate a sequence of repeated values?

rep()

seq()

sample()

repeat()

Question 4: In SQL, which clause is used to specify the condition for filtering grouped rows?

HAVING

WHERE

GROUP BY

ORDER BY

Question 5: Which Excel function counts the number of cells that meet a specific condition?

COUNTIF

SUMIF

AVERAGEIF

COUNTA

Question 6: In R, which function would you use to randomly select elements from a vector?

sample()

seq()

rep()

sort()

Question 7: In SQL, which clause is used to limit the number of rows returned by a query?

LIMIT

WHERE

GROUP BY

HAVING

Question 8: Which Excel function returns the number of numeric entries in a range of cells?

COUNT

COUNTA

COUNTIF

SUM

Question 9: In R, which function would you use to calculate the standard deviation of a numeric vector?

sd()

var()

sum()

mean()

Question 10: Which SQL function returns the first non-null value in a list of expressions?

COALESCE

NULLIF

ISNULL

NVL

Question 11: Which Excel function is used to sum the values in a range that meet a specified condition?

SUMIF

COUNTIF

AVERAGEIF

MAXIF

Question 12: In R, which function would you use to create a histogram?

hist()

ggplot()

geom_histogram()

plot()

Question 13: In SQL, which operator is used to check if a value matches any value in a list?

BETWEEN

EXISTS

Question 14: Which Excel function would you use to count the number of non-empty cells in a range?

COUNTA

COUNT

COUNTIF

SUM

Question 15: In R, which function would you use to calculate the mean of a numeric vector?

mean()

sum()

median()

sd()

Question 16: In SQL, which clause is used to group rows that have the same values into summary rows?

GROUP BY

ORDER BY

HAVING

DISTINCT

Question 17: Which Excel function would you use to return the minimum value in a range of cells?

MIN

MAX

AVERAGE

SUM

Question 18: In R, which function would you use to combine two dataframes by columns?

cbind()

rbind()

merge()

append()

Question 19: Which SQL keyword is used to remove duplicate values from a result set?

DISTINCT

UNIQUE

COUNT

LIMIT

Question 20: Which Excel function would you use to calculate the average of a range of values?

AVERAGE

SUM

COUNT

MEDIAN

Need Guaranteed Results?

Our exam support service guarantees you'll pass your OA on the first attempt. Pay only after you pass!

Get Exam Support