Quiz: Homicide/Art of Access Readings Part 2 and More

Quiz covering chapters 3, 4, 5 of “Homicide” and “Art of Access”. And some SQL.

Table of contents
Deadline
Tuesday, November 1 at 1:30 PM
Points
5 Quiz points
Deliverables

  • Fill out the answers on a blank sheet of paper!

Requirements

  • Write your SUNET id on the paper, please

This quiz has 6 questions.

Instructions

Writing on paper today!

  • A few questions from chapters 3, 4, 5, from Homicide.
  • 1 short-answer question from Art of Access
  • 2 questions involving writing SQL from scratch.

Questions

Question 1

For a homicide detective, what is “better than being good”?

A.

Great

B.

Methodical

C.

Rich

D.

Lucky

E.

Loved

Question 2

What is the cap on overtime pay for a Balitmore homicide detective before he/she’s taken off the rotation?

A.

50 percent of the detective’s base pay.

B.

$150,000

C.

$250,000

D.

20 percent of the detective’s base pay.

E.

100 percent of the detective’s base pay.

Question 3

Fill in the blanks for this aphorism about how murders are solved.

In reference to the color of money, and the colors by which open and solved murders are chronicled on the board, the rule states:

First they’re __. Then they’re green. Then they’re _____.

Question 4

Describe with a couple sentences what a retention schedule is, in regards to public records (Chapter 4: Art of Access). Feel free to include a few examples.

Question 5

Given a table named people that looks like this:

name age
Blair 40
Dani 60
Egon 20

Write a SQL query that selects from the people table and ends with this resulting table:

age
60

Question 6

Same table and format as the previous question, except write the query to get this result:

avg_age peeps
40 3

Hint: it requires a couple of aggregation functions and aliasing. But no GROUP BY.

Answers

1.

D. (Lucky)

2.

A (50 Percent of Base Pay)

3.

First they go "red"...then they go "green"...then they go "black"

4.

The retention schedule can be thought of as the "life span" of a public record. It dictates exactly how long, at a minimum, an agency must keep a public record before destroying it.

5.

  SELECT age
  FROM people
  WHERE age = 60;
6. 

  SELECT AVG(age) AS avg_age, 
    COUNT(*) AS peeps
  FROM people;