new quiz

1) rot13 is an example of
a) encryption
b) decryption
c) a & b
d) none of the above

2) In Excel, what would be the R1C1 reference for B2, if I were standing in A1?
relative: R[1]C[1]
absolute: r2c2
e.g. mixed column-absolute: r[1]c2

3) $a5 is an example of a:
a) R1C1 reference
b) absolute reference
c) relative reference
d) mixed reference

4) The following:
Function MySum(X, Y)
    MySum = X + Y
End Function

is an example of a:

a) Javascript program
b) UDF
c) Excel formula
d) server-side script

5) Why might I want to index a foreign key?
faster, will need it often, to match to primary key


6) Consider the following SQL query, where Customers has 10 records and Employees has 20 records.
select * from Customers, Employees

How many records would be returned?
200 records


7) A JPEG uses a form of compression which is _____________.
lossy

8) Which of the following would be matched by the wildcard B*B? (Circle all that are correct.)

a) BOB
b) BIB
c) BB
d) BABY

9) What is an example of an Object oriented language?
C++, Smalltalk, Java