Data Analytics Week 3 Quiz

Which SQL clause is used to specify the columns that should be included in the result set?

• JOIN

• WHERE

• SELECT

• FROM

Which SQL clause is used to filter the result set to include only rows that meet a specified condition?

• SELECT

• WHERE

• HAVING

• ORDER BY

Which SQL clause is used to combine rows from two or more tables, based on a related column between them?

• SELECT

• JOIN

• GROUP BY

• ON

Which dplyr function is used to add new columns or modify existing columns in a data frame?

• filter

• mutate

• semi_join

• slice_max

Which dplyr function is used to combine two data frames by matching rows based on common columns?

• merge_rows

• bind_rows

• full_join

• inner_join

In RStudio, where can you view and interact with graphical output from your R scripts?

• Console

• Environment

• Source

• Plots

Which pane in RStudio displays the variables, data frames, and other objects currently in the workspace?

• Help

• Environment

• Console

• Plots

Which ggplot2 function is used to initialize a ggplot object and specify the data and aesthetic mappings?

• geom_point()

• aes()

• ggplot()

• geom_line()

Which ggplot2 function is used to add points to a scatter plot?

• geom_bar()

• geom_histogram()

• geom_point()

• geom_boxplot()

Which ggplot2 function is used to specify the aesthetic mappings (like x, y, color, etc.) within a ggplot object?

• geom_point()

• ggplot()

• facet_wrap()

• aes()