Quiz 10: Policies and Information

Location, Date, and Time

Conflicts: There will be no conflict quiz as students are able to choose the time and date of their quiz.

Quiz Content

All quizzes are cumulative. Previous material can reappear on a later quiz.

9.1: Adv SQL

Provided with: SQLite Cheatsheet


  • How does DBI allow us to translate data from R to a Database?
  • Why is there a difference between remote and local versions of data?
  • Why might it be beneficial to break up a selection query?

SQL Joins:

  • What are the different joining paradigms possible?
  • How do the joining paradigms differ from each other?
  • What happens if we only join on one key that repeatedly exists in a database?
  • Why are JOIN ... USING ( ... ) INNER JOIN ... ON ...?


  • What does dbplyr do?
  • How is dbplyr useful when connected with dplyr?
  • What are some ways to tell if dbplyr is being used or not?
  • Why might we not want to use dbplyr if we know SQL?

SQL Injection:

  • What is a SQL injection and why do they occur?
  • Why are SQL injections harmful?
  • How can we project against a SQL injection?

9.2: Web APIs

HTTP(S) Requests:

  • How is an HTTP request formed?
  • What is a URI?
  • How is a URI different from a URL?
  • Why is it preferred to dynamically download files vs. manually downloading them?

Web + APIs:

  • Why should you use a Web API over Scraping content from a website?
  • How are Web APIs similar to functions?
  • What is an endpoint?
  • Why is a web URI broken down into two different components?

httr with REST:

  • What are the different components of an HTTP response?
  • How are HTTP verbs used to access and retrieve data in a Data API?
  • Which component should always be checked prior to looking at the data?
  • Why do we need to encode special symbols inside a URL?


  • What is JSON?
  • Why is JSON used with web APIs?
  • What R data structure most closely matches to JSON’s format?

Materials Needed

  • Preferably, a rested mind and non-broken hands that can type.


  • All answers must be reasonably simplified.
  • Decimals answers must contain two significant digits.
  • Grading will be done as follows:
    • A correct answer will receive all points.
    • An incorrect answer will receive proportionally appropriate partial credit.

If you have a technical issue while answering questions or need assistance with opening or starting the quiz, please alert the proctor.

Do not leave the CBTF without filing an issue with the proctor if something goes wrong.


Have a testing accommodation? Please see how the CBTF handles Letters of Accommodation.

The short version: Please bring a copy of the Letter of Accommodation to the CBTF Proctors prior to the test taking place.

Academic Integrity

In short, don’t cheat. Keep your eyes on your own quiz. Do not discuss the quiz with your friends after you have taken it. Any violation will be punished as harshly as possible.

Advice for Studying

The best way to study for a STAT 385 quiz is by writing and reading code. Try to take an idea in STAT 385 and apply it to your own work.

With this being said, there are three other resources that may assist your studies:

  • Topic Outline (Above)
  • Lecture Code
  • Homework

Again, the best way to study is to do programming in some fashion. Whether that be writing code or explaining how code works to someone else.

Consider using resources such as:

  1. RStudio Cloud Primers for interactive practice.
  2. Exercise problems listed in a given section of the readings.

Do not spend time memorizing lecture slides. You will not see any verbatim questions.

Do not try pulling an all-nighter. You can schedule your quiz anytime between a time window. To program efficiently, you need sleep despite the quote:

“Programmers are an organism that turns caffeine into code.”

Frequently Asked Questions

What kind of question types are on the quiz?

There are generally four types of problems:

  • True / False
  • Multiple Selection (e.g. select ALL correct answers from a list)
  • Fill in the blank
  • Writing Code

How many problems are on the quiz?

Only one question with 15012391 subquestions. In all seriousness, do not fixate on a number. There will be a reasonable amount of questions for the time period.

How long will it take to do the quiz?

Depending on your background, the quiz may take:

  • Prior R in-depth experience: 25 minutes
  • Some R experience: 35 minutes
  • No R experience: 50 minutes

Avoid fixating on time. Life will come and go more quickly than you realize. Focus more on the content.

When will the quiz be returned?

As all problems are automatically graded, we should be able to post the quiz results after the examination window closes.

Will the quiz be curved?


We got our grades back, now will the quiz be curved?

No. Curving is only done sparingly at the end of the semester. Individual assignments are not modified.