Quiz 4 questions

1) In a database, a record is roughly the equivalent of an Excel
a) column
b) row
c) cell
d) tab

2) The Access object which lets you modify records in a controlled manner is a:
a) query
b) table
c) form
d) report

3) Why would I want to make first name and last name indexes of a table?

4) A primary key is:
a) one used to lock a table
b) one used to unlock a table
c) used to uniquely identify a record in a table
d) a key used by an ape

5) Solver is better than Goal Seek because
a) it allows you to specify constraints
b) it allows you to fiddle with multiple cells
c) it allows you to seek maximums and minimums
d) all of the above

6) If I want a list of all people named Joshua whose age is more than 50, I would write:
a) SELECT LastName, SSN, Age, FirstName
FROM Customer
WHERE Age>50 AND FirstName="Joshua"
b) SELECT LastName, SSN, Age, FirstName
FROM Customer
WHERE Age>50 OR FirstName="Joshua"
c) UPDATE Customer
SET FirstName="Josh"
WHERE Age > 50

7) When Descartes turned down a beer in a bar,
a) he appeared
b) he reappeared
c) he disappeared
d) none of the above

8) The Internet is the same as the Web:
a) true
b) false

9) Explain

10) In http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol,
the http is the
a) protocol
b) filename
c) hypertext
d) widget

11) In http://en.wikipedia.org/wiki/Hypertext_Transfer_Protocol, the domain is:
a) http
b) en.wikipedia.org
c) wikipedia.org
d) org

12) An example of a top level domain is:
a) .edu
b) .co
c) yahoo.com
d) www