FIT100 Review Questions
In general the answers to these questions can be found in
the textbook and/or the lecture notes.
-
List
the five fundamental operations on database tables.
- Give
a database schema (table declaration) for the following table instance
- Every
column of the DB in (2) is unique; why is ID the best choice for a key?
- For
the DB in (2) write a select command to pick out the row for Wooster.
- For
the DB in (2) write a project command for a 2 column table of last name
and first day on the job.
- What
condition must be fulfilled before two tables can be unioned together.
- Is
the condition of (6) also required for (a) difference? (b) product? and
(c) join?
- Suppose
A has 4 columns and 70 rows, and B has 6 columns and 100 rows. How many
columns and rows does A´B
have?
- Using
the five fundamental operations write the join of A and B when fields
A.name and B.team are the same. [Hint, you need to use product, select and
project.]
- What
is “redundancy” in a database and why is it bad?
- Explain
the difference between the physical and logical databases.
- What
kind of relationship (e.g. 1-1) is the relationship of hometowns to
people?
- What
kind of relationship is the relationship of eye color to FIT100 students?
- Rewrite
(4) in SQL.
- Rewrite
(5) in SQL.
- What
is the purpose of the “needs analysis” task used in designing databases?
- List
the tables in your SLAMA database and say which are physical tables and
which are logical tables.
[Remember, your forms use tables.]
- In
the SLAMA DB what was the purpose of the tracking number?
- In
the SLAMA DB there are addresses in the Suspects table and addresses in
the Officer table. Since it is possible for a police officer to be
arrested, is this an example of redundancy? Explain.
- T/F:
Virus protection software is useless because viruses are always new.
Explain.
- Using
the “password guidelines” of Chapter 12, develop a good password,
explaining the steps you go through.
- Give
two rules of “netiquette” and explain why they are good rules to follow.
- What
is risky about opening email attachments you receive from unknown senders?
- T/F:
Even though all of the materials on the FIT100 web site are copyrighted,
it is OK for you to have a personal copy of them. Explain.
- What
is “Fair Use” in copyright, and does it allow you to use copyrighted material
as long as you don’t try to sell it?
- Define
privacy.
- What
are “Fair Information Practices?”
(You don’t have to list them.)
- Explain
what Opt-In/Opt-Out mean in the context of privacy.
- What
does it mean to say “clients and servers have only a brief relationship”?
- What
is a cookie?
- Besides
www.girlscouts.org, what kind of Web site might you accept a cookie
from?
- Give
the three steps for animating GIFs and explain what each does.
- Explain
the sentence, ”Once a page is loaded, nothing happens until an event
occurs.”
- Describe
the series of tasks required to create the Orange Concentrate application.
- What
decimal number corresponds to the binary number: 1 0011 0111
- Add
together the binary numbers: 0010
1100 + 1010 0100
- In
RGB representation when all of the intensities are the same, e.g.
(128,128,128), what color is produced?
- What
is the binary representation of the decimal number 99?
- What
is the Bias-free Universal Medium principle?
- What
are two advantages key advantages of digital encodings? [Not given in
lecture.]
- Give
an example of “computing on a representation”.
- Use a
Caesar Cipher to encode the phrase, “And you too Brutus”
- Describe
the set-up for a Turing Test.
- Explain
the sentence, “It’s intelligent behavior, until it’s known to be
algorithmic.”
- Give
the guidelines for debugging.
- Write
the HTML to link to a file turn.html on
the phrase “submit your homework”.
- For
an HTML file called page.html, show the image tag to place a picture
photo.jpg if the photo is in the directory “above” the directory containing
page.html.
- Name
and identify the three main parts of the URL,
http://www.cs.washington.edu/homes/snyder/index.html
- Show
a world famous iteration to loop ten times.
- Give
the HTML for a one row, three column table containing the information,
Time, Life, Fortune.
- What
does a program counter (PC) do in a computer?
- Write
an assignment statement to add one to a variable, but if doing so makes it
greater than 9 it should be 0. That is, the variable should only be a
one-digit number.
- Show
a declaration for an array with 3 elements, and assign each element an
initial value of, in order, “alpha”, “bravo”, “charlie”.
- What
is the name for the point where indexing begins?
- Write
a query to find Web pages containing at least two of the last three
letters NATO alphabet (X-ray, Yankee, Zulu).
- Write
a function that has one parameter, a distance in miles, and computes that
distance in many yards, i.e. it multiplies by 5,280 and divides the result
by 3.
- Write
a function that has one parameter that is a year, and returns “Leap Year”
or “Normal Year”. We will define a
year to be a leap year if it is divisible by 4, but not divisible by 100.
- Write
an if-statement that assigns the
Boolean variable Octogenarian the
value “yes” if the variable Age is in the interval 80-89, and “no” otherwise.
- What
is your favorite music group?
- Draw
a diagram of the structure of a public key cryptosystem.