D465 Data Applications - Set 5 - 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 filter records that meet a specified condition after aggregating data?

WHERE

HAVING

ORDER BY

GROUP BY

Question 2: Which Excel function is used to return the middle part of a text string, starting at a specific position?

MID

LEFT

RIGHT

Question 3: In R, which function is used to apply a function over a list or vector and return a list?

lapply()

apply()

sapply()

map()

Question 4: In SQL, which function is used to return the first value in a set of records?

FIRST()

TOP()

MIN()

FIRST_VALUE()

Question 5: Which Excel function would you use to remove unwanted spaces from a text string?

TRIM

CLEAN

SUBSTITUTE

REPLACE

Question 6: In R, which function is used to merge two dataframes by matching rows based on one or more columns?

merge()

join()

combine()

rbind()

Question 7: In SQL, which keyword is used to sort the results of a query in descending order?

DESC

ASC

DOWN

REVERSE

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

COUNTA

COUNT

COUNTIF

SUM

Question 9: In R, which function is used to return a subset of rows from a dataframe based on logical conditions?

filter()

select()

subset()

arrange()

Question 10: In SQL, which function is used to calculate the total number of rows that meet a specified condition?

COUNT()

SUM()

AVG()

DISTINCT()

Question 11: Which Excel function is used to find the largest value in a range of cells?

MAX

MIN

SUM

AVERAGE

Question 12: In R, which function is used to apply a function to each column of a dataframe?

apply()

lapply()

sapply()

map()

Question 13: In SQL, which clause is used to combine rows from multiple tables while showing all records from both, including unmatched rows?

FULL JOIN

INNER JOIN

LEFT JOIN

RIGHT JOIN

Question 14: Which Excel function is used to sum the values in cells based on multiple criteria?

SUMIFS

COUNTIFS

AVERAGEIFS

SUMIF

Question 15: In R, which function is used to return a logical vector indicating whether each element is NA?

is.na()

is.null()

is.nan()

is.empty()

Question 16: In SQL, which statement is used to remove an entire table from a database?

DROP TABLE

DELETE TABLE

REMOVE TABLE

TRUNCATE TABLE

Question 17: Which Excel function would you use to round a number up to the nearest integer?

CEILING

ROUND

FLOOR

MOD

Question 18: In R, which function is used to return the number of rows in a dataframe?

nrow()

length()

dim()

ncol()

Question 19: In SQL, which clause is used to select rows that do not meet a specified condition?

NOT

EXCLUDE

HAVING

WHERE NOT

Question 20: Which Excel function would you use to calculate the product of two or more numbers?

PRODUCT

SUMPRODUCT

MULTIPLY

SUMIF

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